db/post_migrate/20231105165706_drop_repositories_columns_from_geo_node_status_table.rb


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
29
30
31
32
33
34

# frozen_string_literal: true

class DropRepositoriesColumnsFromGeoNodeStatusTable < Gitlab::Database::Migration[2.2]
  enable_lock_retries!
  milestone '16.6'

  def up
    [
      :repositories_synced_count,
      :repositories_failed_count,
      :repositories_verified_count,
      :repositories_verification_failed_count,
      :repositories_checksummed_count,
      :repositories_checksum_failed_count,
      :repositories_checksum_mismatch_count,
      :repositories_retrying_verification_count
    ].each do |column_name|
      remove_column :geo_node_statuses, column_name, if_exists: true
    end
  end

  def down
    change_table(:geo_node_statuses) do |t|
      t.integer :repositories_synced_count
      t.integer :repositories_failed_count
      t.integer :repositories_verified_count
      t.integer :repositories_verification_failed_count
      t.integer :repositories_checksummed_count
      t.integer :repositories_checksum_failed_count
      t.integer :repositories_checksum_mismatch_count
      t.integer :repositories_retrying_verification_count
    end
  end
end