from o2common.helper import o2logging\r
logger = o2logging.get_logger(__name__)\r
\r
+\r
+engine = create_engine(\r
+ config.get_postgres_uri(),\r
+ isolation_level="REPEATABLE READ",\r
+ pool_size=200, max_overflow=0,\r
+ pool_recycle=3600\r
+)\r
+\r
DEFAULT_SESSION_FACTORY = sessionmaker(\r
- bind=create_engine(\r
- config.get_postgres_uri(),\r
- isolation_level="REPEATABLE READ",\r
- )\r
+ autocommit=False, autoflush=False, bind=engine\r
)\r
\r
\r
class SqlAlchemyUnitOfWork(AbstractUnitOfWork):\r
+\r
def __init__(self, session_factory=DEFAULT_SESSION_FACTORY):\r
self.session_factory = session_factory\r
\r