Rakefile

require 'rubygems'
require 'bundler/setup'
require 'active_record'
require 'pg'
require 'yaml'

namespace :db do

  desc "Migrate the db"
  task :migrate do
    # connection_details = YAML::load(File.open('config/database.yml'))
    ActiveRecord::Base.establish_connection(ENV['DATABASE_URL']) # connection_details)
    ActiveRecord::Migrator.migrate("db/migrate/")
  end

  desc "Create the db"
  task :create do
    # connection_details = YAML::load(File.open('config/database.yml'))
    admin_connection = ENV['DATABASE_URL'].merge({'database'=> 'postgres',
                                                'schema_search_path'=> 'public'})
    ActiveRecord::Base.establish_connection(admin_connection)
    ActiveRecord::Base.connection.create_database(ENV['DATABASE_URL'].fetch('database'))
  end

  desc "drop the db"
  task :drop do
    # connection_details = YAML::load(File.open('config/database.yml'))
    admin_connection = ENV['DATABASE_URL'].merge({'database'=> 'postgres',
                                                'schema_search_path'=> 'public'})
    ActiveRecord::Base.establish_connection(admin_connection)
    ActiveRecord::Base.connection.drop_database(ENV['DATABASE_URL'].fetch('database'))
  end
end