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.

Reply via email to