Revize 85003184

Re #8572 - Added a `get_all_descendants_of(id)` (meaning descendants in general) method to the CertificateRepository.

src/dao/certificate_repository.py

@@ -389 +389 @@
 
         return certificates
 
+    def get_all_descendants_of(self, certificate_id: int):
+        """
+        Get a list of all certificates C such that the certificate identified by "certificate_id" belongs to a trust chain
+        between C and its root certificate authority (i.e. is an ancestor of C).
+        :param certificate_id: target certificate ID
+        :return: list of all descendants
+        """
+        def dfs(children_of, this, collection: list):
+            for child in children_of(this.certificate_id):
+                dfs(children_of, child, collection)
+            collection.append(this)
+
+        subtree_root = self.read(certificate_id)
+        if subtree_root is None:
+            return None
+
+        all_certs = []
+        dfs(self.get_all_issued_by, subtree_root, all_certs)
+        return all_certs
+
     def get_next_id(self) -> int:
         """
         Get identifier of the next certificate that will be inserted into the database