Rails - Feb 2012 - Rails multiple querys

I have this set of tables (I''m using postgresql)

User (with id, first_name, ....)
Assignment (with id, name, start_date, finish_date,....)
AssignmentUser(with assignment_id, user_id, flag_status)
The flag_status is a boolean that says if a user is still or not in an
assignment.

Let''s say user1 applies for assignment1, assignment2, assignment3 as
follows:

                                  start_date     finish_date
flag_status
user1  assignment1      11-11-11       11-12-11      false
user1  assignment2      01-10-11       01-02-12      true
user1  assignment3      01-01-12       01-03-12      true
Let''s say I want to search TODAY the closest start_date of an
user''s
assignment.

I''ve done this in my User model:

  def last_date
    self.assignments.where("date < ?", Date.today).max.try(:date)
  end
and this

def last_status
 
AssignmentUser.find_by_assignment_id_and_user_id(Assignment.find_by_date(self.last_date),
self.id).flag_status if self.last_date.present?
end
And in my view for each user:

User.all.each do |u|
  <td>   u.first_name   </td>
  <td>   u.last_email   </td>
  <td>   u.last_status  </td>
end
It works well but, in my log I see 3 queries for each user (as
expected). So my question is: how can I avoid these multiple queries?

Thanks in advance

Javier

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.