summaryrefslogtreecommitdiff
path: root/db/migrate/20220321234317_remove_all_issuable_escalation_statuses.rb
blob: a6ea182016076ff09eb4f88c54b31de8e547c6ab (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
29
30
# frozen_string_literal: true

class RemoveAllIssuableEscalationStatuses < Gitlab::Database::Migration[1.0]
  BATCH_SIZE = 5_000

  disable_ddl_transaction!

  # Removes records from previous backfill. Records for
  # existing incidents will be created entirely as-needed.
  #
  # See db/post_migrate/20211214012507_backfill_incident_issue_escalation_statuses.rb,
  # & IncidentManagement::IssuableEscalationStatuses::[BuildService,PrepareUpdateService]
  def up
    each_batch_range('incident_management_issuable_escalation_statuses', of: BATCH_SIZE) do |min, max|
      execute <<~SQL
        DELETE FROM incident_management_issuable_escalation_statuses
        WHERE id BETWEEN #{min} AND #{max}
      SQL
    end
  end

  def down
    # no-op
    #
    # Potential rollback/re-run should not have impact, as these
    # records are not required to be present in the application.
    # The corresponding feature flag is also disabled,
    # preventing any user-facing access to the records.
  end
end