Simplified the test and the view so the number of things is apparent in
the test failure messages.
Adds the windows path back for the sqlite DB.