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'
      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

8 entries across 8 versions & 1 rubygems

Version	Path
spree_core-2.4.0.rc3	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-2.4.0.rc2	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-2.4.0.rc1	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-2.3.4	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-2.3.3	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-2.3.2	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-2.3.1	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb
spree_core-2.3.0	db/migrate/20140530024945_move_order_token_from_tokenized_permission.rb