How to use ActiveRecord in a ruby script outside Rails?

Question

I have a small ruby script in which I'd like to use ActiveRecord to easily access a database model. What is the best way to do it?

Answer 1

require "rubygems"
require "activerecord"

#Change this to reflect your database settings
ActiveRecord::Base.establish_connection (
  :adapter => "mysql",
  :host => "localhost",
  :username => "root",
  :password => "password",
  :database => "some_database")

#Now define your classes from the database as always
class SomeClass < ActiveRecord::Base
  #blah, blah, blah
end

#Now do stuff with it
some_class = SomeClass.new
some_other_stuff = SomeClass.find :all