HowTo Use Active Record Outside Rails

RoR Programming
  • Create example database
$ mkdir db
$ sqlite db/database.sqlite
sqlite> create ......
  • Create tasks.rb
# require AR
require 'rubygems'
require_gem 'activerecord'

# connect to the database (sqlite in this case)
ActiveRecord::Base.establish_connection({
      "adapter" => "sqlite", 
      "dbfile" => "db/database.sqlite" 
})

# define a simple model 
class Task < ActiveRecord::Base
end
$ irb -r tasks.rb
irb> Task.create "title" => "Item #1" 
irb> Task.create "title" => "Item #2" 
irb> Task.find(:all).each { |t| puts t.title }