Contents

class MakeExistingCreditCardsDefault < ActiveRecord::Migration
  def up
    # set the newest credit card for every user to be the default; SQL technique from
    # http://stackoverflow.com/questions/121387/fetch-the-row-which-has-the-max-value-for-a-column
    Spree::CreditCard.where.not(user_id: nil).joins("LEFT OUTER JOIN spree_credit_cards cc2 ON cc2.user_id = spree_credit_cards.user_id AND spree_credit_cards.created_at < cc2.created_at").where("cc2.user_id IS NULL").update_all(default: true)
  end

  def down
    # do nothing
  end
end

Version data entries

11 entries across 11 versions & 1 rubygems

Version	Path
solidus_core-1.4.2	db/migrate/20140805171219_make_existing_credit_cards_default.rb
solidus_core-1.3.2	db/migrate/20140805171219_make_existing_credit_cards_default.rb
solidus_core-1.4.1	db/migrate/20140805171219_make_existing_credit_cards_default.rb
solidus_core-1.4.0	db/migrate/20140805171219_make_existing_credit_cards_default.rb
solidus_core-1.4.0.rc1	db/migrate/20140805171219_make_existing_credit_cards_default.rb
solidus_core-1.4.0.beta1	db/migrate/20140805171219_make_existing_credit_cards_default.rb
solidus_core-1.3.1	db/migrate/20140805171219_make_existing_credit_cards_default.rb
solidus_core-1.3.0	db/migrate/20140805171219_make_existing_credit_cards_default.rb
solidus_core-1.3.0.rc2	db/migrate/20140805171219_make_existing_credit_cards_default.rb
solidus_core-1.3.0.rc1	db/migrate/20140805171219_make_existing_credit_cards_default.rb
solidus_core-1.3.0.beta1	db/migrate/20140805171219_make_existing_credit_cards_default.rb