debian-mirror-gitlab/db/post_migrate/20221110152133_delete_orphans_approval_rules.rb
2023-03-04 22:38:38 +05:30

37 lines
1,018 B
Ruby

# frozen_string_literal: true
class DeleteOrphansApprovalRules < Gitlab::Database::Migration[2.0]
restrict_gitlab_migration gitlab_schema: :gitlab_main
BATCH_SIZE = 1000
SUB_BATCH_SIZE = 500
MERGE_REQUEST_MIGRATION = 'DeleteOrphansApprovalMergeRequestRules'
PROJECT_MIGRATION = 'DeleteOrphansApprovalProjectRules'
INTERVAL = 2.minutes
def up
queue_batched_background_migration(
PROJECT_MIGRATION,
:approval_project_rules,
:id,
job_interval: INTERVAL,
batch_size: BATCH_SIZE,
sub_batch_size: SUB_BATCH_SIZE
)
queue_batched_background_migration(
MERGE_REQUEST_MIGRATION,
:approval_merge_request_rules,
:id,
job_interval: INTERVAL,
batch_size: BATCH_SIZE,
sub_batch_size: SUB_BATCH_SIZE
)
end
def down
delete_batched_background_migration(PROJECT_MIGRATION, :approval_project_rules, :id, [])
delete_batched_background_migration(MERGE_REQUEST_MIGRATION, :approval_merge_request_rules, :id, [])
end
end