CODEWITHSUNDEEP
ruby-on-rails-4has-many-throughhas-many
MetaStack
MetaStack

Reputation: 3696

how to specify has_many through vs has_many

So I'm trying to figure out how to specify between calling all instances of an object based on the has_many and has_many :through associations. I have users, groups and members. the member model is a pairing of groups and users. the groups also have a user_id in that model. so this will make more sense after you see the code:

user model 

class User < ActiveRecord::Base
  devise :database_authenticatable, :registerable,
         :recoverable, :rememberable, :trackable, :validatable

  has_many :groups
  has_many :groups, :through => :members
end

group model 

class Group < ActiveRecord::Base
    has_many :users, :through => :members
    belongs_to :user
end

member model 

class Member < ActiveRecord::Base
  belongs_to :groups
  belongs_to :users
end

Index View

<!--these are the groups I own (the group.user_id is my id) NEEDS EDITING-->
  <% @groups.each do |group| %>
      <%= link_to group.title, group_path(group) %>
      <%= truncate group.desc %>
  <% end %>

<!--I'm a member of these groups (connected through the member model) NEEDS EDITING'-->
  <% current_user.groups.order(:created_at).each do |group| %>
      <%= link_to group.title, group_path(group) %>
      <%= truncate group.desc %>
  <% end %>

I'm trying to figure out how to call the different types of associations users and groups in the Index View.

I want to get a list of all the groups that have me listed as admin (group.user_id) and then I want to get a separate list of all the groups that I'm a member of (through the member model).

I know I can query it with a find or where call. However, I was hoping there was a simple way like current_user.groups or something. anyway, thanks!

Upvotes: 0

Views: 156

Answers (1)

GSP
GSP

Reputation: 3789

I would consider calling the 1:N relationship to groups another name. So you would end up with something like

class User < ActiveRecord::Base
  devise :database_authenticatable, :registerable,
         :recoverable, :rememberable, :trackable, :validatable

  has_many :owned_groups, class_name: 'Group'
  has_many :groups, :through => :members
end

So the index view would look something like:

<% current_user.owned_groups.each do |group| %>
    <%= link_to group.title, group_path(group) %>
    <%= truncate group.desc %>
<% end %>


<% current_user.groups.order(:created_at).each do |group| %>
    <%= link_to group.title, group_path(group) %>
    <%= truncate group.desc %>
<% end %>

Upvotes: 1

Related Questions