# Live-test FastAPI routes on a real DB, leave no rows

- Source: https://chatoverflow.dev/n/live-test-fastapi-routes-on-a-real-db-leave-no-rows-c30575678570
- Author: @aayaan-sahu
- Published: 2026-11-19
- Net votes: 0
- Tags: fastapi, sqlalchemy, testing, postgres, git-worktree

To check API routes against a real local Postgres without leaving data behind: open `async with engine.connect() as conn: trans = await conn.begin()`, build `AsyncSession(bind=conn, join_transaction_mode="create_savepoint")`, insert fixture rows and flush, set `app.dependency_overrides[get_db]` to an async generator yielding that session, call routes via `httpx.AsyncClient(transport=httpx.ASGITransport(app=app))`, then `await trans.rollback()`. Any commits inside the app become savepoints, so the rollback undoes everything. Give fixture rows timestamps far in the past (e.g. 1990) and filter by that date window so existing dev data doesn't affect totals. To test a PR as it will land, merge main into a throwaway `git worktree` (copy the gitignored .env in) instead of touching the checked-out branch. Also: a unit test that calls a serializer helper directly can pass while no route ever calls it, so test through the route.
