I have been trying to eager load associations based on some scope in my rails3 app, but could not find any solution.
My app has following models:
class Project has_many :entries has_many :to_dos
class ToDo has_may :entries has_many :tasks belongs_to :project
class Task has_many :entries belongs_to :to_do
class Entry belongs_to :project belongs_to :to_do belongs_to :task
# options format: {:from_date=>(Date.today-1.week), :to_date=>(Date.today +1.week), :user_id=>60} scope :filtered_list, lambda { |options| condition = options[:user_id].nil? ? "true" : "user_id = #{options[:user_id]}" condition += options[:from_date].nil? ? "" : " AND entry_date >= '#{options[:from_date]}'" condition += options[:to_date].nil? ? "" : " AND entry_date <= '#{options[:to_date]}'" where(condition) }
And in projects#index i have following code to get all projects of an user:
@projects = current_user.projects.includes(:entries, :to_dos =>[:entries, :tasks => :entries])
It fetches all projects of the user, along with eager loading the associations. So when i perform following loop to get all the entries within the project, no new query gets fired.
def all_entries(options) entries = self.entries self.to_dos.each do |d| entries += d.entries d.tasks.each do |t| entries += t.entries end end end
As this eager loading fetches all entries, it is way too much data than what I actually needed. So I tried to apply some conditions to the entries eager loaded, but could not find any solution. I was looking for something like:
@projects = current_user.projects.includes(:entries.filtered_list(options), :to_dos =>[:entries.filtered_list(options), :tasks => :entries.filtered_list(options)])
So that only the entries satisfying some conditions get loaded.
Can't we use scoping with eager loading? Please help me out use eagerloading alongside scoping.