forked from mtusi2026/mtusi2026lab3
53 lines
1.7 KiB
Python
53 lines
1.7 KiB
Python
"""Пул соединений PostgreSQL."""
|
|
import threading
|
|
|
|
import psycopg
|
|
from psycopg.rows import dict_row
|
|
from psycopg_pool import ConnectionPool, PoolClosed, PoolTimeout
|
|
|
|
from . import config
|
|
|
|
TRANSIENT = (psycopg.OperationalError, PoolTimeout, PoolClosed, psycopg.errors.QueryCanceled,
|
|
psycopg.errors.LockNotAvailable)
|
|
|
|
_pool = None
|
|
_lock = threading.Lock()
|
|
|
|
|
|
def get_pool():
|
|
global _pool
|
|
if _pool is None:
|
|
with _lock:
|
|
if _pool is None:
|
|
if not config.DATABASE_URL:
|
|
raise RuntimeError("DATABASE_URL(_FILE) is not configured")
|
|
options = ("-c statement_timeout=%d -c lock_timeout=3000 "
|
|
"-c idle_in_transaction_session_timeout=10000" % config.DB_STATEMENT_TIMEOUT_MS)
|
|
pool = ConnectionPool(
|
|
config.DATABASE_URL,
|
|
min_size=config.DB_POOL_MIN, max_size=config.DB_POOL_MAX,
|
|
timeout=config.DB_POOL_TIMEOUT, max_lifetime=1800, max_idle=300,
|
|
reconnect_timeout=5,
|
|
check=ConnectionPool.check_connection,
|
|
kwargs={"row_factory": dict_row, "connect_timeout": 3, "options": options,
|
|
"application_name": "messenger-api"},
|
|
open=False)
|
|
pool.open(wait=False)
|
|
_pool = pool
|
|
return _pool
|
|
|
|
|
|
def connection(timeout=None):
|
|
return get_pool().connection(timeout=timeout)
|
|
|
|
|
|
def ping():
|
|
with connection(timeout=1.5) as conn:
|
|
conn.execute("SELECT 1")
|
|
|
|
|
|
def close():
|
|
global _pool
|
|
if _pool is not None:
|
|
_pool.close(timeout=5)
|
|
_pool = None |