Files
mtusi2026lab2/app/core/db.py

58 lines
1.7 KiB
Python

from collections.abc import Iterator
from sqlalchemy import URL, create_engine, text
from sqlalchemy.exc import SQLAlchemyError
from sqlalchemy.orm import Session, sessionmaker
from core.config import settings
from core.logger import logger
def build_url() -> URL:
return URL.create(
drivername="postgresql+psycopg",
username=settings.db.user,
password=settings.db.read_password(),
host=settings.db.host,
port=settings.db.port,
database=settings.db.name,
)
engine = create_engine(
build_url(),
pool_size=settings.db.pool_size,
max_overflow=settings.db.max_overflow,
pool_timeout=settings.db.pool_timeout,
# Проверять соединение перед выдачей из пула (нужно после рестарта PostgreSQL).
pool_pre_ping=True,
connect_args={
"connect_timeout": settings.db.connect_timeout,
"options": f"-c statement_timeout={settings.db.statement_timeout_ms}",
},
echo=settings.db.echo,
)
SessionLocal = sessionmaker(bind=engine, expire_on_commit=False)
def get_db() -> Iterator[Session]:
"""Одна ORM-сессия на HTTP-запрос."""
with SessionLocal() as session:
yield session
def check_database() -> bool:
try:
with engine.connect() as connection:
connection.execute(text("SELECT 1"))
return True
except SQLAlchemyError as exc:
# Только тип ошибки: в тексте может оказаться адрес БД.
logger.warning(f"PostgreSQL недоступен: {type(exc).__name__}")
return False
def log_database_target():
logger.info(f"База данных: {engine.url.render_as_string(hide_password=True)}")