Some test do not work if you move the database file #125
Description
I'm working on this PR #123. I needed to move the SQLite database from the root folder to a new storage folder, and some tests have been broken.
The problem is the tests are using the default location for the SQLite database, which is the file data.db in the root folder and one test is also creating the database if it does not exist.
We have to fix it. We need to use a different location to isolate tests from the default location for the production database. And we should also use an independent database for each test.
We did it for the newer API tests here. We just need to do the same.
If you remove both the config.toml and the data.db file in the root folder, you'll see how the data.db file is created again.