require 'rake'
namespace :db do
  
  desc "Drops (if it exists) the database and then creates it for your environment."
  task :recreate => :environment do
    Mack::Database.drop(Mack.env, repis)
    Mack::Database.create(Mack.env, repis)
  end # recreate
  
  desc "Creates the database for your environment."
  task :create => :environment do
    Mack::Database.create(Mack.env, repis)
  end # create
  
  desc "Drops the database for your environment."
  task :drop => :environment do
    Mack::Database.drop(Mack.env, repis)
  end # drop
  
  namespace :create do
    
    desc "Creates your test and development databases. Does NOT create your production database!"
    task :all => :environment do
      Mack::Database.create("test", repis)
      Mack::Database.create("development", repis)
    end # all
    
  end # create
  
  namespace :drop do
    
    desc "Drops your test and development databases. Does NOT create your production database!"
    task :all => :environment do
      Mack::Database.drop("test", repis)
      Mack::Database.drop("development", repis)
    end # all
    
  end # drop
  
  namespace :recreate do
    
    desc "Drops and creates your test and development databases. Does NOT create your production database!"
    task :all => :environment do
      Mack::Database.drop("test", repis)
      Mack::Database.create("test", repis)
      Mack::Database.drop("development", repis)
      Mack::Database.create("development", repis)
    end # all
    
  end # recreate
  
  namespace :structure do
    
    desc "Dump the database structure to a SQL file"
    task :dump => "mack:environment" do
      Mack::Database.dump_structure(Mack.env, repis)
    end # dump
    
    desc "Create the database from a SQL file"
    task :load => "mack:environment" do
      file = (ENV["FILE"] ||= File.join(Mack.root, "db", "development_default_schema_structure.sql"))
      Mack::Database.load_structure(file, Mack.env, repis)
    end # load
    
  end # structure
  
  private
  def repis
    (ENV["REPO"] ||= "default").to_sym
  end

end # db