ActiveRecord::Base.foreach (for Oracle Users)

• Tweet
• 

        # 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

Tags:
• active_record
• Rails
• Ruby