Denormalise a status via Rails migration

01_denormalize_project_status.rb

class DenormalizeProjectStatus < ActiveRecord::Migration

  def up
    add_column :projects, :status, :string, limit: 32
    execute %q(UPDATE projects p SET status = (SELECT name FROM statuses s WHERE s.id = p.status_id))
    change_column :projects, :status, :string, null: false, limit: 32
    remove_column :projects, :status_id
  end

end