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

  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