Skip to content

Add table and model for container registry data repair details

Adie (she/her) requested to merge 390842-add-data-repair-table into master

What does this MR do and why?

This MR is the first step for Restore missing container repositories under ex... (#390842). This MR adds the table that will be used for the data repair strategy. The needed schema is outlined in #390842:

New temporary table with columns project_id (FK for projects), missing_count (int), status (text), and updated_at. For brevity, we'll refer to this table as t.

This table will be temporary and will be deleted after the data repair is complete. The data repair is to continue to the next milestone.

How to set up and validate locally

You may run the migrations locally with:

bin/rails db:migrate:main RAILS_ENV=development (or replace main with ci)

And the result will be something like the following:

== 20230305093018 CreateContainerRegistryDataRepairDetails: migrating =========
-- create_table(:container_registry_data_repair_details)
-- quote_column_name(:status)
   -> 0.0001s
   -> 0.0100s
== 20230305093018 CreateContainerRegistryDataRepairDetails: migrated (0.3236s)

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #390842

Edited by Adie (she/her)

Merge request reports