[Tests] APITest.TestAPIManager passes.

The storage engine's Open method was not actually open the
underlying SQLite connection. In addition, there were some
issues with the db name validation regex. There are two
patterns with only very subtle differences. I suspect these
two should be reduced down to one.