Contents

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

21 entries across 21 versions & 1 rubygems

Version	Path
spree_auth-1.1.5	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.0.7	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.1.4	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.1.3	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.0.6	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.0.5	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.1.2	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.1.2.rc1	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.1.1	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.1.0	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.0.4	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.1.0.rc2	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.1.0.rc1	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.0.3	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.0.2	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.0.1	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.0.0	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.0.0.rc4	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.0.0.rc3	db/migrate/20111206075712_migrate_tokenized_permissions.rb
spree_auth-1.0.0.rc2	db/migrate/20111206075712_migrate_tokenized_permissions.rb