Contents

class AssignCreditcardTxnsToPayment < ActiveRecord::Migration
  def up
    add_column :creditcard_txns, :payment_id, :integer

    # Temporarily set back to creditcards
    Spree::Creditcard.table_name = 'creditcards'

    ActiveRecord::Base.connection.select_all('SELECT * FROM creditcard_txns').each do |txn_attrs|
      if creditcard = Spree::Creditcard.find_by_id(txn_attrs['creditcard_id']) and creditcard.payments.first
        execute "UPDATE creditcard_txns SET payment_id = #{creditcard.payments.first.id} WHERE id = #{txn_attrs['id']}"
      end
    end

    Spree::Creditcard.table_name = 'spree_creditcards'

    remove_column :creditcard_txns, :creditcard_payment_id
  end

  def down
    remove_column :creditcard_txns, :payment_id
    add_column    :creditcard_txns, :creditcard_payment_id, :integer
  end
end

Version data entries

28 entries across 28 versions & 3 rubygems

Version	Path
spree_core-1.1.6	db/migrate/20100214212536_assign_creditcard_txns_to_payment.rb
spree_core-1.1.5	db/migrate/20100214212536_assign_creditcard_txns_to_payment.rb
spree_core-1.0.7	db/migrate/20100214212536_assign_creditcard_txns_to_payment.rb
spree_core-1.1.4	db/migrate/20100214212536_assign_creditcard_txns_to_payment.rb
spree_core-1.1.3	db/migrate/20100214212536_assign_creditcard_txns_to_payment.rb
spree_core-1.0.6	db/migrate/20100214212536_assign_creditcard_txns_to_payment.rb
spree_pag_seguro-1.0.7	spec/dummy/db/migrate/20120301154082_assign_creditcard_txns_to_payment.rb
spree_core-1.1.2	db/migrate/20100214212536_assign_creditcard_txns_to_payment.rb
spree_core-1.1.2.rc1	db/migrate/20100214212536_assign_creditcard_txns_to_payment.rb
spree_pag_seguro-1.0.6	spec/dummy/db/migrate/20120301154082_assign_creditcard_txns_to_payment.rb
spree_pag_seguro-1.0.5	spec/dummy/db/migrate/20120301154082_assign_creditcard_txns_to_payment.rb
spree_pag_seguro-1.0.4	spec/dummy/db/migrate/20120301154082_assign_creditcard_txns_to_payment.rb
spree_core-1.1.1	db/migrate/20100214212536_assign_creditcard_txns_to_payment.rb
spree_core-1.1.0	db/migrate/20100214212536_assign_creditcard_txns_to_payment.rb
spree_core-1.0.4	db/migrate/20100214212536_assign_creditcard_txns_to_payment.rb
spree_core-1.1.0.rc2	db/migrate/20100214212536_assign_creditcard_txns_to_payment.rb
spree_core-1.1.0.rc1	db/migrate/20100214212536_assign_creditcard_txns_to_payment.rb
spree_pag_seguro-1.0.3	spec/dummy/db/migrate/20120301154082_assign_creditcard_txns_to_payment.rb
spree_pag_seguro-1.0.2	spec/dummy/db/migrate/20120301154082_assign_creditcard_txns_to_payment.rb
spree_core-1.0.3	db/migrate/20100214212536_assign_creditcard_txns_to_payment.rb