| """ | |
| PIOE Database Configuration | |
| """ | |
| from sqlalchemy import create_engine | |
| from sqlalchemy.orm import sessionmaker, declarative_base | |
| from .config import get_settings | |
| settings = get_settings() | |
| engine = create_engine( | |
| settings.database_url, | |
| connect_args={"check_same_thread": False} if "sqlite" in settings.database_url else {} | |
| ) | |
| SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine) | |
| Base = declarative_base() | |
| def get_db(): | |
| """Dependency for FastAPI to get database session.""" | |
| db = SessionLocal() | |
| try: | |
| yield db | |
| finally: | |
| db.close() | |
| def init_db(): | |
| """Initialize database tables.""" | |
| from . import models # noqa: F401 | |
| Base.metadata.create_all(bind=engine) | |