summaryrefslogtreecommitdiff
path: root/db/migrate/20130218141327_convert_closed_to_state_in_merge_request.rb
blob: 307fc6a023d4395222de7b11978d8d3313b9eada (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
# rubocop:disable all
class ConvertClosedToStateInMergeRequest < ActiveRecord::Migration
  include Gitlab::Database::MigrationHelpers

  def up
    execute "UPDATE #{table_name} SET state = 'merged' WHERE closed = #{true_value} AND merged = #{true_value}"
    execute "UPDATE #{table_name} SET state = 'closed' WHERE closed = #{true_value} AND merged = #{false_value}"
    execute "UPDATE #{table_name} SET state = 'opened' WHERE closed = #{false_value}"
  end

  def down
    execute "UPDATE #{table_name} SET closed = #{true_value} WHERE state = 'closed'"
    execute "UPDATE #{table_name} SET closed = #{true_value}, merged = #{true_value} WHERE state = 'merged'"
  end

  private

  def table_name
    MergeRequest.table_name
  end
end