Has_and_belongs_to_many refer to same Model

I have a User model and in I want to have a

has_and_belongs_to_many :users

Obviously that won’t work since the join table will have the same column
names (user_id).

What approach should I take?

thanks

On Mon, Aug 24, 2009 at 6:24 PM, Allen
Walker[email protected] wrote:

I have a User model and in I want to have a

has_and_belongs_to_many :users

Obviously that won’t work since the join table will have the same column
names (user_id).

What approach should I take?

You need to give the association a different name, and a few other
things

class User
has_and_belongs_to_many :friends,
:class => “User”,
:association_foreign_key =>
“friend_id”,
:join_table =>
“friends_users”
end

You then need to make a join table named “friends_users” with no
primary key and user_id and friend_id columns.


Rick DeNatale

Blog: http://talklikeaduck.denhaven2.com/
Twitter: http://twitter.com/RickDeNatale
WWR: http://www.workingwithrails.com/person/9021-rick-denatale
LinkedIn: http://www.linkedin.com/in/rickdenatale

Thanks. one thing I noticed is that it’s “:class_name” not just “:class”
(2.3.3)

Rick Denatale wrote:

You need to give the association a different name, and a few other
things

class User
has_and_belongs_to_many :friends,
:class => “User”,
:association_foreign_key =>
“friend_id”,
:join_table =>
“friends_users”
end

You then need to make a join table named “friends_users” with no
primary key and user_id and friend_id columns.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs