From: Neil Kohl <nakohl@...>
Date: 2006-11-21T01:08:20+09:00
Subject: Re: DBI and cursors?

------=_Part_31757_26174700.1164038897082
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

(Sorry, hit send accidentally before finishing ...)

Do you mean reusing a SQL statement/statement handle to increase
performance?

require 'dbi'

select_sql  = 'select id, class_desc from products'
update_sql = 'update products SET category = ? where idn = ?'

dbh = DBI.connect('dbi:oci8:dbname', 'user','passwd');
select_sth = dbh.prepare(select_sql)
update_sth = dbh.prepare(update_sql)

select_sth.execute
select_sth.each do |row|
   category = calculate_category(row[1])
   update_sth.execute(row[0], category)
end



> On 11/20/06, Ken Bloom <kbloom@gmail.com> wrote:
> >
> > I'm writing a program to run through large numbers of records in a
> > database, classify them using a machine learning algorithm (rubysvm),
> > and
> > store the results in the database by updating a single column on the
> > record.
> >
> > Most of my database work thus far has been using DBI. Is it possible to
> > update each row through the cursor (similar to how JDBC can be used) in
> > DBI? Is there some other way of accessing the database that can do this?
> >
> > --Ken
> >
> > --
> > Ken Bloom. PhD candidate. Linguistic Cognition Laboratory.
> > Department of Computer Science. Illinois Institute of Technology.
> > http://www.iit.edu/~kbloom1/ <http://www.iit.edu/%7Ekbloom1/>
> >
> >

-- 
Neil Kohl
nakohl@gmail.com

------=_Part_31757_26174700.1164038897082--