SQLAlchemy Transactions

https://docs.sqlalchemy.org/en/13/core/connections.html

Connection.begin() 返回Transaction对象
使用with语句，自动调用Transaction对象的commit方法，既调用 Transaction.commit()
在commit之前，如果raise错误，则Transaction会发生roll back，既调用Transaction.rollback()

with engine.connect() as connection:
    with connection.begin():
        r1 = connection.execute(table1.select())
        connection.execute(table1.insert(), {"col1": 7, "col2": "this is some data"})