Get the row count from a query

[Jason Hoppes]

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

[Jason Hoppes]

I believe I finally found a solution:

 select(func.count(User.id_)).where(User.id_ == id)

Thank you for taking the time to look.

[Sergey V.]

An alternative would be

session.query(User).filter(User.id_ == id).count()

[Jason Hoppes]

Thank you Sergey.