File size: 1,630 Bytes
9c464c7
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
"""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()