Spaces:
Sleeping
Sleeping
File size: 1,157 Bytes
a7a252e | 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 |