db/post_migrate/20170206040400_remove_inactive_default_email_services.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

class RemoveInactiveDefaultEmailServices < ActiveRecord::Migration
  include Gitlab::Database::MigrationHelpers

  DOWNTIME = false

  disable_ddl_transaction!

  def up
    Gitlab::Database::ThreadedConnectionPool.with_pool(2) do |pool|
      pool.execute_async <<-SQL.strip_heredoc
        DELETE FROM services
          WHERE type = 'BuildsEmailService'
            AND active IS FALSE
            AND properties = '{"notify_only_broken_builds":true}';
      SQL

      pool.execute_async <<-SQL.strip_heredoc
        DELETE FROM services
          WHERE type = 'PipelinesEmailService'
            AND active IS FALSE
            AND properties = '{"notify_only_broken_pipelines":true}';
      SQL
    end
  end

  def down
    # Nothing can be done to restore the records
  end
end