From dec60fc4d3838a34977b659ddd902d4f3b400c20 Mon Sep 17 00:00:00 2001 From: Tianwen Chen Date: Thu, 16 Feb 2023 16:56:35 +1100 Subject: [PATCH 1/2] Prepare async foreign key validation for ci_job_artifacts As titled, see https://gitlab.com/gitlab-org/gitlab/-/issues/391671 Changelog: changed --- ...foreign_key_validation_for_ci_job_artifacts.rb | 15 +++++++++++++++ db/schema_migrations/20230216054348 | 1 + 2 files changed, 16 insertions(+) create mode 100644 db/post_migrate/20230216054348_prepare_async_foreign_key_validation_for_ci_job_artifacts.rb create mode 100644 db/schema_migrations/20230216054348 diff --git a/db/post_migrate/20230216054348_prepare_async_foreign_key_validation_for_ci_job_artifacts.rb b/db/post_migrate/20230216054348_prepare_async_foreign_key_validation_for_ci_job_artifacts.rb new file mode 100644 index 00000000000000..e99c62d8ce3890 --- /dev/null +++ b/db/post_migrate/20230216054348_prepare_async_foreign_key_validation_for_ci_job_artifacts.rb @@ -0,0 +1,15 @@ +# frozen_string_literal: true + +class PrepareAsyncForeignKeyValidationForCiJobArtifacts < Gitlab::Database::Migration[2.1] + TABLE_NAME = :ci_job_artifacts + COLUMN_NAMES = [:partition_id, :build_id] + FOREIGN_KEY_NAME = :fk_rails_c5137cb2c1_p + + def up + prepare_async_foreign_key_validation(TABLE_NAME, COLUMN_NAMES, name: FOREIGN_KEY_NAME) + end + + def down + unprepare_async_foreign_key_validation(TABLE_NAME, COLUMN_NAMES, name: FOREIGN_KEY_NAME) + end +end diff --git a/db/schema_migrations/20230216054348 b/db/schema_migrations/20230216054348 new file mode 100644 index 00000000000000..c878ce97f9e1d1 --- /dev/null +++ b/db/schema_migrations/20230216054348 @@ -0,0 +1 @@ +d86d07d1a1f02b72cfa45ebe83088366d200af00c8ab77f3a287af8476d00f14 \ No newline at end of file -- GitLab From 0335de041e50c07fda89ed94c2a4dae4bb3fb5d3 Mon Sep 17 00:00:00 2001 From: Max Orefice Date: Thu, 16 Feb 2023 14:55:32 +0000 Subject: [PATCH 2/2] Apply code review feedback --- ...prepare_async_foreign_key_validation_for_ci_job_artifacts.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db/post_migrate/20230216054348_prepare_async_foreign_key_validation_for_ci_job_artifacts.rb b/db/post_migrate/20230216054348_prepare_async_foreign_key_validation_for_ci_job_artifacts.rb index e99c62d8ce3890..6d545361e1086c 100644 --- a/db/post_migrate/20230216054348_prepare_async_foreign_key_validation_for_ci_job_artifacts.rb +++ b/db/post_migrate/20230216054348_prepare_async_foreign_key_validation_for_ci_job_artifacts.rb @@ -2,7 +2,7 @@ class PrepareAsyncForeignKeyValidationForCiJobArtifacts < Gitlab::Database::Migration[2.1] TABLE_NAME = :ci_job_artifacts - COLUMN_NAMES = [:partition_id, :build_id] + COLUMN_NAMES = [:partition_id, :job_id] FOREIGN_KEY_NAME = :fk_rails_c5137cb2c1_p def up -- GitLab