On Wed, Aug 20, 2008 at 11:42:56AM -0700, Golemon, Buck wrote:
> Neglecting the 'group by', how would you do this? If you want, I can
Two-tables join is done automatically - just declare relationship using
ForeigmKey/MultipleJoin/RelatedJoin. Three (or more) tables joins,
unfortunately, require more work. IWBN to solve this.
> look into submitting a patch to add 'group by' capability.
It is not that easy. Look, when you declare a table you also declare the
names and types of the columns:
class MyTable(SQLObject):
col1 = Type1Col()
col2 = Type2Col()
and when you call MyTable.select() SQLObject knows the list of columns.
With GROUP BY you have to pass a different list of columns; what would be
an API? sqlbuilder.Select() can do groupBy because it knows the list of
columns and ignores their types altogether.
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 the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
