In the following hypothetical scenario, I’d like to associate Books
with Clubs without using finder_sql. Apparently, if you use
finder_sql, all the find_in_collection methods are not added to the
associated objects. Without which I won’t be able to call
my_club.books.find(:all, :conditions => ‘is_read = true’) or to do
pagination for example.
Class Club < ActiveRecord::Base
has_many :memberships
has_many :readers, :through => :memberships
#DOES NOT WORK
#has_many :books, :through => :readers
#DOES NOT ADD find_in_collection METHODS
#has_many :books, :finder_sql =>
# %q{
# select distinct books.*
# from books
# join memberships on books.reader_id
= memberships.reader_id and memberships.club_id = #{self.id}
# order by books.read_at desc
# }
end
Class Memberships < ActiveRecord::Base
belongs_to :club
belongs_to :reader
end
Class Reader < ActiveRecord::Base
has_many :memberships
has_many :books
end
Class Book < ActiveRecord::Base
belongs_to :reader
end
Does anyone have any idea how I can create this association without
rewriting the find_in_collection methods?
Thanks!