ActiveRecord::Extensions Question

[Drew Olson]

After a discussion of using ActiveRecord for data validation, it became
apparent to me (and others) that ActiveRecord was missing the ability to
iterate over a large set of records without storing the entire set in
memory. Someone in the thread mentioned that ActiveRecord Extensions may
have this ability. Essentially, I want to do a Table.findall).each,
however there are quite a lot of records and I'd like to iterate across
them without storing the entire dataset locally (something like a
cursor). Does ActiveRecord::Extensions have this ability? I've looked at
the documentation (what little I could find) and didn't see anything
like this.

-Drew

 

[Drew Olson]

Try ActiveRecord::Enumerable by Michael Schuerig:
http://schuerig.de/michael/blog/index.php/2007/02/03/ar-enumerable/

It uses a 'paged' find under the covers rather than cursors.

jeremy

Jeremy -

Thanks so much for the response. This seems to be almost exactly what I
was looking for. I will download later today and mess around with it.

-Drew

 

[Drew Olson]

Try ActiveRecord::Enumerable by Michael Schuerig:
http://schuerig.de/michael/blog/index.php/2007/02/03/ar-enumerable/

It uses a 'paged' find under the covers rather than cursors.

jeremy

Follow up question: is there a way to install these "plug-ins" without
using the rails framework? I am using ActiveRecord for standalone data
validation and hence I can't do a script/plugin install ...

Thanks,
Drew