Hello!
On Sat, Nov 10, 2007 at 05:39:36PM -0700, Travis Jensen wrote:
> I have several objects related using RelatedJoins in a Sqlite database:
>
> class Event(SQLObject):
> name = StringCol(alternateID=True,unique=True,notNone=True)
> description = StringCol(notNone=True)
> date = DateTimeCol(default=None)
> traveltime = IntCol(default=15)
> hosts = RelatedJoin('Household')
> guests = RelatedJoin('EventGuestGroup')
> courses = RelatedJoin('Course')
>
> class Host(SQLObject):
> household = ForeignKey('Household',notNone=True)
> people = RelatedJoin('Person')
>
> class Course(SQLObject):
> name = StringCol(notNone=True)
> length = IntCol(notNone=True,default=45)
> assignments = RelatedJoin('CourseAssignments')
>
> class EventGuestGroup(SQLObject):
> people = RelatedJoin('Person')
> event = ForeignKey('Event',default=None)
RelatedJoins have to be mutual:
class Event(SQLObject):
hosts = RelatedJoin('Household')
courses = RelatedJoin('Course')
class Household(SQLObject):
events = RelatedJoin('Event')
class Course(SQLObject):
events = RelatedJoin('Event')
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
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
