Should probably be skipped for BerkeleyDatabase, but should have a test for Files(), e.g.:
<details>
<summary>
</summary>
#ifdef USE_SQLITE
BOOST_AUTO_TEST_CASE(sqlite_db_files)
{
DatabaseOptions options;
DatabaseStatus status;
bilingual_str error;
std::unique_ptr<SQLiteDatabase> sqldb = MakeSQLiteDatabase(m_path_root / "sqlite", options, status, error);
auto sqlite_internal_filename(sqlite3_db_filename(sqldb->m_db, "main"));
BOOST_CHECK(sqlite_internal_filename != nullptr);
std::vector<fs::path> sql_paths;
sql_paths.push_back(fs::PathFromString(sqlite3_filename_database(sqlite_internal_filename)));
sql_paths.push_back(fs::PathFromString(sqlite3_filename_journal(sqlite_internal_filename)));
BOOST_TEST(sql_paths == sqldb->Files(), boost::test_tools::per_element());
}
#endif
</details>
Edit: This test is actually failing on macOS, where sqlite's filepath differs from this, I haven't yet figured out if my test is wrong.
wallet/test/db_tests.cpp:163: error: in "db_tests/sqlite_db_files": check sql_paths == sqldb->Files() has failed
- mismatch at position 0: ["/private/var/folders/qn/7t0vq3ts721cmgt0tgrtgzl80000gn/T/test_common bitcoin/db_tests/sqlite_db_files/4401d34f82818d7bcb73/sqlite/wallet.dat" == "/var/folders/qn/7t0vq3ts721cmgt0tgrtgzl80000gn/T/test_common bitcoin/db_tests/sqlite_db_files/4401d34f82818d7bcb73/sqlite/wallet.dat"] is false
- mismatch at position 1: ["/private/var/folders/qn/7t0vq3ts721cmgt0tgrtgzl80000gn/T/test_common bitcoin/db_tests/sqlite_db_files/4401d34f82818d7bcb73/sqlite/wallet.dat-journal" == "/var/folders/qn/7t0vq3ts721cmgt0tgrtgzl80000gn/T/test_common bitcoin/db_tests/sqlite_db_files/4401d34f82818d7bcb73/sqlite/wallet.dat-journal"] is false