summaryrefslogtreecommitdiff
path: root/db/migrate/20170809134534_add_broadcast_message_not_null_constraints.rb
blob: fd8cdbb95aa2ebdd706c764aa26089beead5ed07 (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
# See http://doc.gitlab.com/ce/development/migration_style_guide.html
# for more information on how to write migrations for GitLab.

class AddBroadcastMessageNotNullConstraints < ActiveRecord::Migration[4.2]
  include Gitlab::Database::MigrationHelpers

  # Set this constant to true if this migration requires downtime.
  DOWNTIME = false

  COLUMNS = %i[starts_at ends_at created_at updated_at message_html]

  class BroadcastMessage < ActiveRecord::Base
    self.table_name = 'broadcast_messages'
  end

  def up
    COLUMNS.each do |column|
      BroadcastMessage.where(column => nil).delete_all

      change_column_null :broadcast_messages, column, false
    end
  end

  def down
    COLUMNS.each do |column|
      change_column_null :broadcast_messages, column, true
    end
  end
end