How to get has_and_belongs_to_many relation objects together

Question

I have HABTM associated tables like below.

class User < ActiveRecord::Base
    has_and_belongs_to_many :groups
end

class Group < ActiveRecord::Base
    has_and_belongs_to_many :users
end

How do I get User(s) with associated Groups together(nested), like below

{
    id: 8,
    name: "John",
    groups: [
      {
        id: 17,
        name: "Alpha Group",
        user_id: 8
      },
      {
        id: 18,
        name: "Bravo Group",
        user_id: 8
      }
    ],
},

Is there a nice rails way of doing this?

I can manually create object like above but it would be nice to have a simpler query.

What do you mean by `get User(s) with associated Groups together(nested)`? Are you trying to render this in your view? — oreoluwa, Jun 17 '16 at 05:35
Could you please post your controller code through which the said response will be generated? — Arslan Ali, Jun 17 '16 at 06:07
Yes, i need to return json. in controller, render status: 200, json: — Bigair, Jun 17 '16 at 07:09

score 1 · Accepted Answer · answered Jun 17 '16 at 05:55

def index
  @group = Group.find(params[:id])
  respond_to do |format|
    format.html
    format.json { @group.users.map do |user|
                 user.to_json(:include => :groups)
               end
             }
  end
end

It'll return an array like:

[
{
  "id":1,
  "email":"admin@example.com",
  "groups":[
     {
       "id":1,
       "name":"Yo"
     },
     {
       "id":2,
       "name":"Bro"
     },
  ]
},

{
  "id":2,
  "email":"valar@example.com",
  "groups":[
     {
       "id":1,
       "name":"Arya"
     },
     {
       "id":2,
       "name":"Stark"
     },
  ]
}
]

How to get has_and_belongs_to_many relation objects together

1 Answers1