Revize 2525db58

Re #8705 - Added the `find_pk` method to PKRepo.

src/dao/private_key_repository.py

@@ -113 +113 @@
 
         return private_key
 
+    def find_pk(self, private_key_pem: str):
+        """
+        Tries to find an existing private key by its PEM.
+        :param private_key_pem: target key PEM
+        :return: corresponding PrivateKey or None if not found
+        """
+
+        try:
+            sql = (f"SELECT * FROM {TAB_PRIVATE_KEYS} "
+                   f"WHERE {COL_PK} = ?")
+            values = (private_key_pem, )
+            self.cursor.execute(sql, values)
+            private_key_row = self.cursor.fetchone()
+
+            if private_key_row is None:
+                return None
+
+            private_key: PrivateKey = PrivateKey(private_key_row[0],
+                                                 private_key_row[1],
+                                                 private_key_row[2])
+        except IntegrityError:
+            Logger.error(INTEGRITY_ERROR_MSG)
+            raise DatabaseException(INTEGRITY_ERROR_MSG)
+        except ProgrammingError:
+            Logger.error(PROGRAMMING_ERROR_MSG)
+            raise DatabaseException(PROGRAMMING_ERROR_MSG)
+        except OperationalError:
+            Logger.error(OPERATIONAL_ERROR_MSG)
+            raise DatabaseException(OPERATIONAL_ERROR_MSG)
+        except NotSupportedError:
+            Logger.error(NOT_SUPPORTED_ERROR_MSG)
+            raise DatabaseException(NOT_SUPPORTED_ERROR_MSG)
+        except DatabaseError:
+            Logger.error(DATABASE_ERROR_MSG)
+            raise DatabaseException(DATABASE_ERROR_MSG)
+        except Error:
+            Logger.error(ERROR_MSG)
+            raise DatabaseException(ERROR_MSG)
+
+        return private_key
+
     def read_all(self):
         """
         Reads (selects) all private keys.