save this as

RAILS_ROOT/lib/tasks/custom_tasks.rake



equire "rake/clean"
require "builder"

# =============================================================================
# custom tasks for reliably initializing dev and test databases
# =============================================================================

desc "Drop and recreate dev and test databases"
task :recreate_dbs do
  cfg = database_config
  mysql_user = cfg["test"]['username']
  mysql_pass = cfg["test"]['password']
  drop_sql = "\"drop database if exists lumos_test; create database lumos_test;drop database if exists lumos_development; create database lumos_development;\""
  system "mysql -p#{mysql_pass} -u#{mysql_user} -e #{drop_sql}"
end

desc "Drop and recreate dbs and migrate"
task :init_dbs do
  Rake::Task[:recreate_dbs].invoke
  Rake::Task[:migrate].invoke
end

def database_config
  File.open( RAILS_ROOT+'/config/database.yml', 'r' ) do |file|
    @dbcfg = YAML::load( file )
  end if @dbcfg.nil?
  return @dbcfg
end