SQLAlchemy get added object's id without committing session

python, sqlalchemy

Solution

Simple answer: call `session.flush()`.

Problem

I need ID of an object which I've just added using `session.add()`. I need the auto-increment ID of this object before `committing` session. If I called the object instance.id, I get `None`. Is there a way to get ID of a object without committing?

Original source