namespace :spot do
  desc "Migrate the core Spontaneous database"
  task :migrate do
    Spontaneous.database.logger = Spontaneous.logger
    Sequel.extension :migration
    Sequel::Migrator.apply(Spontaneous.database, Spontaneous.gem_dir('db/migrations'))
  end


  namespace :database do
    desc "Make a dump of the current database"
    task :dump do
      dumpfilename = ENV['dumpfile']
      if dumpfilename.nil?
        dumpfilename = "#{Time.now.to_i}.mysql.gz"
      end
      dump_file = "tmp/#{dumpfilename}"
      dumper = Spontaneous::Utils::Database.dumper_for_database
      # Spontaneous::Cli::Site::MySQL.new(Spontaneous.database)
      dumper.dump(dump_file)
    end

    desc "Load a database dump into the local database"
    task :load do
      dumpfile = ENV['dumpfile']
      if dumpfile.nil?
        $stderr.puts "Usage: rake spot:database:load dumpfile=/path/to/dump.mysql.gz"
        exit 1
      end
      dumper = Spontaneous::Utils::Database.dumper_for_database
      # dumper = Spontaneous::Cli::Site::MySQL.new(Spontaneous.database)
      dumper.load(dumpfile)
    end
  end
end