summaryrefslogtreecommitdiff
path: root/db/migrate/20210708011425_rename_ci_builds_metadata_foreign_key.rb
blob: 70141f4844ee4aed8f50910a2b8ec769abd67cf6 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
# frozen_string_literal: true

class RenameCiBuildsMetadataForeignKey < Gitlab::Database::Migration[1.0]
  disable_ddl_transaction!

  TABLE_NAME = 'ci_builds_metadata'
  OLD_PREFIX = 'fk_rails_'

  def up
    with_lock_retries(raise_on_exhaustion: true) do
      rename_constraint(
        TABLE_NAME,
        concurrent_foreign_key_name(TABLE_NAME, :build_id, prefix: 'fk_rails_'),
        concurrent_foreign_key_name(TABLE_NAME, :build_id)
      )
    end
  end

  def down
    with_lock_retries(raise_on_exhaustion: true) do
      rename_constraint(
        TABLE_NAME,
        concurrent_foreign_key_name(TABLE_NAME, :build_id),
        concurrent_foreign_key_name(TABLE_NAME, :build_id, prefix: 'fk_rails_')
      )
    end
  end
end