Sha256: ac8d40d0c56f504b71b4d425dee9ea625a6fc335fe7ce2fa4ef0dcee44370250

Contents?: true

Size: 1.44 KB

Versions: 19

Compression:

Stored size: 1.44 KB

Contents

namespace :sqlserver do
  task :setup do
    require 'bundler'
    Bundler.require(:default, :sqlserver)
  end

  task :create_database => :setup do
    spec = CompositePrimaryKeys::ConnectionSpec['sqlserver']
    database = spec.delete('database')
    ActiveRecord::Base.clear_all_connections!

    ActiveRecord::Base.establish_connection(spec)
    ActiveRecord::Base.connection.execute("CREATE DATABASE [#{database}]")
    ActiveRecord::Base.clear_all_connections!
  end

  task :build_database => :create_database do
    spec = CompositePrimaryKeys::ConnectionSpec['sqlserver']
    ActiveRecord::Base.establish_connection(spec)

    schema = File.join(PROJECT_ROOT, 'test', 'fixtures', 'db_definitions', 'sqlserver.sql')
    sql = File.read(schema)
    ActiveRecord::Base.connection.execute(sql)
    ActiveRecord::Base.clear_all_connections!
  end

  desc 'Drop the SQL Server test database'
  task :drop_database => :setup do
    spec = CompositePrimaryKeys::ConnectionSpec['sqlserver']
    ActiveRecord::Base.clear_all_connections!
    ActiveRecord::Base.establish_connection(spec)
    database = spec.delete('database')
    ActiveRecord::Base.connection.execute(<<-SQL)
      USE master;
      ALTER DATABASE [#{database}] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
      DROP DATABASE [#{database}];
    SQL
    ActiveRecord::Base.clear_all_connections!
  end

  desc 'Rebuild the SQL Server test database'
  task :rebuild_database => [:drop_database, :build_database]
end

Version data entries

19 entries across 19 versions & 1 rubygems

Version Path
composite_primary_keys-14.0.10 tasks/databases/sqlserver.rake
composite_primary_keys-13.0.9 tasks/databases/sqlserver.rake
composite_primary_keys-14.0.9 tasks/databases/sqlserver.rake
composite_primary_keys-14.0.8 tasks/databases/sqlserver.rake
composite_primary_keys-13.0.8 tasks/databases/sqlserver.rake
composite_primary_keys-14.0.7 tasks/databases/sqlserver.rake
composite_primary_keys-14.0.6 tasks/databases/sqlserver.rake
composite_primary_keys-13.0.7 tasks/databases/sqlserver.rake
composite_primary_keys-13.0.6 tasks/databases/sqlserver.rake
composite_primary_keys-14.0.5 tasks/databases/sqlserver.rake
composite_primary_keys-13.0.5 tasks/databases/sqlserver.rake
composite_primary_keys-13.0.4 tasks/databases/sqlserver.rake
composite_primary_keys-14.0.4 tasks/databases/sqlserver.rake
composite_primary_keys-14.0.3 tasks/databases/sqlserver.rake
composite_primary_keys-13.0.3 tasks/databases/sqlserver.rake
composite_primary_keys-14.0.2 tasks/databases/sqlserver.rake
composite_primary_keys-13.0.2 tasks/databases/sqlserver.rake
composite_primary_keys-14.0.1 tasks/databases/sqlserver.rake
composite_primary_keys-11.0.0.rc2 tasks/databases/sqlserver.rake