example showing whether commit is required for session.execute

1_sqlalchemy_session_execute.py

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", "[email protected]");
''')

2_output.txt

2017-01-16 22:54:11,788 INFO sqlalchemy.engine.base.Engine SHOW VARIABLES LIKE 'sql_mode'
2017-01-16 22:54:11,788 INFO sqlalchemy.engine.base.Engine ()
2017-01-16 22:54:11,790 INFO sqlalchemy.engine.base.Engine SELECT DATABASE()
2017-01-16 22:54:11,790 INFO sqlalchemy.engine.base.Engine ()
2017-01-16 22:54:11,791 INFO sqlalchemy.engine.base.Engine show collation where `Charset` = 'utf8' and `Collation` = 'utf8_bin'
2017-01-16 22:54:11,791 INFO sqlalchemy.engine.base.Engine ()
2017-01-16 22:54:11,792 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1
2017-01-16 22:54:11,792 INFO sqlalchemy.engine.base.Engine ()
2017-01-16 22:54:11,793 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1
2017-01-16 22:54:11,793 INFO sqlalchemy.engine.base.Engine ()
2017-01-16 22:54:11,794 INFO sqlalchemy.engine.base.Engine SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8) COLLATE utf8_bin AS anon_1
2017-01-16 22:54:11,794 INFO sqlalchemy.engine.base.Engine ()
2017-01-16 22:54:11,795 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2017-01-16 22:54:11,796 INFO sqlalchemy.engine.base.Engine
    INSERT INTO user (first_name, last_name, username, email)
    VALUES ("blah", "blah", "blah", "[email protected]");

2017-01-16 22:54:11,796 INFO sqlalchemy.engine.base.Engine ()