tests/conftest.py

import sqlite3
from pathlib import Path
import pytest

@pytest.fixture
def tmp_db(tmp_path: Path) -> str:
    db = tmp_path / "test.db"
    return str(db)