Comment by kapperchino

Just mock the repository which calls the db, and to test the queries themselves, use the real db as a docker container, or integration test with an existing db