catalyst
Custom database query at post-wash should have options for both UAT and Staging sites.
We are in a situation where we require some advanced manipulation of our moodle database, specifically the configuration of some of our LTI tools. This does not seem possible to do just using the environment matrix.
We decided to opt for a custom database query at post-wash to solve our issue (i.e at https://example.moodle.ca/admin/settings.php?section=cleaner_custom_sql_post ). But because the query we need to run on staging will be slightly different than the query we run on UAT, we cannot use this.
We looked around to see if datacleaner or mdl_config stored anywhere in the db which site it was running on, to take advantage of that, but didn't find anything.
It'd be really nice to add a feature to have a custom sql box per site environment, if needed.
@nickbwuzhere have you looked at the environment matrix sub-plugin? I think you can have a separate post-wash SQL for separate environments. https://github.com/catalyst/moodle-local_datacleaner/tree/MOODLE_311_STABLE/cleaner/environment_matrix
