Hello,
I'm tinkering with many-to-many relationships and more specific with
self references.
Let's stick with a bunch of Tradesmen (just as an example). One
Tradesman knows several suppliers and purchasers. And all of them are
tradesmen.
This gives us the following scheme:
------------- * purchaser
| Tradesman |-----------
------------- |
*| |
supplier | |
------------------
My solution so far is:
class Tradesman(SQLObject):
name = StringCol(alternateID = True)
suppliers = RelatedJoin('Tradesman',
addRemoveName = 'Supplier',
joinColumn = 'purchaser', otherColumn = 'supplier')
purchasers = RelatedJoin('Tradesman',
addRemoveName = 'Purchaser',
joinColumn = 'supplier', otherColumn = 'purchaser')
This way it seems to work smoothly. The only drawback is that table
creation fails with an error due to the attempt to create the table
'tradesman_tradesman' twice.
Is this the most convenient way to do self references, and if yes, is
there a way to prevent the second attempt to create 'tradesman_tradesman'?
Cheers,
--
Soni Bergraj
(I'm puzzled if the 'How can I join a table with itself?' from the FAQ
is intended to address this, i did not find anything about Alias on the
SQLBuilder docs)
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
