Sha256: 0c8a02ce512257701edac8befa852c6b38c48dbb61f4e97d1b03b1d7423be3db

Contents?: true

Size: 1.13 KB

Versions: 141

Compression:

Stored size: 1.13 KB

Contents

class MoveOrderTokenFromTokenizedPermission < ActiveRecord::Migration[4.2]
  class Spree::TokenizedPermission < Spree::Base
    belongs_to :permissable, polymorphic: true
  end

  def up
    case Spree::Order.connection.adapter_name
    when 'SQLite'
      Spree::Order.has_one :tokenized_permission, as: :permissable
      Spree::Order.includes(:tokenized_permission).each do |o|
        o.update_column :guest_token, o.tokenized_permission.token
      end
    when 'Mysql2', 'MySQL'
      execute "UPDATE spree_orders, spree_tokenized_permissions
               SET spree_orders.guest_token = spree_tokenized_permissions.token
               WHERE spree_tokenized_permissions.permissable_id = spree_orders.id
                  AND spree_tokenized_permissions.permissable_type = 'Spree::Order'"
    else
      execute "UPDATE spree_orders
               SET guest_token = spree_tokenized_permissions.token
               FROM spree_tokenized_permissions
               WHERE spree_tokenized_permissions.permissable_id = spree_orders.id
                  AND spree_tokenized_permissions.permissable_type = 'Spree::Order'"
    end
  end

  def down
  end
end

Version data entries

141 entries across 141 versions & 2 rubygems

Version Path
spree_core-4.0.9 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.1.15 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.2.7 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.3.3 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.2.6 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.3.2 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.3.1 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.3.0 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.3.0.rc3 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.3.0.rc2 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.3.0.rc1 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.2.5 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.1.14 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.0.8 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.2.4 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-3.7.14.1 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.2.3.1 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.1.13.1 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.0.7.1 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-4.2.3 db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb