Contents

require File.join(PROJECT_ROOT, 'lib', 'composite_primary_keys')
require File.join(PROJECT_ROOT, 'test', 'connections', 'connection_spec')

namespace :postgresql do
  desc 'Create the PostgreSQL test databases'
  task :create_database do
    ActiveRecord::Base.clear_all_connections!
    spec = CompositePrimaryKeys::ConnectionSpec['postgresql'].dup
    database_name = spec.delete('database')
    spec['database'] = 'postgres'
    connection = ActiveRecord::Base.establish_connection(spec)
    ActiveRecord::Base.connection.create_database(database_name)
    ActiveRecord::Base.clear_all_connections!
  end

  desc 'Build the PostgreSQL test databases'
  task :build_databases => [:create_database] do
    path = File.join(PROJECT_ROOT, 'test', 'fixtures', 'db_definitions', 'postgresql.sql')
    sql = File.open(path, 'rb') do |file|
      file.read
    end

    Rake::Task['postgresql:load_connection'].invoke
    ActiveRecord::Base.connection.execute(sql)
  end

  desc 'Drop the PostgreSQL test databases'
  task :drop_databases => :load_connection do
    ActiveRecord::Base.clear_all_connections!
    spec = CompositePrimaryKeys::ConnectionSpec['postgresql'].dup
    database_name = spec.delete('database')
    spec['database'] = 'postgres'
    connection = ActiveRecord::Base.establish_connection(spec)
    ActiveRecord::Base.connection.drop_database(SPEC['database'])
    ActiveRecord::Base.clear_all_connections!
  end

  desc 'Rebuild the PostgreSQL test databases'
  task :rebuild_databases => [:drop_databases, :build_databases]

  task :load_connection do
    require File.join(PROJECT_ROOT, "test", "connections", "native_postgresql", "connection")
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
composite_primary_keys-5.0.5	tasks/databases/postgresql.rake
composite_primary_keys-5.0.4	tasks/databases/postgresql.rake
composite_primary_keys-5.0.2	tasks/databases/postgresql.rake
composite_primary_keys-5.0.1	tasks/databases/postgresql.rake
composite_primary_keys-5.0.0	tasks/databases/postgresql.rake