I would like to generate the following SQL using the ORM. I am testing for no rows returning:
select count(*) from users where id = 9999 I found session.query(User.id_).count() however that does not have a where clause. How would this be performed in the ORM with a where clause? Thanks, Jason -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/abc35f82-70a3-43e2-b300-2a31eddabfbfn%40googlegroups.com.