On Fri, Dec 3, 2010 at 4:08 AM, jo <[email protected]> wrote:
> Hi all,
>
> I'm trying to write a GROUP BY query grouped by a function (to_char) using a
> variable format, which could be 'yy' or 'yyyy'
> as in:
>
> sql=session.query(
> func.to_char(Prestazione.c.data,format),
> func.sum(Prestazione.c.quantita).label('quantita'),
> func.sum(Prestazione.c.importo).label('importo')
> )
> sql=sql.filter(Verifica.c.codice == Tariffa.c.codice)
> sql=sql.filter(Prestazione.c.id_tariffa == Tariffa.c.id)
> sql=sql.group_by(Verifica.c.codice, func.to_char(Prestazione.c.data,format))
Have you tried using the same func result in both places, i.e.:
to_char = func.to_char(Prestazione.c.data,format)
sql=session.query(
to_char,
func.sum(Prestazione.c.quantita).label('quantita'),
func.sum(Prestazione.c.importo).label('importo')
)
sql=sql.filter(Verifica.c.codice == Tariffa.c.codice)
sql=sql.filter(Prestazione.c.id_tariffa == Tariffa.c.id)
sql=sql.group_by(Verifica.c.codice, to_char)
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
