engine.py 444 B

123456789101112131415
  1. from typing import Iterator
  2. from sqlmodel import SQLModel, create_engine, Session
  3. from config.settings import settings
  4. sqlite_file_name = "database.db"
  5. sqlite_url = f"sqlite:///" + str(settings.OUTPUT_DIR / sqlite_file_name)
  6. engine = create_engine(sqlite_url, echo=False)
  7. def get_session() -> Iterator[Session]:
  8. with Session(engine) as session:
  9. yield session
  10. def create_db_and_tables():
  11. SQLModel.metadata.create_all(engine)