rake_sequel.rb

require 'rspec'
require 'rake'
require 'sequel'

namespace :sql do
  task :migrate do
    Sequel::extension :migration
    Sequel::Migrator.run Sequel::Model.db, 'db/migrate', :target => 0
    Sequel::Migrator.run Sequel::Model.db, 'db/migrate'
  end
end


describe "test" do
  db = Sequel::Database.new()

  it "runs 'bundle exec rspec spec'" do
    Sequel.extension :migration, :core_extensions
    expect(Sequel).to receive(:extension).with :migration
    expect(Sequel::Migrator).to receive(:run).with(db, 'db/migrate', :target => 0)
    expect(Sequel::Migrator).to receive(:run).with(db, 'db/migrate')

    Rake::Task["sql:migrate"].invoke
  end

  it "runs 'bundle exec rspec spec' again" do
    Sequel.extension :migration, :core_extensions
    expect(Sequel).to receive(:extension).with :migration
    expect(Sequel::Migrator).to receive(:run).with(db, 'db/migrate', :target => 0)
    expect(Sequel::Migrator).to receive(:run).with(db, 'db/migrate')

    Rake::Task["sql:migrate"].invoke
  end
end