Nick Murdoch wrote:
> Bill Denney wrote:
>
>> I have several tables that are generally something like:
>>
>> class House(SQLObject):
>> notes = MultipleJoin('Notes')
>>
>> class Room(SQLObject):
>> notes = MultipleJoin('Notes')
>>
>> class Notes(SQLObject):
>> house = MultipleJoin('House')
>> room = MultipleJoin('Room')
>> info = StringCol()
>>
> The house and room parameters in Notes should probably be
> ForeignKey('House') and ForeignKey('Room'). Only RelatedJoin uses the
> same keyword at each end of the "link" between classes.
>
Whoops, My brain got stuck on MultipleJoin. Actually all the
MultipleJoins are RelatedJoins. My main goal is to only define the
notes table once (in code, I don't really care how many tables are
formed in the database) and for each note to map singly back to either a
room or a house (not both), and for a house and room to have any number
(zero or more) of notes. What is the best/most efficient way to do this?
Thanks,
Bill
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
