Pytest override session dependency

[foarsitter]

When using the fastapi.testclient.TestClient with pytest, the app doesn't use the session fixture resulting in writes to the database.

To solve this problem, pytest needs to tell the app to use the same session as used for testing. This can be done by using dependency_overrides.

@pytest.fixture(autouse=True)
def _app_session(app, session):
    app.dependency_overrides[fastapi_sqla.sqla.default_session_dep] = lambda: session

At least, this is how I solved the problem. Is there a beter approach or should I send a PR to document this?

[arththebird]

Hi @foarsitter! Overriding the dependency shouldn't be necessary since we patch the engine factory used to generate the sessions. Can you try updating your test so that the session fixture is before the app fixture in the test function signature, so that it's loaded before the app by pytest?

[foarsitter]

My app is a session scoped fixture, changing it to function scoped and adding session as dependency raises on

fastapi-sqla/fastapi_sqla/sqla.py

Line 62 in 4fc7c75

with engine.connect() as connection:

with

AttributeError: 'Connection' object has no attribute 'connect'. Did you mean: 'connection'?