pg_stud.pg_conn_pool#
This module provides a singleton class for managing PostgreSQL connection pools
Module Contents#
Classes#
Singleton class for managing PostgreSQL connection pools per user. |
API#
- class pg_stud.pg_conn_pool.PoolItem#
- pool: psycopg_pool.ConnectionPool#
None
- last_access: float#
None
- class pg_stud.pg_conn_pool.PgConnPool#
Singleton class for managing PostgreSQL connection pools per user.
- _instance#
None
- _user_pools: Dict[str, pg_stud.pg_conn_pool.PoolItem]#
None
- conninfo#
None
- __new__()#
Get Singleton.
- get_pool(user: ltiapi.models.LTIUser) psycopg_pool.ConnectionPool#
Returns ConnectionPool for given user. Creates one if it does not exist
- close_unused_pools(stale_time=1200)#
Closes pools open longer than stale_time. If not called the pools would never be closed