- D
- E
- U
Instance Public methods
delete_all() Link
Deletes records in batches. Returns the total number of rows affected.
Person.in_batches.delete_all
See Relation#delete_all
for details of how each batch is deleted.
destroy_all() Link
Destroys records in batches.
Person.where("age < 10").in_batches.destroy_all
See Relation#destroy_all
for details of how each batch is destroyed.
each() Link
Yields an ActiveRecord::Relation
object for each batch of records.
Person.in_batches.each do |relation|
relation.update_all(awesome: true)
end
each_record() Link
Looping through a collection of records from the database (using the all
method, for example) is very inefficient since it will try to instantiate all the objects at once.
In that case, batch processing methods allow you to work with the records in batches, thereby greatly reducing memory consumption.
Person.in_batches.each_record do |person|
person.do_awesome_stuff
end
Person.where("age > 21").in_batches(of: 10).each_record do |person|
person.party_all_night!
end
If you do not provide a block to each_record
, it will return an Enumerator for chaining with other methods:
Person.in_batches.each_record.with_index do |person, index|
person.award_trophy(index + 1)
end
# File activerecord/lib/active_record/relation/batches/batch_enumerator.rb, line 36 def each_record return to_enum(:each_record) unless block_given? @relation.to_enum(:in_batches, of: @of, start: @start, finish: @finish, load: true).each do |relation| relation.records.each { |record| yield record } end end
update_all(updates) Link
Updates records in batches. Returns the total number of rows affected.
Person.in_batches.update_all("age = age + 1")
See Relation#update_all
for details of how each batch is updated.