Ruby-on-Rails: Multiple has_many :through possible?

by

Edit:

Rails 3.1 supports nested associations. E.g:

has_many :tasks
has_many :assigments, :through => :tasks
has_many :users, :through => :assignments

There is no need for the solution given below. Refer to this screencast for more details.

Original Answer

You are passing a has_many :through association as a source for another has_many :through
association. I don’t think it will work.

  has_many :friends, 
           :through => :friendships,
           :conditions => "status = #{Friendship::FULL}"
  has_many :friends_comments, :through => :friends, :source => :comments

You have three approaches to solving this issue.

1) Write an association extension

 has_many  :friends, 
           :through => :friendships,
           :conditions => "status = #{Friendship::FULL}" do
     def comments(reload=false)
       @comments = nil if reload 
       @comments ||=Comment.find_all_by_user_id(map(&:id))
     end
 end

Now you can get the friends comments as follows:

user.friends.comments

2) Add a method to the User class.

  def friends_comments(reload=false)
    @friends_comments = nil if reload 
    @friends_comments ||=Comment.find_all_by_user_id(self.friend_ids)
  end

Now you can get the friends comments as follows:

user.friends_comments

3) If you want this to be even more efficient then:

  def friends_comments(reload=false)
    @friends_comments = nil if reload 
    @friends_comments ||=Comment.all( 
             :joins => "JOIN (SELECT friend_id AS user_id 
                              FROM   friendships 
                              WHERE  user_id = #{self.id}
                        ) AS friends ON comments.user_id = friends.user_id")
  end

Now you can get the friends comments as follows:

user.friends_comments

All methods cache the results. If you want to reload the results do the following:

user.friends_comments(true)
user.friends.comments(true)

OR better still:

user.friends_comments(:reload)
user.friends.comments(:reload)

More Related Contents:

  1. Build vs new in Rails 3
  2. Rails :dependent => :destroy VS :dependent => :delete_all
  3. Rails: Using build with a has_one association in rails
  4. Rails has_many :through Find by Extra Attributes in Join Model
  5. Rails association with multiple foreign keys
  6. Rails: ActiveRecord query based on association value
  7. Getting fields_for and accepts_nested_attributes_for to work with a belongs_to relationship
  8. how to add records to has_many :through association in rails
  9. Rails has_many through form with checkboxes and extra field in the join model
  10. Rails – Sort by join table data
  11. using has_many :through and build
  12. The better way to pass the foreign_key value to the Rails controller
  13. SSL_connect returned=1 errno=0 state=SSLv3 read server certificate B: certificate verify failed
  14. Best way to load module/class from lib folder in Rails 3?
  15. ActiveRecord.find(array_of_ids), preserving order
  16. In Ruby on Rails, how do I format a date with the “th” suffix, as in, “Sun Oct 5th”?
  17. How to redirect to previous page in Ruby On Rails?
  18. file download link in rails
  19. What’s the best way to use SOAP with Ruby?
  20. Heroku Postgres Error: PGError: ERROR: relation “organizations” does not exist (ActiveRecord::StatementInvalid)
  21. Ruby on Rails: Where to define global constants?
  22. Installing Postgres on windows for use with Ruby-on-Rails
  23. Using send_file to download a file from Amazon S3?
  24. Uploading multiple files with paperclip
  25. How to store data in S3 and allow user access in a secure way with rails API / iOS client?
  26. Changing the base URL for Rails 3 development
  27. Rails segmentation fault when starting server?
  28. Ruby on rails 4 app does not work in iframe
  29. Validates acceptance always failing
  30. Incompatible library version: nokogiri.bundle requires version 11.0.0 or later, but libxml2.2.dylib

Leave a Comment