db/post_migrate/20170306170512_migrate_legacy_manual_actions.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

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

  DOWNTIME = false

  def up
    disable_statement_timeout

    execute <<-EOS
      UPDATE ci_builds SET status = 'manual', allow_failure = true
        WHERE ci_builds.when = 'manual' AND ci_builds.status = 'skipped';
    EOS
  end

  def down
    disable_statement_timeout

    execute <<-EOS
      UPDATE ci_builds SET status = 'skipped', allow_failure = false
        WHERE ci_builds.when = 'manual' AND ci_builds.status = 'manual';
    EOS
  end
end