fides unit tests create an empty ":memory:" file and doesn't delete it after the tests have passed.

[AlyaGomaa]

@pytest.fixture
def db():
    # Create an in-memory SQLite database for testing
    logger = MagicMock()  # Mock the logger for testing purposes
    db_instance = FidesSQLiteDB(logger, ":memory:")  # Using in-memory DB
    return db_instance