radarscholar-api / app /database /session.py
yzffm's picture
Upload 226 files
9c464c7 verified
Raw History Blame Contribute Delete
1.63 kB
"""Database session management for RadarScholar.
Provides async SQLAlchemy session factory connected to PostgreSQL
via the DATABASE_URL environment variable.
"""
from sqlalchemy import create_engine
from sqlalchemy.engine import make_url
from sqlalchemy.orm import Session, sessionmaker
from app.core.config import settings
def get_engine():
"""Create SQLAlchemy engine from DATABASE_URL."""
if not settings.DATABASE_URL:
raise RuntimeError(
"DATABASE_URL is not configured. "
"Set it in .env or environment variables."
)
url = make_url(settings.DATABASE_URL)
engine_options = {"pool_pre_ping": True}
# SQLite's default pools do not accept PostgreSQL-style pool sizing.
if url.get_backend_name() != "sqlite":
engine_options.update(pool_size=5, max_overflow=10)
return create_engine(settings.DATABASE_URL, **engine_options)
# Lazy engine — only created when DATABASE_URL is available.
_engine = None
_SessionLocal = None
def _init_session():
"""Initialize engine and session factory on first use."""
global _engine, _SessionLocal
if _engine is None:
_engine = get_engine()
_SessionLocal = sessionmaker(
bind=_engine,
autocommit=False,
autoflush=False,
)
def get_db() -> Session:
"""FastAPI dependency: yields a database session per request.
Usage:
@router.get("/example")
def example(db: Session = Depends(get_db)):
...
"""
_init_session()
db = _SessionLocal()
try:
yield db
finally:
db.close()