[SQL-CVS] [ sqlobject-Bugs-1384706 ] n:m join of a table with itself overwrites methods

[SourceForge.net <no...@so...>]

Bugs item #1384706, was opened at 2005-12-18 23:28
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1384706&group_id=74338

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Matthias Urlichs (smurf)
Assigned to: Nobody/Anonymous (nobody)
Summary: n:m join of a table with itself overwrites methods

Initial Comment:
I'm trying to do a n:m join of a table with itself.

Unfortunately, the accessor methods are named only by
the referenced table and thus get overwritten.

The same problem would occur if I had two *different*
RelatedJoins between two tables, which is not at all
unheard-of.

class ACLUser(sql.SQLObject):
    """\
        This class represents a user (or group).

        Names are not necessarily unique; for the most
part, visibility
        rules control which ACLs anybody can see.
        """
    name = sql.StringCol(length=40, notNone = True)

    groups = sql.RelatedJoin('ACLUser',
joinColumn='user_id',
        otherColumn='group_id',
intermediateTable='acl_roles')
    members = sql.RelatedJoin('ACLUser',
joinColumn='group_id',
        otherColumn='user_id',
intermediateTable='acl_roles',
        createRelatedTable=False)



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1384706&group_id=74338