DB Tests

[kevin-kline]

Description

Before we start our DB refactoring with migrations, we need to set up tests to verify everything works correctly after the refactor.

Describe the solution you'd like

Before refactor, we need tests to make sure we can insert every model type as of now into a mock database with GORM. This ensures that our current system is fully working and after we make migration changes, we can re-run the tests and make sure everything still works. Tests will fire up a blank new DB and will use GORM syntax to insert records into the DB and retrieve them to be sure they were inserted properly.

Has the Feature been Requested Before?

No.

Describe alternatives you've considered

A clear and concise description of any alternative solutions or features you've considered.

Additional context

This belongs to epic: #806 (closed)
UPDATE: epic changed - #979