youre doing a SQL query, which is not directly compatible with the
querying method provided off of an ORM Query object (we differ from
Hibernate in that regard, which is somehow able to mix them all
together).
you probably want to use the Table directly and do:
self.plan.select
([self.plan.c.month,self.plan.c.instrument_id,func.count
(self.plan.c.instrument_id)],
and_(self.plan.c.year==int(year), self.plan.c.data.ilike('%%%s%%' %
project)), group_by=[self.plan.c.month, self.plan.c.instrument_id])
On Sep 14, 2006, at 9:43 AM, Enrico Morelli wrote:
> Dear all,
>
> there is some syntax error in the following select?
>
> results =
> self.mysession.query(PlanEntry).select
> ([self.plan.c.month,self.plan.c.instrument_id,func.count
> (self.plan.c.instrument_id)],
> and_(self.plan.c.year==int(year), self.plan.c.data.ilike('%%%s%%' %
> project)), group_by=[self.plan.c.month, self.plan.c.instrument_id])
>
> I think yes, because I receive the following error:
>
> group_by=[self.plan.c.month, self.plan.c.instrument_id])
> TypeError: select() takes at most 2 non-keyword arguments (3 given)
>
> The group_by method isn't the same 'GROUP BY' SQL statement?
>
> Thanks
>
> --
> -------------------------------------------------------------------
> (o_
> (o_ //\ Coltivate Linux che tanto Windows si pianta da solo.
> (/)_ V_/_
> +------------------------------------------------------------------+
> | ENRICO MORELLI | email: [EMAIL PROTECTED] |
> | * * * * | phone: +39 055 4574269 |
> | University of Florence | fax : +39 055 4574253 |
> | CERM - via Sacconi, 6 - 50019 Sesto Fiorentino (FI) - ITALY |
> +------------------------------------------------------------------+
>
> ----------------------------------------------------------------------
> ---
> Using Tomcat but need to do more? Need to support web services,
> security?
> Get stuff done quickly with pre-integrated technology to make your
> job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> http://sel.as-us.falkag.net/sel?
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
