Prepare constraint for partitioning ci_pipeline_variables
What does this MR do and why?
- This MR introduces a check constraint on
ci_pipeline_variables
where the validation is synchronous, to handle self-managed instances - It also refactors the
revert_preparation_for_partitioning
helper, to be able to handle cases where the check constraint doesn't exist. This need arized in this MR, when migrating down, migration20240111134328
would fail as the check constraint was already removed from the migration introduced in this MR. See here for more context
MR acceptance checklist
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
Related to #428989 (closed)
Edited by Panos Kanellidis