Add integration test suite

[Lionfish7777]

We built the logic correctly. We want to prove it with tests that hit a real database, not mocks. Build out integration test coverage for the core API routes and business logic.