Contents

class CreditcardLastFourDigits < ActiveRecord::Migration
  def up
    rename_column :creditcards, :display_number, :last_digits

    creditcards = select_all "SELECT * FROM creditcards"
    creditcards.each do |card|
      execute "UPDATE creditcards SET last_digits = '#{card['last_digits'].gsub('XXXX-XXXX-XXXX-', '')}' WHERE id = #{card['id']}" if card['last_digits'].present?
    end
  end

  def down
    rename_column :creditcards, :last_digits, :display_number
  end
end

Version data entries

35 entries across 35 versions & 3 rubygems

Version	Path
spree_core-1.2.5	db/migrate/20091213222815_creditcard_last_four_digits.rb
spree_core-1.1.6	db/migrate/20091213222815_creditcard_last_four_digits.rb
spree_core-1.1.5	db/migrate/20091213222815_creditcard_last_four_digits.rb
spree_core-1.2.4	db/migrate/20091213222815_creditcard_last_four_digits.rb
spree_core-1.0.7	db/migrate/20091213222815_creditcard_last_four_digits.rb
spree_core-1.2.3	db/migrate/20091213222815_creditcard_last_four_digits.rb
spree_core-1.2.2	db/migrate/20091213222815_creditcard_last_four_digits.rb
spree_core-1.1.4	db/migrate/20091213222815_creditcard_last_four_digits.rb
spree_core-1.2.0	db/migrate/20091213222815_creditcard_last_four_digits.rb
spree_core-1.2.0.rc2	db/migrate/20091213222815_creditcard_last_four_digits.rb
spree_core-1.2.0.rc1	db/migrate/20091213222815_creditcard_last_four_digits.rb
spree_core-1.1.3	db/migrate/20091213222815_creditcard_last_four_digits.rb
spree_core-1.0.6	db/migrate/20091213222815_creditcard_last_four_digits.rb
spree_pag_seguro-1.0.7	spec/dummy/db/migrate/20120301154067_creditcard_last_four_digits.rb
spree_core-1.1.2	db/migrate/20091213222815_creditcard_last_four_digits.rb
spree_core-1.1.2.rc1	db/migrate/20091213222815_creditcard_last_four_digits.rb
spree_pag_seguro-1.0.6	spec/dummy/db/migrate/20120301154067_creditcard_last_four_digits.rb
spree_pag_seguro-1.0.5	spec/dummy/db/migrate/20120301154067_creditcard_last_four_digits.rb
spree_pag_seguro-1.0.4	spec/dummy/db/migrate/20120301154067_creditcard_last_four_digits.rb
spree_core-1.1.1	db/migrate/20091213222815_creditcard_last_four_digits.rb