Sha256: 91aac92302d73cd5caf5169834fc58547c8a1ced82e755f6fd7e4d9d88f76a86

Contents?: true

Size: 550 Bytes

Versions: 113

Compression:

Stored size: 550 Bytes

Contents

class MakeExistingCreditCardsDefault < ActiveRecord::Migration[4.2]
  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

113 entries across 113 versions & 1 rubygems

Version Path
spree_core-4.0.9 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.1.15 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.2.7 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.2.6 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.2.5 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.1.14 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.0.8 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.2.4 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-3.7.14.1 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.2.3.1 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.1.13.1 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.0.7.1 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.2.3 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.2.2 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.2.1 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.0.7 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-3.7.14 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.2.0 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.2.0.rc5 db/migrate/20140805171219_make_existing_credit_cards_default.rb
spree_core-4.2.0.rc4 db/migrate/20140805171219_make_existing_credit_cards_default.rb