ActiveRecord::Base.foreach (for Oracle users)

Tuesday, 02 November 2010 10:03

attributes-sql-object-raw_cursor-instead

# Iterate over one record at a time using ActiveRecord, instead of being slurpy.



def self.foreach(conditions = nil, &block)

  conn = connection.raw_connection



  sql = "select * from #{table_name}"

  sql += " where #{conditions}" if conditions



  begin

    raw_cursor  = conn.exec(sql)



    while rec = raw_cursor.fetch_hash

      object = self.new



      # To get around protected attributes we must assign all attributes

      # individually, instead of passing a single hash to self.new.

      rec.each{ |key, value|

        cname = key.downcase

        object.send("#{cname}=", value)

      }



      yield object

    end

  ensure

    raw_cursor.close if raw_cursor

  end

end