Update test files to support Python 3.12

SafeConfigParser is a deprecated API since 3.2 and removed in Python 3.12
https://docs.python.org/3/whatsnew/3.11.html#standard-library

pkg:pypi/limits@1.6 uses an outdated versioneer version that does not support this updated API https://github.com/python-versioneer/python-versioneer therefore some tests fail like `test_cli_with_insecure_option_testpkh` - this is more or less based on https://github.com/inveniosoftware/requirements-builder/blob/ec2e84b974290aaefa71b5ce19d0c343d29efffa/setup.py and support Python 2.7 build.

I suggest that we eventually update this test and drop support for Python 2.7 after making a release that will be the last to support Python 2.7.