I have a join model (context) that ties three models together (files,
versions, sentences). Sentences have a translation.
translation <-- sentences
|
|
files----(context)----versions
files-> has_many :sentences, :through => :contexts
sentences -> belongs_to :translation
I want to get all sentences and their translations for a file for a
given version. I want to do it with eager loading, to feed the view
with the whole set and not have additional queries.
If I do file.sentences.find(:all,:include => :translation) I get all of
them (for all versions). If I add conditions, say ‘version_id = 2’,
then they applied to all records, not to the join and I lose the
untranslated sentences.
I’ve made it work by adding at runtime, right before the .find(), a
has_many relationship, like this:
Files.has_many “sentences_by_version_#{vid}”.to_sym,:class_name =>
‘Context’,:conditions => [‘contexts.versio_id = ?’,vid]
And then including :sentences_by_version_2 (or whatever id’s value is).
Is there a cleaner way to do this with eager loading? The has_many has
to be created everytime. Maybe overloading a method of my class and
using a lambda? Any ideas?
I need to get the sentences (with outer join), not the contexts, because
that yields the sentences that are not translated. So, somehow I need
to push a condition on the join.
Thanks, Eduardo.