How to get number of affected rows in sqlalchemy?

Question

Hi everybody, I have one question concerning Python and the sqlalchemy module. What is the equivalent for cursor.rowcount in the sqlalchemy Python?

Thank you

Answer 1

Although it isn't really stated in the docs, a ResultProxy object does have a rowcount property as well.

Answer 2

session.query(ClassName).count()

This can be done for any query result, filtered or not.