From: Don S. <don...@gm...> - 2006-01-24 01:03:43
|
I've searched the docs and the list for an example using Group By. Select mycolumn, count(*) from mytable Group By mycolumn I'd like to do something similar to the above. Does anyone have a code snippet I could build from? Thanks, Don |
From: Oleg B. <ph...@ma...> - 2006-01-24 08:31:02
|
On Mon, Jan 23, 2006 at 05:03:37PM -0800, Don Smith wrote: > I've searched the docs and the list for an example using Group By. > Select mycolumn, count(*) from mytable Group By mycolumn SQLOBject's objects are instances of "table" clasess: class MyTable(SQLObject): ... In your case it is impossible to return instances of MyTable. because of this SQLObjects do not support GROUP BY. Only sqlobject.sqlbuilder.Select() supports GROUP BY... Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Ian B. <ia...@co...> - 2006-01-24 16:47:13
|
Oleg Broytmann wrote: > On Mon, Jan 23, 2006 at 05:03:37PM -0800, Don Smith wrote: > >>I've searched the docs and the list for an example using Group By. >>Select mycolumn, count(*) from mytable Group By mycolumn > > > SQLOBject's objects are instances of "table" clasess: > > class MyTable(SQLObject): > ... > > In your case it is impossible to return instances of MyTable. because of > this SQLObjects do not support GROUP BY. Only sqlobject.sqlbuilder.Select() > supports GROUP BY... Something about this needs to go in the FAQ, since Don's question is the second on the matter in one day I think. I'm not sure what particular use case to address in the FAQ, though. -- Ian Bicking / ia...@co... / http://blog.ianbicking.org |
From: Oleg B. <ph...@ph...> - 2006-01-26 17:36:41
|
On Tue, Jan 24, 2006 at 10:46:50AM -0600, Ian Bicking wrote: > Oleg Broytmann wrote: > >On Mon, Jan 23, 2006 at 05:03:37PM -0800, Don Smith wrote: > > > >>I've searched the docs and the list for an example using Group By. > >>Select mycolumn, count(*) from mytable Group By mycolumn > > > > > > SQLOBject's objects are instances of "table" clasess: > > > >class MyTable(SQLObject): > > ... > > > >In your case it is impossible to return instances of MyTable. because of > >this SQLObjects do not support GROUP BY. Only sqlobject.sqlbuilder.Select() > >supports GROUP BY... > > Something about this needs to go in the FAQ, since Don's question is the > second on the matter in one day I think. I'm not sure what particular > use case to address in the FAQ, though. I added a section to the FAQ: http://svn.colorstudy.com/SQLObject/docs/FAQ.txt explaining that not every query can be represented in terms of SQLObject's classes. Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |