Contents

class ChangeTxnTypeToInt < ActiveRecord::Migration
  def self.up
    if (ActiveRecord::Migration.connection.adapter_name == "PostgreSQL") && (postgresql_version > 80000)
      
      execute('
        ALTER TABLE "creditcard_txns" 
          ALTER COLUMN "txn_type" 
          TYPE integer 
          USING to_number(creditcard_txns.txn_type,\'S9999999\')
      ')
    else
      change_column :creditcard_txns, :txn_type, :integer
    end
  end

  def self.down
  end
end

Version data entries

6 entries across 6 versions & 2 rubygems

Version	Path
spree-enriquez-0.9.4	db/migrate/20090617181106_change_txn_type_to_int.rb
spree-0.9.4	db/migrate/20090617181106_change_txn_type_to_int.rb
spree-0.9.3	db/migrate/20090617181106_change_txn_type_to_int.rb
spree-0.9.2	db/migrate/20090617181106_change_txn_type_to_int.rb
spree-0.9.1	db/migrate/20090617181106_change_txn_type_to_int.rb
spree-0.9.0	db/migrate/20090617181106_change_txn_type_to_int.rb