Revize f3125948

Re #8472 - Made small fixes to the CertificateRepository

src/dao/certificate_repository.py

@@ -50 +50 @@
 
             last_id: int = self.cursor.lastrowid
 
-            if certificate.usages[ROOT_CA_ID - 1]:
+            # TODO assure that this is correct
+            if certificate.type_id == ROOT_CA_ID:
                 certificate.parent_id = last_id
                 return self.update(last_id, certificate)
             else:
@@ -202 +203 @@
             self.cursor.execute(sql, values)
             self.connection.commit()
 
-            for usage_id, usage_value in certificate.usages:
+            # iterate over usage pairs
+            for usage_id, usage_value in certificate.usages.items():
                 if usage_value:
                     sql = (f"INSERT INTO {TAB_CERTIFICATE_USAGES} "
                            f"({COL_CERTIFICATE_ID},"