home · contact · privacy
a6e9c97c6bdc05acf654ecda21317df1fbe04e85
[plomtask] / plomtask / conditions.py
1 """Non-doable elements of ProcessStep/Todo chains."""
2 from __future__ import annotations
3 from typing import Any
4 from sqlite3 import Row
5 from plomtask.db import DatabaseConnection, BaseModel
6 from plomtask.versioned_attributes import VersionedAttribute
7 from plomtask.exceptions import HandledException
8
9
10 class Condition(BaseModel[int]):
11     """Non-Process dependency for ProcessSteps and Todos."""
12     table_name = 'conditions'
13     to_save = ['is_active']
14     to_save_versioned = ['title', 'description']
15
16     def __init__(self, id_: int | None, is_active: bool = False) -> None:
17         super().__init__(id_)
18         self.is_active = is_active
19         self.title = VersionedAttribute(self, 'condition_titles', 'UNNAMED')
20         self.description = VersionedAttribute(self, 'condition_descriptions',
21                                               '')
22
23     @classmethod
24     def from_table_row(cls, db_conn: DatabaseConnection,
25                        row: Row | list[Any]) -> Condition:
26         """Build condition from row, including VersionedAttributes."""
27         condition = super().from_table_row(db_conn, row)
28         for name in ('title', 'description'):
29             table_name = f'condition_{name}s'
30             for row_ in db_conn.row_where(table_name, 'parent', row[0]):
31                 getattr(condition, name).history_from_row(row_)
32         return condition
33
34     def remove(self, db_conn: DatabaseConnection) -> None:
35         """Remove from DB, with VersionedAttributes.
36
37         Checks for Todos and Processes that depend on Condition, prohibits
38         deletion if found.
39         """
40         if self.id_ is None:
41             raise HandledException('cannot remove unsaved item')
42         for item in ('process', 'todo'):
43             for attr in ('conditions', 'enables', 'disables'):
44                 table_name = f'{item}_{attr}'
45                 for _ in db_conn.row_where(table_name, 'condition', self.id_):
46                     raise HandledException('cannot remove Condition in use')
47         super().remove(db_conn)
48
49
50 class ConditionsRelations:
51     """Methods for handling relations to Conditions, for Todo and Process."""
52
53     def set_conditions(self, db_conn: DatabaseConnection, ids: list[int],
54                        target: str = 'conditions') -> None:
55         """Set self.[target] to Conditions identified by ids."""
56         target_list = getattr(self, target)
57         while len(target_list) > 0:
58             target_list.pop()
59         for id_ in ids:
60             target_list += [Condition.by_id(db_conn, id_)]
61
62     def set_enables(self, db_conn: DatabaseConnection,
63                     ids: list[int]) -> None:
64         """Set self.enables to Conditions identified by ids."""
65         self.set_conditions(db_conn, ids, 'enables')
66
67     def set_disables(self, db_conn: DatabaseConnection,
68                      ids: list[int]) -> None:
69         """Set self.disables to Conditions identified by ids."""
70         self.set_conditions(db_conn, ids, 'disables')