BigW Consortium Gitlab

20160412173417_update_ci_commit.rb 1.52 KB
Newer Older
1
class UpdateCiCommit < ActiveRecord::Migration
2 3
  # This migration can be run online, but needs to be executed for the second time after restarting Unicorn workers
  # Otherwise Offline migration should be used.
4 5 6 7
  def change
    execute("UPDATE ci_commits SET status=#{status}, ref=#{ref}, tag=#{tag} WHERE status IS NULL")
  end

8 9
  private

10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
  def status
    builds = '(SELECT COUNT(*) FROM ci_builds WHERE ci_builds.commit_id=ci_commits.id)'
    success = "(SELECT COUNT(*) FROM ci_builds WHERE ci_builds.commit_id=ci_commits.id AND status='success')"
    ignored = "(SELECT COUNT(*) FROM ci_builds WHERE ci_builds.commit_id=ci_commits.id AND (status='failed' OR status='canceled') AND allow_failure)"
    pending = "(SELECT COUNT(*) FROM ci_builds WHERE ci_builds.commit_id=ci_commits.id AND status='pending')"
    running = "(SELECT COUNT(*) FROM ci_builds WHERE ci_builds.commit_id=ci_commits.id AND status='running')"
    canceled = "(SELECT COUNT(*) FROM ci_builds WHERE ci_builds.commit_id=ci_commits.id AND status='canceled')"

    "(CASE
      WHEN #{builds}=0 THEN 'skipped'
      WHEN #{builds}=#{success}+#{ignored} THEN 'success'
      WHEN #{builds}=#{pending} THEN 'pending'
      WHEN #{builds}=#{canceled} THEN 'canceled'
      WHEN #{running}+#{pending}>0 THEN 'running'
      ELSE 'failed'
    END)"
  end

  def ref
    '(SELECT ref FROM ci_builds WHERE ci_builds.commit_id=ci_commits.id ORDER BY id DESC LIMIT 1)'
  end

  def tag
    '(SELECT tag FROM ci_builds WHERE ci_builds.commit_id=ci_commits.id ORDER BY id DESC LIMIT 1)'
  end
end