Re: [SQLObject] Help on class design

[Fred C <bs...@gm...>]

On Dec 15, 2007, at 1:47 PM, Oleg Broytmann wrote:

> On Sat, Dec 15, 2007 at 01:18:08PM -0800, Fred C wrote:
>> I have two classes looking like shown bellow. I would like to know it
>> there is a way to access to the field status using SQLObjects methods
>> directly. (Without doing the joins my self).
>>
>> class Mbox(SQLObject):
>>     class sqlmeta:
>>         defaultOrder = "-created"
>>     subject = UnicodeCol(length=512)
>>     message = UnicodeCol()
>>     created = DateTimeCol(default=datetime.now)
>>     msg_from = ForeignKey('User', cascade=True)
>>     msg_to = RelatedJoin("User", intermediateTable='mbox_user',
>>                           joinColumn='mbox_id',
>>                           otherColumn='user_id',
>>                           createRelatedTable=False)
>>
>>
>> class MboxUser(SQLObject):
>> 	class sqlmeta:
>> 		table = "mbox_user"	
>> 	status = IntCol(default=0)
>> 	mbox = ForeignKey('Mbox', notNull=True, cascade=True)
>> 	user = ForeignKey('User', notNull=True, cascade=True)
>
>   for user in message.msg_to:
>      print user.status
>
>   Is it what you want?


Yes something like that.


-fred-