preload_associations
preload_associations(records, associations, preload_options={})Eager loads the named associations for the given Active Record record(s).
In this description, ‘association name’ shall refer to the name passed to an association creation method. For example, a model that specifies belongs_to :author, has_many :buyers has association names :author and :buyers.
Parameters
records is an array of ActiveRecord::Base. This array needs not be flat, i.e. records itself may also contain arrays of records. In any case, preload_associations will preload the all associations records by flattening records.
associations specifies one or more associations that you want to preload. It may be:
-
a Symbol or a String which specifies a single association name. For example, specifying :books allows this method to preload all books for an Author.
-
an Array which specifies multiple association names. This array is processed recursively. For example, specifying [:avatar, :books] allows this method to preload an author’s avatar as well as all of his books.
-
a Hash which specifies multiple association names, as well as association names for the to-be-preloaded association objects. For example, specifying { :author => :avatar } will preload a book’s author, as well as that author’s avatar.
:associations has the same format as the :include option for ActiveRecord::Base.find. So associations could look like this:
:books [ :books, :author ] { :author => :avatar } [ :books, { :author => :avatar } ]
preload_options contains options that will be passed to ActiveRecord::Base#find (which is called under the hood for preloading records). But it is passed only one level deep in the associations argument, i.e. it’s not passed to the child associations when associations is a Hash.
1Note
Whacky edge case
The above works great as long as you select the primary key of the owning assocations.
preload_associations calls a group_by on that object so if there is no primary key attributed filled out it will reduce the records to 1 object. ex: rows = foo.find(:all,:select=>"boo.id, foo.name, foo.age, count(DISTINCT foo.id)", :group=>"foo.name,foo.age having count( DISTINCT foo.id) > 1",:joins=>"INNER JOIN bar.foo on bar.foo_id = foo.id")
preload_assications(rows,:bar)
rows.first.bar.name #=> sql call already made in preload rows.last.bar.name #=> just made another sql call to get bar
fix: :select=>"foo.id, boo.id, foo.name, foo.age, count(DISTINCT foo.id)"
now preload_associations will include all the ids found instead of just the 1st one.