summaryrefslogtreecommitdiff
path: root/db/migrate/20200123091422_remove_analytics_repository_files_fk_on_other_analytics_tables.rb
blob: e3e415dd0ad2a99b8babe27e5e7f7e19d1b931ef (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
# frozen_string_literal: true

class RemoveAnalyticsRepositoryFilesFkOnOtherAnalyticsTables < ActiveRecord::Migration[5.2]
  include Gitlab::Database::MigrationHelpers

  DOWNTIME = false

  def up
    with_lock_retries do
      # Requires ExclusiveLock on all tables. analytics_* tables are empty
      remove_foreign_key :analytics_repository_file_edits, :analytics_repository_files if table_exists?(:analytics_repository_file_edits) # this table might be already dropped on development environment
      remove_foreign_key :analytics_repository_file_commits, :analytics_repository_files
    end
  end

  def down
    with_lock_retries do
      # rubocop:disable Migration/AddConcurrentForeignKey
      add_foreign_key :analytics_repository_file_edits, :analytics_repository_files, on_delete: :cascade
      add_foreign_key :analytics_repository_file_commits, :analytics_repository_files, on_delete: :cascade
      # rubocop:enable Migration/AddConcurrentForeignKey
    end
  end
end