I want to generate this SQL:
SELECT
SUBSTR(domain_name, 1, 1) as first_letter,
COUNT(domain_name) as counted
FROM domain
GROUP BY first_letter;
The closest I can get to it is this:
dbSession.query(
sqlalchemy.func.count( model.Domain.domain_name
).label('counted'),
sqlalchemy.func.substr( model.Domain.domain_name, 1, 1
).label('first_letter'),
).group_by(
sqlalchemy.func.substr( model.Domain.domain_name, 1, 1 )
)
I tried using this as a the group by:
sqlalchemy.sql.expression.literal('first_letter')
however postgres doesn't like the group by coming in as a bind param.
is there another way to construct the intended query, or do I have to use 2
substring operations (or a subquery)?
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
