Sha256: c42b720db64a940a77be477d3735915e458d98126005410721851f5355d0f6b8

Contents?: true

Size: 967 Bytes

Versions: 11

Compression:

Stored size: 967 Bytes

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")
      
      system("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")
      end
      
      system("echo >> tmp/create_databases.sql")
  
      system("cat tmp/create_databases.sql")
      ret = system("mysql -u root -p < tmp/create_databases.sql")
      fail unless ret
    end
  end
end

Version data entries

11 entries across 11 versions & 1 rubygems

Version Path
daddy-0.1.0 lib/tasks/db_create.rake
daddy-0.0.22 lib/tasks/db_create.rake
daddy-0.0.21 lib/tasks/db_create.rake
daddy-0.0.20 lib/tasks/db_create.rake
daddy-0.0.19 lib/tasks/db_create.rake
daddy-0.0.18 lib/tasks/db_create.rake
daddy-0.0.17 lib/tasks/db_create.rake
daddy-0.0.16 lib/tasks/db_create.rake
daddy-0.0.15 lib/tasks/db_create.rake
daddy-0.0.14 lib/tasks/db_create.rake
daddy-0.0.13 lib/tasks/db_create.rake