A weird database association

I’m trying to figure out a way to create this relationship:

a user has many friends which are themselves users

I have an existing ‘users’ table in the database. I’ve created a
‘friends’ database with:

id: integer
user_id: integer
friend_id: ineteger

I would like to create relationship so I could do something like:

friends_array = user.friends

where friends_array would be an array of ‘user’ objects.

2009/8/7 Jason B. [email protected]:

friend_id: ineteger

I would like to create relationship so I could do something like:

friends_array = user.friends

where friends_array would be an array of ‘user’ objects.

These might prove useful
http://dizzy.co.uk/ruby_on_rails/contents/self-referential-table-joins
http://railsforum.com/viewtopic.php?id=33161

Colin

Jason,

Start here:

Robby

On Fri, Aug 7, 2009 at 3:06 PM, Jason
Burgett[email protected] wrote:

friend_id: ineteger


Robby R.
Chief Evangelist, Partner

PLANET ARGON, LLC
design // development // hosting w/Ruby on Rails

http://robbyonrails.com/
http://twitter.com/planetargon
aim: planetargon

+1 503 445 2457
+1 877 55 ARGON [toll free]
+1 815 642 4068 [fax]

Thanks a ton. This one:

http://dizzy.co.uk/ruby_on_rails/contents/self-referential-table-joins

did the trick!

Colin L. wrote:

2009/8/7 Jason B. [email protected]:

friend_id: ineteger

I would like to create relationship so I could do something like:

friends_array = user.friends

where friends_array would be an array of ‘user’ objects.

These might prove useful
http://dizzy.co.uk/ruby_on_rails/contents/self-referential-table-joins
http://railsforum.com/viewtopic.php?id=33161
GitHub - swemoney/has_many_friends: A plugin for Rails that allows you to create friend relationships without the need of 2 friendship rows in their table. (Hasn't been updated in a long time.)

Colin