I have been banging my head against the wall and need to reach out and
ask for help.
I have three tables and thus three models, Cars, entity_map, and
Cars has a primary key named id
entity_map has two columns: ref_id and entity_id
wiki_edits has two columns: id (PK) and entity_id
to find a car's wiki_edits I would issue the following SQL fragment
from cars join entity_map on (cars.id = entity_map.ref_id) join
wiki_edits on (entity_map.entity_id = wiki_edits.entity_id)
The schema is set so I cannot change it. How would I use a combination
of has_many, belongs_to, and through attributes to define this
relationship inside the models? I have tried a bunch of different
approaches and have thus failed.
Any insight would be great.
Thanks in advance.