Simple Migration for cuba and sinatra

dbcreate.sh

rake db:create

dbmigrate.sh

rake db:migrate

example.sh

rake db:create RACK_ENV=production
rake db:migrate VERSION=10

migration.rake

require 'active_record'

task(:environment) do
  env = ENV["RACK_ENV"] ? ENV["RACK_ENV"] : "development"
  ActiveRecord::Base.establish_connection(YAML::load_file('config.yml')['database'][env])
end

namespace :db do
  task(:create => :environment) do
    env = ENV["RACK_ENV"] ? ENV["RACK_ENV"] : "development"
    config = YAML::load_file('config.yml')['database'][env]
    ActiveRecord::Base.establish_connection(config.merge('database' => nil))
    ActiveRecord::Base.connection.create_database config['database']
  end

  task(:migrate => :environment) do
    ActiveRecord::Migrator.migrate('db/migrate', ENV['VERSION'] ? ENV['VERSION'].to_i : nil)
  end
end