Revize 6654bf8b

Re #8578 - Edited conftest
- tests from private_key_repository_test use unique database

tests/integration_tests/dao/conftest.py

@@ -17 +17 @@
     yield connection
 
 
[e-mail]
[e-mail](scope="module")
 def cursor(connection):
     cursor = connection.cursor()
 
@@ -29 +29 @@
 
     return cursor
 
[e-mail]
+def connection_unique():
+    print("Creating a new SQLITE connection to the test DB")
+    connection: Connection = sqlite3.connect(':memory:')
+
+    # yield the created connection
+    yield connection
+
+
[e-mail]
+def cursor_unique(connection):
+    cursor = connection.cursor()
+
+    # execute db initialisation script
+    cursor.executescript(SCHEMA_SQL)
+
+    # insert default values
+    cursor.executescript(DEFAULT_VALUES_SQL)
+
+    return cursor
+
 @pytest.fixture
 def certificate_repository(connection, cursor):
     return CertificateRepository(connection, cursor)
 
 @pytest.fixture
-def private_key_repository(connection, cursor):
-    return PrivateKeyRepository(connection, cursor)
+def private_key_repository(connection_unique, cursor_unique):
+    return PrivateKeyRepository(connection_unique, cursor_unique)