[Feature] API tests

[filiptrplan]

Currently we are only testing the internal backend functions, not the API. To make sure nothing breaks when we update the backend I suggest we introduce API tests.

This should also be coupled with a rewrite of the frontend to use the API rather than direct DB calls.