
Untitled
By: a guest on
Aug 10th, 2012 | syntax:
None | size: 0.88 KB | hits: 6 | expires: Never
Rails 3 ActiveRecord nested associations select query
def quiz
@quiz = Quiz.find(params[:id])
@questions = @quiz.questions.select('id, content') # returns only selected fields
@results = @quiz.results.select('id, content, points_limit') # returns only selected fields
@questions.each do |question|
question['answers'] = question.answers.select('id, content, points') #returns whole object
end
@return = Hash.new
@return['questions'] = @questions
@return['results'] = @results
respond_to do |format|
format.json { render json: @return }
format.xml { render xml: @return }
end
end
question.answers.select('id, content, points')
@answers = Answer.select([:id, :content, :points])
.where(question_id: @questions.pluck(:id))
SELECT id, content, points
FROM answers
WHERE question_id in (<question_ids array>)