[sqlalchemy] Re: sqlalchemy with turbogears and assign_mapper: group_by

2007-09-11 Thread Lukasz Szybalski
On 9/10/07, Roger Demetrescu [EMAIL PROTECTED] wrote: On 9/8/07, Lukasz Szybalski [EMAIL PROTECTED] wrote: On 9/7/07, Paul Johnston [EMAIL PROTECTED] wrote: Hi, And if I wanted to select a year and group by year? select User.Year from User group by User.Year

[sqlalchemy] Re: sqlalchemy with turbogears and assign_mapper: group_by

2007-09-11 Thread Lukasz Szybalski
Hi, And if I wanted to select a year and group by year? select User.Year from User group by User.Year db.execute(select([User.Year]) ??? Have a look at http://www.sqlalchemy.org/docs/04/sqlexpression.html Ok. Based on documentation. I do: import

[sqlalchemy] Re: sqlalchemy with turbogears and assign_mapper: group_by

2007-09-11 Thread Lukasz Szybalski
On 9/11/07, Lukasz Szybalski [EMAIL PROTECTED] wrote: Hi, And if I wanted to select a year and group by year? select User.Year from User group by User.Year db.execute(select([User.Year]) ??? Have a look at

[sqlalchemy] Re: sqlalchemy with turbogears and assign_mapper: group_by

2007-09-10 Thread Roger Demetrescu
On 9/8/07, Lukasz Szybalski [EMAIL PROTECTED] wrote: On 9/7/07, Paul Johnston [EMAIL PROTECTED] wrote: Hi, And if I wanted to select a year and group by year? select User.Year from User group by User.Year db.execute(select([User.Year]) ??? Have a look at