db/post_migrate/20231130142218_async_create_supporting_index_for_finding_id_backfill.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

# frozen_string_literal: true

class AsyncCreateSupportingIndexForFindingIdBackfill < Gitlab::Database::Migration[2.2]
  milestone '16.7'

  INDEX_NAME = "tmp_index_vulnerabilities_on_id_finding_id_empty"

  # TODO: Index to be created synchronously in https://gitlab.com/gitlab-org/gitlab/-/issues/433253
  def up
    prepare_async_index(
      :vulnerabilities,
      :id,
      where: "finding_id IS NULL",
      name: INDEX_NAME
    )
  end

  def down
    unprepare_async_index(
      :vulnerabilities,
      :id,
      name: INDEX_NAME
    )
  end
end