Ruby on Rails

On 7 November 2014 03:05, Dave Castellano <lists@ruby-forum.com> wrote:
> Hi,
>
> I'm stuck trying to figure out how to do a query to find all the
> questions in a selected subject only.
>
> My associations:
>
> class Subject < ActiveRecord::Base
> has_many :books
> has_many :questions
> has_many :chapters, :through => :books
> has_many :sections, :through => :chapters
> has_many :subsections, :through => :sections
> has_many :minisections, :through => :subsections
>
> class Question < ActiveRecord::Base
> has_and_belongs_to_many :minisections
>
> The query:
> @question_list = Question.where(all the questions associated with the
> subject through the above associations???)

@question_list = @subject.questions

Note, though, that since you have subject has_many questions you also
need question belongs_to subject. Also you need to re-think your
associations as you have two routes to question from subject -
directly through the has_many but also right through the chain of
chapters, etc.

Colin

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAL%3D0gLsHRFq0E%3DQQC1JYOtuHHCJGxRvGffcYvqAFVVfp2d2SFQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.