Contents

# This migration comes from spree_auth (originally 20111206075712)
class MigrateTokenizedPermissions < ActiveRecord::Migration
  def concat(str1, str2)
    dbtype = Rails.configuration.database_configuration[Rails.env]['adapter'].to_sym

    case dbtype
    when :mysql, :mysql2
      "CONCAT(#{str1}, #{str2})"
    when :sqlserver
      "(#{str1} + #{str2})"
    else
      "(#{str1} || #{str2})"
    end
  end

  def up
    execute "UPDATE spree_tokenized_permissions SET permissable_type = #{concat("'Spree::'", "permissable_type")}" +
            " WHERE permissable_type NOT LIKE 'Spree::%' AND permissable_type IS NOT NULL"
  end

  def down
    execute "UPDATE spree_tokenized_permissions SET permissable_type = REPLACE(permissable_type, 'Spree::', '')" + 
            " WHERE permissable_type LIKE 'Spree::%'"
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
datashift_spree-0.3.0	spec/sandbox/db/migrate/20121023154464_migrate_tokenized_permissions.spree_auth.rb
datashift_spree-0.2.1	spec/sandbox/db/migrate/20121015151257_migrate_tokenized_permissions.spree_auth.rb
datashift_spree-0.2.0	spec/sandbox/db/migrate/20120925192825_migrate_tokenized_permissions.spree_auth.rb
datashift_spree-0.1.0	spec/sandbox/db/migrate/20120918081556_migrate_tokenized_permissions.spree_auth.rb