Revize 2a90f4fd

Re #8472 - Implemented get_certificates method and added an integration test validating it

Added fixtures providing a unique DB connection for each test

tests/integration_tests/services/conftest.py

@@ -68 +68 @@
 @pytest.fixture
 def certificate_service(certificate_repository, cryptography_service):
     return CertificateService(cryptography_service, certificate_repository)
+
+
+# TODO improve this (lots of duplicated code) - some test cases need a DB connection that is not shared with other tests
[e-mail]
+def connection_unique():
+    print("Creating a new unique SQLITE connection to the test DB")
+    test_db_file = "test_unique.sqlite"
+    connection: Connection = sqlite3.connect(test_db_file)
+
+    # yield the created connection
+    yield connection
+
+    # after tests have finished delete the created db file
+    try:
+        print("Deleting the unique test DB")
+        os.unlink(test_db_file)
+    except FileNotFoundError:
+        print(f"Could not delete {test_db_file} file containing the unique test DB")
+        pass
+
+
[e-mail]
+def cursor_unique(connection_unique):
+    cursor = connection_unique.cursor()
+
+    # execute db initialisation script
+    cursor.executescript(SCHEMA_SQL)
+
+    # insert default values
+    cursor.executescript(DEFAULT_VALUES_SQL)
+
+    return cursor
+
+
+# scope defaults to "function" which means that the fixture is run once per test (function)
[e-mail]
+def certificate_repository_unique(connection_unique, cursor_unique):
+    return CertificateRepository(connection_unique, cursor_unique)
+
+
[e-mail]
+def private_key_repository_unique(connection_unique, cursor_unique):
+    return PrivateKeyRepository(connection_unique, cursor_unique)
+
+
[e-mail]
+def cryptography_service_unique():
+    return CryptographyService()
+
+
[e-mail]
+def private_key_service_unique(private_key_repository_unique, cryptography_service_unique):
+    return KeyService(cryptography_service_unique, private_key_repository_unique)
+
+
[e-mail]
+def certificate_service_unique(certificate_repository_unique, cryptography_service_unique):
+    return CertificateService(cryptography_service_unique, certificate_repository_unique)