[sqlalchemy] Re: select() vs. self.session.query(): no group_by, different params?

2007-05-03 Thread Glauco
Michael Bayer ha scritto: On May 2, 2007, at 11:23 AM, Glauco wrote: Example: create table people ( name text, surname text, type CASE 'A','B','C' ) There is no solution to do for example the simple query based over the mapper People: select count(type) from people group by

[sqlalchemy] Re: select() vs. self.session.query(): no group_by, different params?

2007-05-02 Thread Glauco
Michael Bayer ha scritto: On Apr 24, 2007, at 4:05 PM, Chris Shenton wrote: Am I being stupid about not seeing the difference -- what keywords and arguments I can use -- between: self.session.query(MyClass).select(...) and select(...) these two methods are fundamentally

[sqlalchemy] Re: select() vs. self.session.query(): no group_by, different params?

2007-05-02 Thread Michael Bayer
On May 2, 2007, at 11:23 AM, Glauco wrote: Example: create table people ( name text, surname text, type CASE 'A','B','C' ) There is no solution to do for example the simple query based over the mapper People: select count(type) from people group by type; first of all, i dont