I'm trying to replicate a join in RoR that I can do in SQL very
simply.
Three tables/models that I have are: Users, Users_Activities,
Activities and Codes.
Users and Activities have appropriate has_many associations through
Users_Activities model, so it's easy to do a join to get all
activities for a given user.
Codes, on the other hand, is a different story. It's kind of a
"repository" of all codified data. For example, the Activity table
has a "Activity Type" field that is an integer field. To get the
actual Activity Type name, you have to look it up in the Codes table
like so (joining with user table to get all activities for user id
"1"):
select activities.*, codes.name from activities, users_activities,
codes
where users_activities.user_id = 1
and users_activities.activity_id = activities.id
and activities.activity_type = codes.id
I can do part of the above query if i don't include the Codes table
like so:
Activity.all(:joins => :users_activities, :conditions =>
{'users_activities.user_id' => "1"})
How do I also join Codes?
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
