interpreter/tests/conftest.py

import pytest
from sqlalchemy.pool import StaticPool
from sqlmodel import Session, SQLModel, create_engine

from app.db import init_db, set_engine


@pytest.fixture()
def db_session() -> Session:
    engine = create_engine(
        "sqlite://",
        connect_args={"check_same_thread": False},
        poolclass=StaticPool,
    )
    SQLModel.metadata.drop_all(engine)
    init_db(engine)
    set_engine(engine)
    with Session(engine) as session:
        yield session
    set_engine(None)