vsbabu.org

Oracle with Active Record

1. Install Ruby
2. Install Active Record. Open a DOS shell and run gem install activerecord.
3. Install OCI8 driver for Ruby. Download ruby-oci8-mswin and double click it.

Assuming you’ve standard scott/tiger schema on some Oracle connection (the TNSNAMES.ORA entry in the example below is named as development), here is a small sample script that shows how to manipulate the data in one table.

require 'active_record' ActiveRecord::Base.establish_connection( :adapter => "oci", :username => "scott", :password => "tiger", :host => "development") class Department < ActiveRecord::Base set_table_name "DEPT" set_primary_key "deptno" end print "-----------------------------------------------------------------\n" print " Current Records \n" print "-----------------------------------------------------------------\n" Department.find(:all).each do |dep| printf("%6d %-20s %-20s\n", dep.deptno, dep.dname, dep.loc) end print "-----------------------------------------------------------------\n" print " Add 1 Record \n" print "-----------------------------------------------------------------\n" mydep = Department.new(:id=>77) mydep.dname = "New test dep" mydep.loc = "Boston" mydep.save() Department.find(:all).each do |dep| printf("%6d %-20s %-20s\n", dep.deptno, dep.dname, dep.loc) end print "-----------------------------------------------------------------\n" print " Delete New Record \n" print "-----------------------------------------------------------------\n" Department.delete(mydep.id) Department.find(:all).each do |dep| printf("%6d %-20s %-20s\n", dep.deptno, dep.dname, dep.loc) end

Name this as oracle_sample.rb and run it. See how easy it is? Now is a good time to explore Active Record Documentation and explore the other cool things possible. Toss out your Pro*C reports today and switch to Ruby with Active Record.