Contents

class ConvertSalePromotions < ActiveRecord::Migration
  def up
    sale_promotions.update_all(apply_automatically: true)
  end

  def down
    # intentionally left blank
  end

  private

  def sale_promotions
    promo_table = Spree::Promotion.arel_table
    code_table  = Spree::PromotionCode.arel_table

    promotion_code_join = promo_table.join(code_table, Arel::Nodes::OuterJoin).on(
      promo_table[:id].eq(code_table[:promotion_id])
    ).join_sources

    Spree::Promotion.includes(:promotion_rules).
      joins(promotion_code_join).
      where(
        code_table[:value].eq(nil).and(
          promo_table[:path].eq(nil)
        )
      ).distinct
  end
end

Version data entries

24 entries across 24 versions & 1 rubygems

Version	Path
solidus_core-1.4.2	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.3.2	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.2.3	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.1.4	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.4.1	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.4.0	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.4.0.rc1	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.4.0.beta1	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.3.1	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.3.0	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.3.0.rc2	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.3.0.rc1	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.3.0.beta1	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.2.2	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.2.1	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.1.3	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.2.0	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.2.0.rc2	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.1.2	db/migrate/20151021163309_convert_sale_promotions.rb
solidus_core-1.2.0.rc1	db/migrate/20151021163309_convert_sale_promotions.rb