Sha256: 3752eb95285f83255f31c6537e941fb70bb3175b41a31190b55394a0e257cd24

Contents?: true

Size: 607 Bytes

Versions: 6

Compression:

Stored size: 607 Bytes

Contents

# This migration comes from spree (originally 20140805171219)
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

6 entries across 6 versions & 3 rubygems

Version Path
spree_weight_calculator-0.1.0 test/dummy/db/migrate/20160723192607_make_existing_credit_cards_default.spree.rb
spree_order_reporting-0.0.3 spec/dummy/db/migrate/20160708163204_make_existing_credit_cards_default.spree.rb
spree_order_reporting-0.0.2 spec/dummy/db/migrate/20160707103529_make_existing_credit_cards_default.spree.rb
spree_order_reporting-0.0.1 spec/dummy/db/migrate/20160706112481_make_existing_credit_cards_default.spree.rb
sprangular-0.1.0 spec/dummy/db/migrate/20141203183786_make_existing_credit_cards_default.spree.rb
sprangular-0.0.1 spec/dummy/db/migrate/20141203183786_make_existing_credit_cards_default.spree.rb