Rails returning all of second level association

Question

I currently have three models that I am interested in: Region, Seat and User.

Region has many seats and seats have many available users.

I'd like to know what is the most efficient way in Rails to retrieve all of the available users for the seats which sit under a particular region.

Thanks in advance.

score 4 · Accepted Answer · answered Apr 26 '15 at 02:59

4

Try:

User.joins(seat: :region).where(regions: { id: REGION_ID_HERE })

answered Apr 26 '15 at 02:59

cschroed

This is broadly what I ended up doing, I realised the problem was that the User model sits in a different database connection for reasons. Thanks for all your help. – Bryce Roney Apr 26 '15 at 06:40

score 0 · Answer 2 · answered Apr 26 '15 at 03:48

I think the nested join syntax by @cschroed might not work depending on how your data model is set up. If it doesn't you can try:

User.joins(:seat).joins('inner join regions ON regions.id = seats.region_id').where(regions: {id: REGION_ID_HERE})

In either case, only a single query is run. If you already have the Region, you could run region.users if you set up something like:

class Region < ActiveRecord::Base
  has_many :seats
  has_many :users, through: :seats
 end

score 0 · Answer 3 · answered Apr 26 '15 at 05:40

0

This should work without any join issues

User.joins(seat: :region).merge(Region.where(id: :id_here))

answered Apr 26 '15 at 05:40

Mohammad AbuShady

3 Answers3