API-service should write logs to a file on production

[gulfaraz]

Who is your contact person for this task?

@gulfaraz

User Story

As a devops
I want to access production logs
So that I can investigate errors, db access, and other activity

What needs to be done

Preview Give feedback

1. DB logs - Update ORM config to write to file instead of console
2. NestJS logs - Add logger which writes to a file
3. Investigate if any other loggers need to exist for observability of the app
4. Create follow-up issue: make file accessible outside VM

Acceptance Criteria

Preview Give feedback

1. Update code to implement logging
2. Create a follow-up issue to add sufficient logs for the generated logs to become useful

Additional context

The lack of logs became a problem for this bug. We resorted to using the mailchimp campaign history instead but it was insufficient to identify the actual decision made by the app.

[jannisvisser]

@gulfaraz tag @BlaiseSelvan for new issues. FYI @diderikvw .

[diderikvw]

Refinement: Jannis checks if there is something somewhere already.