On Mon, Oct 08, 2007 at 09:06:59PM +0200, Daniel Fetchinson wrote:
> question is if there was any way to select the number of animals from
> zoo 'myzoo' in the above example (using inheritance) with a single
> query. Apparently the above query is not gonna work but is there
> another way? Of course one can do several queries but that might hurt
> performance. If there is such a single query I'll continue using
> inheritance if there is none then I'll just design my models such that
> there is no inheritance at all.
If you don't need different classes from one .select() you probably
could go with simple *Python* inheritance:
class named( SQLObject ):
name = StringCol( )
class zoo( named ):
# name = StringCol( )
cages = MultipleJoin( 'cage' )
etc...
The column 'name' will be included in the every table.
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
