db/migrate/20200304160801_delete_template_services_duplicated_by_type.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 DeleteTemplateServicesDuplicatedByType < ActiveRecord::Migration[6.0]
  DOWNTIME = false

  def up
    # Delete service templates with duplicated types. Keep the service
    # template with the lowest `id` because that is the service template used:
    # https://gitlab.com/gitlab-org/gitlab/-/blob/v12.8.1-ee/app/controllers/admin/services_controller.rb#L37
    execute <<~SQL
      DELETE
      FROM services
      WHERE TEMPLATE = TRUE
        AND id NOT IN
          (SELECT MIN(id)
           FROM services
           WHERE TEMPLATE = TRUE
           GROUP BY TYPE);
    SQL
  end

  def down
    # This migration cannot be reversed.
  end
end