IBM i MCP Server

from typing import Generator from sqlalchemy.engine import Engine, create_engine from sqlalchemy.orm import Session, sessionmaker from db.url import get_db_url # Create SQLAlchemy Engine using a database URL db_url: str = get_db_url() db_engine: Engine = create_engine(db_url, pool_pre_ping=True) # Create a SessionLocal class SessionLocal: sessionmaker[Session] = sessionmaker(autocommit=False, autoflush=False, bind=db_engine) def get_db() -> Generator[Session, None, None]: """ Dependency to get a database session. Yields: Session: An SQLAlchemy database session. """ db: Session = SessionLocal() try: yield db finally: db.close()