Use pytest fixtures to build a cache database

Instead of having .sqlite files in tests/data/cache, we can just use in-memory SQLite databases and create them as needed. This avoids having to rebuild the databases by hand each time we make a change.