Transactions

SQLiter supports transactions using Python's context manager:

with db:
    db.insert(User(name="Alice", age=30, email="[email protected]"))
    db.insert(User(name="Bob", age=35, email="[email protected]"))
    # If an exception occurs, the transaction will be rolled back

Using the context manager will automatically commit the transaction at the end (unless an exception occurs), regardless of the auto_commit setting. If an exception occurs, all changes made within the transaction block are rolled back. The close() method will also be called when the context manager exits, so you do not need to call it manually.