.

Saturday, July 17, 2010

Activerecord Cassandra Adapter for RubyOnRails

activerecord-cassandra-adapter is a Cassandra adapter for ActiveRecord.
activerecord-cassandra-adapter depend on Cassandra Ruby Driver.
see rubygems.org/gems/cassandra
gem install activerecord-cassandra-adapter

- Example -

database.yml 

development: 
adapter: cassandra 
host: 127.0.0.1 
port: 9160 
keyspace: employees

Model class Employee < ActiveRecord::Base 
include ActiveCassandra::CF 
# identifier lambda { Time.now.tv_sec } 
end

ActiveRecord API 
# see http://api.rubyonrails.org/classes/ActiveRecord/Base.html 

emp = Emp.find(:first, :conditions => ["job = ? and sal >= ?", "MANAGER", 2800], :limit => 3, :offset => 1) 
p emp.id #=> "a198f990-719d-11df-974a-37650c93e624" 
emp.age = 30 
emp.save 
emp_list = Emp.find(:all, :conditions => {:empno => [7654, 7698, 7782]}) 
emp_list.each do |i|
 i.destroy if i.sal < 2000 
end 

new_emp = Emp.new 
new_emp.empno = 8000 
new_emp.ename = 'YAMADA' 
new_emp.age = 27 
new_emp.save! 

# not available: JOIN, ORDER, OR and etc... 

0 comments:

Post a Comment

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Macys Printable Coupons