On 16 ene, 16:54, Erwin <[email protected]> wrote:
> when I use a quart joins on Roles and Profiles models
>
> Role.joins(:profiles).where('profiles.profilable_type' => "Admin")
>
> I get the following generated sql
> SELECT `roles`.* FROM `roles` INNER JOIN `profiles_roles` ON
> `profiles_roles`.`role_id` = `roles`.`id` INNER JOIN `profiles` ON
> `profiles`.`id` = `profiles_roles`.`profile_id` WHERE
> `profiles`.`profilable_type` = 'Admin'
>
> which gives me all roles attributes only
>
> I should I write my Rails query to get all attributes ?
>
> SELECT `roles`.*, `profiles`.* FROM `roles` INNER JOIN
> `profiles_roles` ON `profiles_roles`.`role_id` = `roles`.`id` INNER
> JOIN `profiles` ON `profiles`.`id` = `profiles_roles`.`profile_id`
> WHERE `profiles`.`profilable_type` = 'Admin'
>
> in this case, I'll have 2 attributes with same name in both tables
> ( :id and :name ) is there any way to avoid such collision ( using
> AS ...)
>
> ======
> class Role < ActiveRecord::Base
> has_and_belongs_to_many :profiles, :join_table => :profiles_roles
If for some reason you need the results of the join, you can do:
Role.joins(:profiles).where('profiles.profilable_type' =>
"Admin").select('profiles.id, roles.id, profiles.name, profiles.id as
p_id') # you can use the sql 'as' in the string
Keep in mind this will return an ActiveRecord::Relation instance, not
a set of Role or Profile, so if your plan is to iterate through
results, you better do it as Collin instructed
--
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.
