sqlalchemy使用方法

from?contextlib?import?contextmanager

@contextmanager
def?session_scope():
????"""Provide?a?transactional?scope?around?a?series?of?operations."""
????session?=?Session()
????try:
????????yield?session
????????session.commit()
????except:
????????session.rollback()
????????raise
????finally:
????????session.close()


def?run_my_program():
????with?session_scope()?as?session:
????????ThingOne().go(session)
????????ThingTwo().go(session)