require 'rake'
require 'minitest/test_task'
require 'dotenv'

Dotenv.load!

Minitest::TestTask.create(:test) do |t|
  # t.libs << "test"
  # t.libs << "lib"
  t.warning = false
  t.test_globs = ['test/**/test_*.rb']
end

namespace 'db' do
  desc 'Migrate the database to the lasted schema'
  task 'migrate' do
    exec("bundle exec sequel -E -m db/migrations #{ENV['DB_URL']}")
  end

  desc 'Reset all tables, schema, data'
  task 'reset' do
    exec(%[sequel "postgres://postgres@localhost" -c "puts DB.run('DROP DATABASE IF EXISTS spacetraders_debug'); puts DB.run('CREATE DATABASE spacetraders_debug;')"])

    # `rm #{ENV['DB_URL']} && bundle exec rake db:migrate`
  end

  desc 'Seed some default dataset'
  task 'seed' do
    exec('ruby bin/seed')
  end
end

task default: :test