"""Database configuration and session management""" from sqlalchemy import create_engine, event from sqlalchemy.orm import sessionmaker, Session, declarative_base from contextlib import contextmanager from typing import Generator import logging from app.core.config import settings logger = logging.getLogger(__name__) # Create engine engine = create_engine( settings.DATABASE_URL, echo=settings.DEBUG, pool_pre_ping=True, pool_size=20, max_overflow=40, ) # Session factory SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine) # Base class for ORM models Base = declarative_base() def get_db() -> Generator[Session, None, None]: """Dependency injection for database sessions""" db = SessionLocal() try: yield db finally: db.close() @contextmanager def get_db_context() -> Generator[Session, None, None]: """Context manager for database sessions""" db = SessionLocal() try: yield db finally: db.close() def init_db() -> None: """Initialize database tables""" Base.metadata.create_all(bind=engine) logger.info("Database initialized") # Enable foreign key constraints for SQLite (for development) @event.listens_for(engine, "connect") def set_sqlite_pragma(dbapi_conn, connection_record): if "sqlite" in settings.DATABASE_URL: cursor = dbapi_conn.cursor() cursor.execute("PRAGMA foreign_keys=ON") cursor.close()