change

in db/migrate/20141031114419_migrate_build_to_commits.rb [1:20]

• 17 lines of code
• 2 McCabe index (conditional complexity)

  def change
    execute <<eos
INSERT INTO commits ( sha, project_id, ref, before_sha, push_data )
SELECT sha, project_id, ref, before_sha, push_data FROM builds
WHERE id IN (SELECT MAX(id) FROM builds GROUP BY sha)
eos


    if ActiveRecord::Base.connection.adapter_name == 'PostgreSQL'
      execute <<eos
UPDATE builds
SET commit_id = commits.id
FROM commits
WHERE commits.sha = builds.sha
eos
    else
      execute "UPDATE builds b, commits c SET b.commit_id = c.id WHERE c.sha = b.sha"
    end
  end