Active Record eager load across models

Question

Given the following models, how can I eager load a doctors specialty so I don't get crushed in a loop? Right now I'm able to load the Doctor and User user models but I'd also like to be able to load their profiles and, if possible, the doctors specialty.

MedicalRelationship.includes(:doctor, :user).where(user_id: [1,2,3])


class MedicalRelationship < ActiveRecord::Base
  belongs_to :user
  belongs_to :doctor, :class_name => "User"
end

class DoctorProfile < ActiveRecord::Base
  has_one :user, as: :profile, dependent: :destroy
  belongs_to :specialty
end

class PatientProfile < ActiveRecord::Base
  has_one :user, as: :profile, dependent: :destroy
end

class Specialty < ActiveRecord::Base
  has_many :doctors, class_name: "DoctorProfile"
end

score 3 · Accepted Answer · edited May 23 '17 at 11:58

3

You should be able to load them as follows

MedicalRelationship.includes({ doctor: { DoctorProfile: :specialty } }, :user).where(user_id: [1,2,3])

as shown in this answer by Joe Kennedy.

edited May 23 '17 at 11:58

Community

1
1

answered Aug 22 '15 at 16:08

Roope Hakulinen

7,326
4
43
66

This would fail if someone have a namespaced class for models. `{ DoctorProfile: :specialty }` would not work. You have to use: `{ doctor_profile: :specialty }` – K M Rakibul Islam Aug 22 '15 at 21:34

score 1 · Answer 2 · answered Aug 22 '15 at 21:24

Active Record lets you eager load any number of associations with a single Model.where/Model.find call by using an array, hash, or a nested hash of array/hash with the includes method.

In your case, you can eager load your all the associated models of MedicalRelationship using this:

MedicalRelationship.includes({ doctor: { doctor_profile: :specialty } }, :user).where(user_id: [1,2,3])

I strongly recommend you to read the Eager Loading Multiple Associations official documentation which explains it with some clear examples.

Active Record eager load across models

2 Answers2