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

Version Path
daddy-0.3.30 lib/tasks/db_create.rake
daddy-0.3.29 lib/tasks/db_create.rake
daddy-0.3.28 lib/tasks/db_create.rake
daddy-0.3.27 lib/tasks/db_create.rake
daddy-0.3.26 lib/tasks/db_create.rake
daddy-0.3.25 lib/tasks/db_create.rake
daddy-0.3.24 lib/tasks/db_create.rake
daddy-0.3.23 lib/tasks/db_create.rake
daddy-0.3.22 lib/tasks/db_create.rake
daddy-0.3.21 lib/tasks/db_create.rake
daddy-0.3.20 lib/tasks/db_create.rake
daddy-0.3.19 lib/tasks/db_create.rake
daddy-0.3.18 lib/tasks/db_create.rake
daddy-0.3.17 lib/tasks/db_create.rake
daddy-0.3.16 lib/tasks/db_create.rake
daddy-0.3.15 lib/tasks/db_create.rake
daddy-0.3.14 lib/tasks/db_create.rake
daddy-0.3.13 lib/tasks/db_create.rake
daddy-0.3.12 lib/tasks/db_create.rake
daddy-0.3.11 lib/tasks/db_create.rake