summaryrefslogtreecommitdiff
path: root/db/post_migrate/20170526185921_migrate_build_stage_reference.rb
blob: 3c30dfd6ddeb1857cae80f11f8051e84d0a9b833 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
class MigrateBuildStageReference < ActiveRecord::Migration
  include Gitlab::Database::MigrationHelpers

  DOWNTIME = false

  def up
    disable_statement_timeout

    stage_id = Arel.sql('(SELECT id FROM ci_stages ' \
                         'WHERE ci_stages.pipeline_id = ci_builds.commit_id ' \
                         'AND ci_stages.name = ci_builds.stage)')

    update_column_in_batches(:ci_builds, :stage_id, stage_id) do |table, query|
      query.where(table[:stage_id].eq(nil))
    end
  end

  def down
    disable_statement_timeout

    update_column_in_batches(:ci_builds, :stage_id, nil)
  end
end