Contents

namespace :postgresql do
  desc 'Build the PostgreSQL test databases'
  task :build_databases => :load_connection do 
    sh %{ createdb "#{GEM_NAME}_unittest" }
    sh %{ psql "#{GEM_NAME}_unittest" -f #{File.join(SCHEMA_PATH, 'postgresql.sql')} }
  end

  desc 'Drop the PostgreSQL test databases'
  task :drop_databases => :load_connection do 
    sh %{ dropdb "#{GEM_NAME}_unittest" }
  end

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

  task :load_connection do
    require File.join(PROJECT_ROOT, %w[lib adapter_helper postgresql])
    spec = AdapterHelper::Postgresql.load_connection_from_env
    options = {}
    options['u'] = spec[:username]  if spec[:username]
    options['p'] = spec[:password]  if spec[:password]
    options_str = options.map { |key, value| "-#{key}#{value}" }.join(" ")
    ENV['cpk_adapter_options_str'] = options_str
  end
end

Version data entries

29 entries across 29 versions & 4 rubygems

Version	Path
kovyrin-composite_primary_keys-2.3.2	tasks/databases/postgresql.rake
mingusbabcock-composite_primary_keys-2.2.2.1	tasks/databases/postgresql.rake
tyler-composite_primary_keys-1.1.0	tasks/databases/postgresql.rake
tyler-composite_primary_keys-1.1.1	tasks/databases/postgresql.rake
tyler-composite_primary_keys-1.1.2	tasks/databases/postgresql.rake
tyler-composite_primary_keys-1.1.3	tasks/databases/postgresql.rake
tyler-composite_primary_keys-1.1.4	tasks/databases/postgresql.rake
composite_primary_keys-2.3.5.1	tasks/databases/postgresql.rake
composite_primary_keys-2.3.5	tasks/databases/postgresql.rake
composite_primary_keys-2.3.2	tasks/databases/postgresql.rake
composite_primary_keys-1.0.2	tasks/databases/postgresql.rake
composite_primary_keys-1.0.10	tasks/databases/postgresql.rake
composite_primary_keys-1.0.3	tasks/databases/postgresql.rake
composite_primary_keys-0.9.0	tasks/databases/postgresql.rake
composite_primary_keys-0.9.91	tasks/databases/postgresql.rake
composite_primary_keys-0.9.92	tasks/databases/postgresql.rake
composite_primary_keys-0.9.93	tasks/databases/postgresql.rake
composite_primary_keys-1.0.0	tasks/databases/postgresql.rake
composite_primary_keys-1.0.1	tasks/databases/postgresql.rake
composite_primary_keys-0.9.90	tasks/databases/postgresql.rake