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

src/services/certificate_service.py

@@ -52 +52 @@
         certificate = Certificate(-1, common_name, not_before_formatted, not_after_formatted, cert_pem,
                                   private_key_id, cert_type, parent_id, usages)
 
-        print(f"CW: {parent_id} {certificate.parent_id}")
         return certificate
 
     # TODO config parameter present in class diagram but not here (unused)
@@ -111 +110 @@
                                                         issuer_key_pass=issuer_key.password, extensions=extensions,
                                                         days=days)
 
-        print(f"test cert {issuer_cert.certificate_id}")
         # wrap the generated certificate using Certificate class
         certificate = self.__create_wrapper(cert_pem, subject_key.private_key_id, subject.common_name, usages,
                                             issuer_cert.certificate_id, CERTIFICATE_ID)
 
-        print(f"parent cert {certificate.parent_id}")
-
         created_id = self.certificate_repository.create(certificate)
 
         certificate.certificate_id = created_id
 
-        print(f"parent cert {certificate.parent_id}")
-
         return certificate
 
     def get_certificate(self, unique_id: int) -> Certificate:
         return self.certificate_repository.read(unique_id)
+
+    def get_certificates(self, cert_type=None) -> Certificate:
+        return self.certificate_repository.read_all(cert_type)