CI: API deployment should fail when migrations fail

[marcellmueller]

Describe the Bug
The API deployment job in CI silently fails if there is an error with migrations - the migrations roll back and the job appears to pass successfully. We need to handle this as it's inevitable that we will deploy a broken app as the api/frontend is expecting migrations to be in the database that aren't there.