How to output the rows which are affected using SQLAlchemy in Python

Question

Hi all. Pretty simple question - How do I go about in getting the number of affected rows using SQLAlchemy?

Also, wanted to know what the equivalent for cursor.rowcount is in SQLAlchemy Python.

Using this for a project of mine.

All help appreciated!

Answer 1

Hi, good question. This is actually not stated anywhere in the official documentation but the ResultProxy object actually has a rowcount property built into it natively.

You can make use of the rowcount property to serve your needs.

Hope this helped!