Actual unit/integration tests for the database and helper functions

[jakeledoux]

At the moment there aren't any legitimate tests in place to ensure updates haven't broken things. This was almost forgivable when I was a sole developer, but as other people look to contribute tests would help expedite code reviews and make everyone feel a lot more comfortable.

[jakeledoux]

The groundwork for tests has been laid and patterns.py is partially covered. Now it's just about writing tests for everything else.