FastAPI и pytest

import sys
import os
 
from typing import Any
from typing import Generator
 
import pytest
from fastapi import FastAPI
from fastapi.testclient import TestClient
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
 
sys.path.append(os.path.dirname(os.path.dirname(os.path.abspath(__file__)))) 
# this is to include backend dir in sys.path so that we can import from db, main.py
import models
from main import get_db
from database import Base
 
 
def start_application():
    app = FastAPI()
    # app.include_router(api_router)
    return app
 
 
SQLALCHEMY_DATABASE_URL = "sqlite:///./test_db.db"
engine = create_engine(
    SQLALCHEMY_DATABASE_URL, connect_args={"check_same_thread": False}
)
# Use connect_args parameter only with sqlite
SessionTesting = sessionmaker(autocommit=False, autoflush=False, bind=engine)
 
 
@pytest.fixture(scope="function")
def app() -> Generator[FastAPI, Any, None]:
    """
    Create a fresh database on each test case.
    """
    Base.metadata.create_all(engine)  # Create the tables.
    _app = start_application()
    yield _app
    Base.metadata.drop_all(engine)
 
 
@pytest.fixture(scope="function")
def db_session(app: FastAPI) -> Generator[SessionTesting, Any, None]:
    connection = engine.connect()
    transaction = connection.begin()
    session = SessionTesting(bind=connection)
    yield session  # use the session in tests.
    session.close()
    transaction.rollback()
    connection.close()
 
 
@pytest.fixture(scope="function")
def client(
    app: FastAPI, db_session: SessionTesting
) -> Generator[TestClient, Any, None]:
    """
    Create a new FastAPI TestClient that uses the `db_session` fixture to override
    the `get_db` dependency that is injected into routes.
    """
 
    def _get_test_db():
        try:
            yield db_session
        finally:
            pass
 
    app.dependency_overrides[get_db] = _get_test_db
    with TestClient(app) as client:
        yield client

import json
 
from fastapi import Depends
from sqlalchemy.orm import Session
 
import sys
sys.path.append("...")
# from models import Service, ServiceVersion, ServiceKey
from conftest import get_db
 
 
def test_get_all(client, db: Session = Depends(get_db)):
    response = client.get('/get_all_services')
    assert response.status_code == 200