diff --git a/db/docs/batched_background_migrations/backfill_scan_result_policies_namespace_id.yml b/db/docs/batched_background_migrations/backfill_scan_result_policies_namespace_id.yml index c86ac244ae976766231a9ddfa75c5279ed5b1165..3e9f35cc2a510bf0d482bd6a349afd9a0c385519 100644 --- a/db/docs/batched_background_migrations/backfill_scan_result_policies_namespace_id.yml +++ b/db/docs/batched_background_migrations/backfill_scan_result_policies_namespace_id.yml @@ -5,4 +5,4 @@ feature_category: security_policy_management introduced_by_url: https://gitlab.com/gitlab-org/gitlab/-/merge_requests/183125 milestone: '17.10' queued_migration_version: 20250301125858 -finalized_by: # version of the migration that finalized this BBM +finalized_by: '20250710232543' diff --git a/db/post_migrate/20250710232543_finalize_hk_backfill_scan_result_policies_namespace_id.rb b/db/post_migrate/20250710232543_finalize_hk_backfill_scan_result_policies_namespace_id.rb new file mode 100644 index 0000000000000000000000000000000000000000..46689cdc73ad3dd4918b597702677548b35ed46c --- /dev/null +++ b/db/post_migrate/20250710232543_finalize_hk_backfill_scan_result_policies_namespace_id.rb @@ -0,0 +1,22 @@ +# frozen_string_literal: true + +class FinalizeHkBackfillScanResultPoliciesNamespaceId < Gitlab::Database::Migration[2.3] + milestone '18.2' + + disable_ddl_transaction! + + restrict_gitlab_migration gitlab_schema: :gitlab_main_cell + + def up + ensure_batched_background_migration_is_finished( + job_class_name: 'BackfillScanResultPoliciesNamespaceId', + table_name: :scan_result_policies, + column_name: :id, + job_arguments: [:namespace_id, :security_orchestration_policy_configurations, :namespace_id, + :security_orchestration_policy_configuration_id], + finalize: true + ) + end + + def down; end +end diff --git a/db/schema_migrations/20250710232543 b/db/schema_migrations/20250710232543 new file mode 100644 index 0000000000000000000000000000000000000000..8748af2939ee98b9209293d9d369f3b8b3012f2c --- /dev/null +++ b/db/schema_migrations/20250710232543 @@ -0,0 +1 @@ +14644e4b7507cd10b7930b73b70d6d78468fcf99abe61d6289a38f64e4eef11a \ No newline at end of file