How to build the following query

Question

I'm developing a web application about gift lists in Rails 3. I'd would like to get all the purchases for a certain list. These are the models and their relationships:

class Gift < ActiveRecord::Base
  belongs_to :list
  has_many :purchases

class List < ActiveRecord::Base
  has_many :gifts

class Purchase < ActiveRecord::Base
  belongs_to :gift

So, basically, I've tried the following code (I don't think it's the best way to do this at all), and eventhough the results are correct, I've realized that I get a Gift object instead of a Purchase:

@purchases = List.find(params[:id]).gifts.joins(:purchases).select("purchases.*")

Any ideas?

fl00r · Accepted Answer · 2011-04-26 20:06:07Z

2

@purchases = List.find(params[:id]).
                  gifts.joins(:purchases).
                  map(&:purchases).flatten

or just refactor your models:

class List < ActiveRecord::Base
  has_many :gifts
  has_many :purchases, :through => :gifts

so

List.find(params[:id]).purchases

answered Apr 26, 2011 at 20:06

fl00r

83.7k33 gold badges222 silver badges239 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Brian Roisentul Over a year ago

That what I was looking for! I've added the :purchases relation to the List model.

Jim Morris · Accepted Answer · 2011-04-26 20:06:07Z

1

If you want all the purchases maybe...

@purchases= List.find(params[:id]).gifts.collect{|g| g.purchases}

Although you may want to split it up and check that List.find returns a valid List.

edited Apr 26, 2011 at 20:06

answered Apr 26, 2011 at 19:57

Jim Morris

2,90025 silver badges15 bronze badges

1 Comment

Jim Morris Over a year ago

Although I prefer the refactor that @fl00r answered

Collectives™ on Stack Overflow

How to build the following query

2 Answers 2

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Related