X-Git-Url: https://plomlompom.com/repos/todo?a=blobdiff_plain;f=plomtask%2Fprocesses.py;h=03fecb2fee3f570f0595ab785f096fef15cdee85;hb=b3ff25deb388919c9a205ceb1997ff3c42e93bc8;hp=0a7d5b5d67e4f17b33c52800f381295c12bd3b37;hpb=6034476a4d81e28c45e906cdcc36138bc28ccd55;p=plomtask

diff --git a/plomtask/processes.py b/plomtask/processes.py
index 0a7d5b5..03fecb2 100644
--- a/plomtask/processes.py
+++ b/plomtask/processes.py
@@ -70,6 +70,14 @@ class Process:
                 process.explicit_steps += [ProcessStep.from_table_row(row)]
         return process
 
+    def used_as_step_by(self, db_conn: DatabaseConnection) -> list[Process]:
+        """Return Processes using self for a ProcessStep."""
+        owner_ids = set()
+        for owner_id in db_conn.exec('SELECT owner_id FROM process_steps WHERE'
+                                     ' step_process_id = ?', (self.id_,)):
+            owner_ids.add(owner_id[0])
+        return [self.__class__.by_id(db_conn, id_) for id_ in owner_ids]
+
     def get_steps(self, db_conn: DatabaseConnection, external_owner:
                   Process | None = None) -> dict[int, dict[str, object]]:
         """Return tree of depended-on explicit and implicit ProcessSteps."""