I'm workgin on a FastAPI app, using SQLAlchemy for the ORM, writing tests in pytest. I've got the following integration test:

async def test_list_items_success(authed_client, db_session):
    await db_session.execute(insert(Item), [{"name": "test1"}, {"name": "test2"}])
    await db_sessionmit()
    response = await authed_client.get("/items")
    assert response.status_code == 200
    response_body = response.json()
    assert len(response_body["data"]["items"]) == 2

Here, if I don't do the commit in the second line of the test, it doesn't work, which makes sense, because the code in the client is working within a different session. But if I commit, then the code is in the db for the duration of the tests (only because at the begining of the tests, i drop all and recreate). I'm not sure how to resolve this?

I have these fixtures to set up my sessions:

@pytest.fixture(scope="function", autouse=True)
async def session_override(app, db_connection):
    async def get_db_override():
        async with session_manager.session() as session:
            yield session

    app.dependency_overrides[get_db_session] = get_db_override


@pytest.fixture(scope="function")
async def db_session(db_connection):
    async with session_manager.session() as session:
        yield session