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