1 """Non-doable elements of ProcessStep/Todo chains."""
2 from __future__ import annotations
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
10 class Condition(BaseModel[int]):
11 """Non-Process dependency for ProcessSteps and Todos."""
12 table_name = 'conditions'
13 to_save = ['is_active']
15 def __init__(self, id_: int | None, is_active: bool = False) -> None:
17 self.is_active = is_active
18 self.title = VersionedAttribute(self, 'condition_titles', 'UNNAMED')
19 self.description = VersionedAttribute(self, 'condition_descriptions',
23 def from_table_row(cls, db_conn: DatabaseConnection,
24 row: Row | list[Any]) -> Condition:
25 """Build condition from row, including VersionedAttributes."""
26 condition = super().from_table_row(db_conn, row)
27 for name in ('title', 'description'):
28 table_name = f'condition_{name}s'
29 for row_ in db_conn.row_where(table_name, 'parent', row[0]):
30 getattr(condition, name).history_from_row(row_)
33 def save(self, db_conn: DatabaseConnection) -> None:
34 """Save self and its VersionedAttributes to DB and cache."""
35 self.save_core(db_conn)
36 self.title.save(db_conn)
37 self.description.save(db_conn)
39 def remove(self, db_conn: DatabaseConnection) -> None:
40 """Remove from DB, with VersionedAttributes.
42 Checks for Todos and Processes that depend on Condition, prohibits
46 raise HandledException('cannot remove unsaved item')
47 for item in ('process', 'todo'):
48 for attr in ('conditions', 'enables', 'disables'):
49 table_name = f'{item}_{attr}'
50 for _ in db_conn.row_where(table_name, 'condition', self.id_):
51 raise HandledException('cannot remove Condition in use')
52 db_conn.delete_where('condition_titles', 'parent', self.id_)
53 db_conn.delete_where('condition_descriptions', 'parent', self.id_)
54 super().remove(db_conn)
57 class ConditionsRelations:
58 """Methods for handling relations to Conditions, for Todo and Process."""
60 def set_conditions(self, db_conn: DatabaseConnection, ids: list[int],
61 target: str = 'conditions') -> None:
62 """Set self.[target] to Conditions identified by ids."""
63 target_list = getattr(self, target)
64 while len(target_list) > 0:
67 target_list += [Condition.by_id(db_conn, id_)]
69 def set_enables(self, db_conn: DatabaseConnection,
70 ids: list[int]) -> None:
71 """Set self.enables to Conditions identified by ids."""
72 self.set_conditions(db_conn, ids, 'enables')
74 def set_disables(self, db_conn: DatabaseConnection,
75 ids: list[int]) -> None:
76 """Set self.disables to Conditions identified by ids."""
77 self.set_conditions(db_conn, ids, 'disables')