Contents

require File.expand_path '../../test/helper', __FILE__
namespace :db do
  desc "Creates the test database for MySQL."
  task :mysql do
    load 'test/db/mysql_config.rb' rescue nil
    t = Tempfile.new("mysql")
    t.puts <<-SQL
DROP DATABASE IF EXISTS `#{MYSQL_CONFIG[:database]}`;
CREATE DATABASE `#{MYSQL_CONFIG[:database]}` DEFAULT CHARACTER SET `utf8`;
GRANT ALL PRIVILEGES ON `#{MYSQL_CONFIG[:database]}`.* TO #{MYSQL_CONFIG[:username]}@localhost;
GRANT ALL PRIVILEGES ON `test\_%`.* TO #{MYSQL_CONFIG[:username]}@localhost;
SET PASSWORD FOR #{MYSQL_CONFIG[:username]}@localhost = PASSWORD('#{MYSQL_CONFIG[:password]}');
SQL
    t.close
    at_exit { t.unlink }
    password = ""
    if ENV['DATABASE_YML']
      require 'yaml'
      password = YAML.load(File.new(ENV['DATABASE_YML']))["production"]["password"]
      password_arg = " --password=#{password}"
    end
    sh "cat #{t.path} | mysql -u root#{password_arg}", :verbose => false # so password is not echoed
  end

  desc "Creates the test database for PostgreSQL."
  task :postgres do
    fail unless PostgresHelper.have_postgres?
    load 'test/db/postgres_config.rb' rescue nil
    t = Tempfile.new("psql")
    t.puts <<-SQL
DROP DATABASE IF EXISTS #{POSTGRES_CONFIG[:database]};
DROP USER IF EXISTS #{POSTGRES_CONFIG[:username]};
CREATE USER #{POSTGRES_CONFIG[:username]} CREATEDB SUPERUSER LOGIN PASSWORD '#{POSTGRES_CONFIG[:password]}';
CREATE DATABASE #{POSTGRES_CONFIG[:database]} OWNER #{POSTGRES_CONFIG[:username]};
SQL
    t.close
    at_exit { t.unlink }
    sh "cat #{t.path} | psql -U postgres"
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
activerecord-jdbc-adapter-1.2.9.1	rakelib/db.rake
activerecord-jdbc-adapter-1.3.0.beta1	rakelib/db.rake
activerecord-jdbc-adapter-1.2.9	rakelib/db.rake
activerecord-jdbc-adapter-1.2.8	rakelib/db.rake
activerecord-jdbc-adapter-1.2.5	rakelib/db.rake