A readable way how to work with Flask-SQLAlchemy

gistfile1.py

class Transaction(object):

    def __init__(self, db):
        self.db = db

    def __enter__(self):
        return self.db.session

    def __exit__(self, type, value, traceback):
        if not value:
            self.db.session.commit()

# ...now we can do this:

with Transaction(db) as session:
    admin = User('admin', '[email protected]')
    session.add(admin) # session is available for adding etc.
    # automatic commit performed when exiting 'with' section

with Transaction(db):
    admin.email = '[email protected]'
    # automatic commit performed when exiting 'with' section


# Apparently, this is reinventing the wheel, you can do almost the same with pure SQLAlchemy,
# see http://docs.sqlalchemy.org/en/latest/orm/session.html#autocommit-mode, following should
# work (not tested):

with db.session.begin():
    admin = User('admin')
    db.session.add(admin)

Sorry for the late reply. It still works fine and greatly improved readability =D