File size: 1,157 Bytes
9f99698
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
from sqlalchemy import create_engine
from sqlalchemy.pool import QueuePool
from sqlmodel import Session, SQLModel
from contextlib import contextmanager

from .config import settings


# Create the database engine
# Uses DATABASE_URL from environment variables (loaded via settings)
# Connection pooling is configured for production use
engine = create_engine(
    settings.get_database_url,  # Loads from NEON_DATABASE_URL or DATABASE_URL
    poolclass=QueuePool,
    pool_size=5,
    pool_pre_ping=True,  # Verify connections before using them
    pool_recycle=300,  # Recycle connections after 5 minutes
    echo=False,  # Set to True for SQL query logging during development
)


@contextmanager
def get_session():
    """
    Context manager for database sessions.
    Ensures proper cleanup of database connections.
    """
    session = Session(engine)
    try:
        yield session
        session.commit()
    except Exception:
        session.rollback()
        raise
    finally:
        session.close()


def get_session_dep():
    """
    FastAPI dependency for database sessions.
    """
    with get_session() as session:
        yield session