SQLAlchemy - Is is necessary to commit after session.execute?

17 Jan 2017

Execute a SQL expression construct or string statement within the current transaction.

So, the answer is yes, you need to issue a commit after running session.execute().

Here’s a code example along with the output from “echo=True” showing it begins the session but doesn’t end it unless you run session.commit():

from sqlalchemy import create_engine from sqlalchemy.orm import scoped_session, sessionmaker engine = create_engine('mysql://root@localhost/test') db_session = scoped_session(sessionmaker(bind=engine)) db_session.execute(''' INSERT INTO user (first_name, last_name, username, email) VALUES ("blah", "blah", "blah", "blah@blah.com"); ''')