Revize 805077f5

Re #8471 - Error correction after review

src/dao/certificate_repository.py

@@ -18 +18 @@
         self.connection = connection
         self.cursor = cursor
 
-    def create(self, certificate: Certificate) -> bool:
+    def create(self, certificate: Certificate):
         """
         Creates a certificate.
         For root certificate (CA) the parent certificate id is modified to the same id (id == parent_id).
@@ -65 +65 @@
                         self.connection.commit()
         except Error as e:
             print(e)
-            return False
+            return None
 
-        return True
+        return last_id
 
-    def read(self, certificate_id: int) -> Certificate:
+    def read(self, certificate_id: int):
         """
         Reads (selects) a certificate.
 
@@ -107 +107 @@
             print(e)
             return None
 
-        return certificate
+        if len(certificate_row) > 0:
+            return certificate
+        else:
+            return None
 
     def update(self, certificate_id: int, certificate: Certificate) -> bool:
         """
@@ -137 +140 @@
                       certificate.pem_data,
                       certificate.private_key_id,
                       certificate.type_id,
-                      certificate.parent_id]
+                      certificate.parent_id,
+                      certificate_id]
             self.cursor.execute(sql, values)
             self.connection.commit()