Contents

class MoveOrderTokenFromTokenizedPermission < ActiveRecord::Migration
  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

11 entries across 11 versions & 1 rubygems

Version	Path
solidus_core-1.4.2	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
solidus_core-1.3.2	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
solidus_core-1.4.1	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
solidus_core-1.4.0	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
solidus_core-1.4.0.rc1	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
solidus_core-1.4.0.beta1	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
solidus_core-1.3.1	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
solidus_core-1.3.0	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
solidus_core-1.3.0.rc2	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
solidus_core-1.3.0.rc1	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
solidus_core-1.3.0.beta1	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb