_rake_migrate_without_rails.markdown

Rake migrate without rails

This is a very barebones database migration setup. All that's needed is what's required in the Rakefile and Ruby, of course.

config:database.yml

adapter: mysql
encoding: utf8
database: database_name
username: root
password:

db:migrate:001_test_migration.rb

class TestMigration < ActiveRecord::Migration
  def self.up
    create_table :users do |t|
      t.column :name, :string, :null => false
    end
  end

  def self.down
    drop_table :users
  end
end

Rakefile

require 'active_record'
require 'yaml'
require 'mysql'
require 'logger'

task :default => :migrate

desc "Migrate the database through scripts in db/migrate. Target specific version with VERSION=x"
task :migrate => :environment do
  ActiveRecord::Migrator.migrate('db/migrate', ENV["VERSION"] ? ENV["VERSION"].to_i : nil )
end

task :environment do
  ActiveRecord::Base.establish_connection(YAML::load(File.open('config/database.yml')))
  ActiveRecord::Base.logger = Logger.new(File.open('database.log', 'a'))
end