Contents

class ReplaceEnvironmentIdWithEnvironmentName < ActiveRecord::Migration
  RENAMES = {"dev" => "Staging", "master" => "Production"}
  
  class Environment < ActiveRecord::Base; end
  
  def up
    add_column :deploys, :environment_name, :string, null: false, default: "Production"
    add_index :deploys, :environment_name
    add_index :deploys, [:project_id, :environment_name]
    
    Deploy.tap(&:reset_column_information).reorder(nil).each do |deploy|
      if deploy.respond_to?(:environment_id) && (environment = Environment.find_by_id(deploy.environment_id))
        deploy.update_column(:environment_name, environment.name)
      end
    end
    
    add_column :releases, :project_id, :integer, null: false, default: -1
    add_column :releases, :environment_name, :string, null: false, default: "Production"
    add_index :releases, :project_id
    add_index :releases, [:project_id, :environment_name]
    
    Release.tap(&:reset_column_information).all.each do |release|
      if release.respond_to?(:environment_id) && (environment = Environment.find_by_id(release.environment_id))
        release.update_column(:project_id, environment.project_id)
        release.update_column(:environment_name, environment.name)
      end
    end
    
    rename_column :user_notifications, :environment, :environment_name
  end
  
  def down
    remove_column :deploys, :environment_name
    remove_column :releases, :project_id
    remove_column :releases, :environment_name
    
    rename_column :user_notifications, :environment_name, :environment
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
houston-core-0.5.0.beta1	db/migrate/20121225175106_replace_environment_id_with_environment_name.rb