Manage SQLAlchemy sessions.
| 30 | |
| 31 | |
| 32 | class SessionManager: |
| 33 | """Manage SQLAlchemy sessions.""" |
| 34 | |
| 35 | def __init__(self, engine_callback=None): |
| 36 | self._engines = {} |
| 37 | self._sessions = {} |
| 38 | self.forked = False |
| 39 | self.prepared = False |
| 40 | self.engine_callback = engine_callback |
| 41 | if register_after_fork is not None: |
| 42 | register_after_fork(self, _after_fork_cleanup_session) |
| 43 | |
| 44 | def _after_fork(self): |
| 45 | self.forked = True |
| 46 | |
| 47 | def get_engine(self, dburi, **kwargs): |
| 48 | if self.forked: |
| 49 | try: |
| 50 | return self._engines[dburi] |
| 51 | except KeyError: |
| 52 | engine = create_engine(dburi, **kwargs) |
| 53 | if self.engine_callback is not None: |
| 54 | self.engine_callback(engine) |
| 55 | self._engines[dburi] = engine |
| 56 | return engine |
| 57 | else: |
| 58 | unsupported_nullpool_kwargs = {'max_overflow', 'echo_pool'} |
| 59 | kwargs = { |
| 60 | k: v for k, v in kwargs.items() |
| 61 | if not k.startswith('pool') and k not in unsupported_nullpool_kwargs |
| 62 | } |
| 63 | engine = create_engine(dburi, poolclass=NullPool, **kwargs) |
| 64 | if self.engine_callback is not None: |
| 65 | self.engine_callback(engine) |
| 66 | return engine |
| 67 | |
| 68 | def create_session(self, dburi, short_lived_sessions=False, **kwargs): |
| 69 | engine = self.get_engine(dburi, **kwargs) |
| 70 | if self.forked: |
| 71 | if short_lived_sessions or dburi not in self._sessions: |
| 72 | self._sessions[dburi] = sessionmaker(bind=engine) |
| 73 | return engine, self._sessions[dburi] |
| 74 | return engine, sessionmaker(bind=engine) |
| 75 | |
| 76 | def invalidate(self, dburi): |
| 77 | """Dispose cached engine/session state for a database URI.""" |
| 78 | self._sessions.pop(dburi, None) |
| 79 | engine = self._engines.pop(dburi, None) |
| 80 | if engine is not None: |
| 81 | engine.dispose() |
| 82 | |
| 83 | def prepare_models(self, engine): |
| 84 | if not self.prepared: |
| 85 | # SQLAlchemy will check if the items exist before trying to |
| 86 | # create them, which is a race condition. If it raises an error |
| 87 | # in one iteration, the next may pass all the existence checks |
| 88 | # and the call will succeed. |
| 89 | retries = 0 |
no outgoing calls