Ruby on rails associations not working

Question

I have two files.

clans.rb

class Clans < ActiveRecord::Base
  belongs_to :User
end

user.rb

class User < ActiveRecord::Base
  has_one :Clan
end

I also have two mysql tables.

clans: id | name | prefix | description | user_id

users: id | username | password | email | bindcode

clans.user_id being users.id of the clan leader.

In my code I can use the following in show.html.erb and it gives me the clan name.

<%= Clans.find(params[:id]).name %>

But I want to be able to do: Clans.find(params[:id]).leader.(users fields) Example:

<%= Clans.find(params[:id]).leader.username %>

How can I achieve this?

You need to name your user property as 'leader'.

Dave Newton
– Dave Newton

2013-10-25 13:53:37 +00:00
Commented Oct 25, 2013 at 13:53 — Dave Newton
– Dave Newton, Commented Oct 25, 2013 at 13:53

usha · Accepted Answer · 2013-10-25 13:54:01Z

1

class Clan < ActiveRecord::Base
  belongs_to :leader, :class_name => "User", :foreign_key => "user_id"
end

class User < ActiveRecord::Base
  has_one :clan
end

Notice the class change from Clans to Clan and association change from has_one :Clan to has_one :clan

answered Oct 25, 2013 at 13:54

usha

29.4k5 gold badges75 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mike Over a year ago

Thanks, this achieves what I wanted =D

Paul Richter · Accepted Answer · 2013-10-25 13:57:38Z

1

There are two ways you can achieve this:

belongs_to :leader, :class_name=>"User", :foreign_key=>"user_id"

Or

belongs_to :user
delegate :leader, :to=>:user

Note: The latter version will still allow you to do clan.user, as well as clan.leader.

answered Oct 25, 2013 at 13:57

Paul Richter

11.1k10 gold badges56 silver badges89 bronze badges

Comments

Thaha kp · Accepted Answer · 2013-10-25 13:53:40Z

0

belongs_to :user not belongs_to :User

same issue with Clans

answered Oct 25, 2013 at 13:53

Thaha kp

3,7091 gold badge28 silver badges25 bronze badges

1 Comment

Mike Over a year ago

This fixed it, mind explaining why? I dont really understand it.

Collectives™ on Stack Overflow

Ruby on rails associations not working

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related