registry: write some database tests

[shoenig]

Before adding back MySQL support, write unit tests covering database operations. We'll want these in such a way that we can easily re-use the same tests for both Postgres and Mysql, so that we can prove the sets of queries for both are producing identical outputs.