Hi,

I have a class User and I want to have a friends relation ship  
between users in that table.
Is it possible to do it like in the snippet bellow. Is there a better  
way to do it with SQLObject?

I have tested this. and it works, but this construction doesn't fee  
right to me. Also the problems is that I have to do two add,  
u1.addUser(u2), u2.addUser(u1) to have the complete relation. Maybe  
whit a different construction I can do it in one operation.

class User(SQLObject):
     user_name = UnicodeCol(length=16, alternateID=True)
     display_name = UnicodeCol(length=255)
     ...
     friends = RelatedJoin('User', intermediateTable='user_user',
                           joinColumn='user_id', otherColumn='id')


Thanks for your suggestions
-fred-




-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to