Failing unit tests on Windows: UpdateCache, temporary files

Summary

======================================================================================================================================================================================================== short test summary info ========================================================================================================================================================================================================= 
FAILED unittests/test_caosdbignore.py::Caosdbignore::test_compile - ModuleNotFoundError: No module named 'gitignore_parser'
FAILED unittests/test_cfood.py::FileCacheTest::test - sqlite3.OperationalError: unable to open database file
FAILED unittests/test_generic_analysis.py::TestGAnalysisNoFile::test_check_referenced_script - PermissionError: [Errno 13] Permission denied: 'C:\\Users\\Joscha\\AppData\\Local\\Temp\\tmpoho3m_pm'
FAILED unittests/test_generic_analysis.py::TestGAnalysisFile::test_check_referenced_script - PermissionError: [Errno 13] Permission denied: 'C:\\Users\\Joscha\\AppData\\Local\\Temp\\tmpjyjyjuc9'
FAILED unittests/test_sss_helper.py::test_send_mail_error - FileNotFoundError: [WinError 2] The system cannot find the file specified
FAILED unittests/test_suppressKnown.py::SupTestBasic::test_msg - sqlite3.OperationalError: unable to open database file
FAILED unittests/test_suppressKnown.py::SupTestAdvanced::test_logger - sqlite3.OperationalError: unable to open database file
FAILED unittests/test_suppressKnown.py::SupTestAdvanced::test_msg - sqlite3.OperationalError: unable to open database file
FAILED unittests/test_table_importer.py::TableImporterTest::test_wrong_datatype - AssertionError: assert dtype('int64') == int
 +  where dtype('int64') = 0    1234\n1    5678\nName: a, dtype: int64.dtype
FAILED unittests/test_table_importer.py::XLSImporterTest::test_wrong_datatype - AssertionError: assert dtype('int64') == int
 +  where dtype('int64') = 0    1234\n1    5678\nName: a, dtype: int64.dtype
FAILED unittests/test_table_importer.py::CSVImporterTest::test_wrong_datatype - AssertionError: assert dtype('int64') == int
 +  where dtype('int64') = 0    1234\n1    5678\nName: a, dtype: int64.dtype
FAILED unittests/test_table_importer.py::TSVImporterTest::test_wrong_datatype - AssertionError: assert dtype('int64') == int
 +  where dtype('int64') = 0    1234\n1    5678\nName: a, dtype: int64.dtype
FAILED unittests/test_table_importer.py::CountQueryNoneConverterTest::test_check_reference_field - PermissionError: [Errno 13] Permission denied: 'C:\\Users\\Joscha\\AppData\\Local\\Temp\\tmpyqn2lmik'
FAILED unittests/test_table_importer.py::CountQuerySingleConverterTest::test_check_reference_field - PermissionError: [Errno 13] Permission denied: 'C:\\Users\\Joscha\\AppData\\Local\\Temp\\tmp_p5opg8b'
FAILED unittests/test_utils.py::ReferencesBaseTest::test_ref - PermissionError: [Errno 13] Permission denied: 'C:\\Users\\Joscha\\AppData\\Local\\Temp\\tmpkv6fleqf'
FAILED unittests/test_utils.py::ReferencesFailTest::test_ref - PermissionError: [Errno 13] Permission denied: 'C:\\Users\\Joscha\\AppData\\Local\\Temp\\tmpw46jj92j'
FAILED unittests/test_utils.py::ReferencesEmptyTest::test_ref - PermissionError: [Errno 13] Permission denied: 'C:\\Users\\Joscha\\AppData\\Local\\Temp\\tmps7at03ul'

Expected Behavior

Should not fail.

Actual Behavior

Fail.

Steps to Reproduce the Problem

1. Run pytest

Specifications

• Version: dev branch
• Platform: Windows 11, Python 3.12.3

Possible fixes

See also caosdb-crawler#100 (closed)