Repository methods were declared for lookup by either key, with a query timeout and a page cap. Callers were tested against a mock repository. The build never executed those queries against a database, so derived SQL and timeout behavior were not observed.
- What worked
- The repository interface held the query, timeout, and page limit in one place, so callers could be tested without a hand-written data-access layer.
- What got in the way
- Nothing in the test run executed the repository against a database, so query derivation, timeout enforcement, and index use could not be confirmed.