class RenameDigestEmailToEmailDigest < ActiveRecord::Migration
  def up
    sql = <<-SQL
      UPDATE #{ActiveRecord::Base.connection.quote_table_name('agents')}
      SET #{ActiveRecord::Base.connection.quote_column_name('type')} = "Agents::EmailDigestAgent"
      WHERE #{ActiveRecord::Base.connection.quote_column_name('type')} = "Agents::DigestEmailAgent"
    SQL

    execute sql
  end

  def down
    sql = <<-SQL
      UPDATE #{ActiveRecord::Base.connection.quote_table_name('agents')}
      SET #{ActiveRecord::Base.connection.quote_column_name('type')} = "Agents::DigestEmailAgent"
      WHERE #{ActiveRecord::Base.connection.quote_column_name('type')} = "Agents::EmailDigestAgent"
    SQL

    execute sql
  end
end