SQLAlchemy - Is there a way to see what is currently in the session?
There are following properties to check session state:
Session.new- for objects, which will be added to database.Session.dirty- for objects, which will be updated.Session.deleted- for objects, which will be deleted from database.
These three properties can be used to check session state:
if not db.session.new and not db.session.dirty and not db.session.deleted: # do smthHowever it is safe to call session.commit() even if there is no changes in session. If you don't do something special, you don't need to explicitly check session state before commit.
Also there is a private method called Session._is_clean(), which is used to check if there are any changes to be flushed to database. It's implemented like this:
def _is_clean(self): return not self.identity_map.check_modified() and \ not self._deleted and \ not self._new