[Sqlalchemy-users] sqlalchemy creates Syntax Error with select GROUP BY and ORDER BY

[Andreas Kostyrka]

Hi!

What am I doing wrong?

select([media.c.status, func.count(media.c.id)],
group_by=[media.c.status], order_by=[media.c.status],
*args).execute().fetchall():

provokes this error:

psycopg.ProgrammingError: ERROR:  syntax error at or near "GROUP" at
character 72

SELECT media.status, count(media.id)
FROM media ORDER BY media.status GROUP BY media.status

Andreas

signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil