Sha256: 6e6157d41e5a69de298fd0fdd75899aec27b8778f1741b09aa50893434ec22c7
Contents?: true
Size: 1.35 KB
Versions: 49
Compression:
Stored size: 1.35 KB
Contents
# coding: UTF-8 require 'rake' namespace :dad do namespace :db do desc 'database.yml に従ってDBを作成します。' task :create do config = YAML.load_file("#{Rails.root}/config/database.yml") FileUtils.mkdir_p("tmp") system("echo '# mysql ddl' > tmp/create_databases.sql") config.each do |env, props| puts "database for environment #{env}" system("echo 'drop database if exists #{props['database']};' >> tmp/create_databases.sql") system("echo 'create database #{props['database']};' >> tmp/create_databases.sql") system("echo 'grant all on #{props['database']}.* to #{props['username']} identified by \"#{props['password']}\";' >> tmp/create_databases.sql") if ENV['FILE'] system("echo 'grant all on #{props['database']}.* to #{props['username']}@localhost identified by \"#{props['password']}\";' >> tmp/create_databases.sql") system("echo 'grant file on *.* to #{props['username']}@localhost;' >> tmp/create_databases.sql") end end system("echo >> tmp/create_databases.sql") system("cat tmp/create_databases.sql") if ENV['NO_ROOT_PASSWORD'] fail unless system("mysql -u root < tmp/create_databases.sql") else fail unless system("mysql -u root -p < tmp/create_databases.sql") end end end end
Version data entries
49 entries across 49 versions & 1 rubygems