Testing FastAPI Services: Unit, Integration, and Contract Tests

The test suite was green. All 47 tests passing, CI clean, PR merged. Two hours later someone flagged that the staging database had 3,000 rows of test order data in the orders table. A test that was su