Class: SolidusPromotions::MigrateAdjustments

Inherits:
Object
  • Object
show all
Defined in:
lib/solidus_promotions/migrate_adjustments.rb

Class Method Summary collapse

Class Method Details

.down ⇒ Object 



29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
 
# File 'lib/solidus_promotions/migrate_adjustments.rb', line 29

def down
  sql = if ActiveRecord::Base.connection_db_config.adapter == "mysql2"
    "      UPDATE spree_adjustments\n        INNER JOIN solidus_promotions_benefits\n        INNER JOIN spree_promotion_actions ON spree_adjustments.source_id = solidus_promotions_benefits.id and spree_adjustments.source_type = 'SolidusPromotions::Benefit'\n      SET source_id = spree_promotion_actions.id,\n        source_type = 'Spree::PromotionAction'\n      WHERE solidus_promotions_benefits.original_promotion_action_id = spree_promotion_actions.id\n    SQL\n  else\n    <<~SQL\n      UPDATE spree_adjustments\n      SET source_id = spree_promotion_actions.id,\n          source_type = 'Spree::PromotionAction'\n      FROM spree_promotion_actions\n        INNER JOIN solidus_promotions_benefits ON solidus_promotions_benefits.original_promotion_action_id = spree_promotion_actions.id\n      WHERE spree_adjustments.source_id = solidus_promotions_benefits.id and spree_adjustments.source_type = 'SolidusPromotions::Benefit'\n    SQL\n  end\n\n  execute(sql)\nend\n"

.up ⇒ Object 



6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
 
# File 'lib/solidus_promotions/migrate_adjustments.rb', line 6

def up
  sql = if ActiveRecord::Base.connection_db_config.adapter == "mysql2"
    "      UPDATE spree_adjustments\n        INNER JOIN spree_promotion_actions ON spree_adjustments.source_id = spree_promotion_actions.id and spree_adjustments.source_type = 'Spree::PromotionAction'\n        INNER JOIN solidus_promotions_benefits ON solidus_promotions_benefits.original_promotion_action_id = spree_promotion_actions.id\n      SET source_id = solidus_promotions_benefits.id,\n        source_type = 'SolidusPromotions::Benefit'\n    SQL\n  else\n    <<~SQL\n      UPDATE spree_adjustments\n      SET source_id = solidus_promotions_benefits.id,\n        source_type = 'SolidusPromotions::Benefit'\n      FROM spree_promotion_actions\n        INNER JOIN solidus_promotions_benefits ON solidus_promotions_benefits.original_promotion_action_id = spree_promotion_actions.id\n      WHERE spree_adjustments.source_id = spree_promotion_actions.id and spree_adjustments.source_type = 'Spree::PromotionAction'\n    SQL\n  end\n\n  execute(sql)\nend\n"