Rakefile

require 'rubygems'
require 'sinatra'
require 'sequel'

Sequel.extension :migration
DB = Sequel.connect(ENV['DATABASE_URL'] || 'sqlite://database/chit_chat.db')

desc 'Perform migration reset (full erase and migration up)'
task :reset do
  Sequel::Migrator.run(DB, 'migrations', :target => 0)
  Sequel::Migrator.run(DB, 'migrations')
  puts '<= sq:migrate:reset executed'
end

desc 'Perform migration up/down to VERSION'
task :to do
  version = ENV['VERSION'].to_i
  raise 'No VERSION was provided' if version.nil?
  Sequel::Migrator.run(DB, 'migrations', :target => version)
  puts "<= sq:migrate:to version=[#{version}] executed"
end

desc 'Perform migration up to latest migration available'
task :up do
  Sequel::Migrator.run(DB, 'migrations')
  puts '<= sq:migrate:up executed'
end

desc 'Perform migration down (erase all data)'
task :down do
  Sequel::Migrator.run(DB, 'migrations', :target => 0)
  puts '<= sq:migrate:down executed'
end