Write better database unit tests

[crasanders]

The current database is unreliable (tables are not always correctly populated). To better identify and fix bugs, we need more, better unit tests and ensure that the db passes them. This will be especially important after we implement new config and data tables.