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