raise NotFoundException(f'Process not found of id: {id_}')
process = Process(id_)
for row in db_conn.exec('SELECT * FROM process_titles '
raise NotFoundException(f'Process not found of id: {id_}')
process = Process(id_)
for row in db_conn.exec('SELECT * FROM process_titles '
process.description.history[row[1]] = row[2]
for row in db_conn.exec('SELECT * FROM process_efforts '
process.description.history[row[1]] = row[2]
for row in db_conn.exec('SELECT * FROM process_efforts '
process.explicit_steps += [ProcessStep.from_table_row(db_conn,
row)]
for row in db_conn.exec('SELECT condition FROM process_conditions '
process.explicit_steps += [ProcessStep.from_table_row(db_conn,
row)]
for row in db_conn.exec('SELECT condition FROM process_conditions '
def used_as_step_by(self, db_conn: DatabaseConnection) -> list[Process]:
"""Return Processes using self for a ProcessStep."""
owner_ids = set()
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_,)):
+ for owner_id in db_conn.exec('SELECT owner FROM process_steps WHERE'
+ ' step_process = ?', (self.id_,)):
owner_ids.add(owner_id[0])
return [self.__class__.by_id(db_conn, id_) for id_ in owner_ids]
owner_ids.add(owner_id[0])
return [self.__class__.by_id(db_conn, id_) for id_ in owner_ids]
assert isinstance(step.id_, int)
del db_conn.cached_process_steps[step.id_]
self.explicit_steps = []
assert isinstance(step.id_, int)
del db_conn.cached_process_steps[step.id_]
self.explicit_steps = []
db_conn.exec('INSERT INTO process_undoes VALUES (?,?)',
(self.id_, condition.id_))
assert isinstance(self.id_, int)
db_conn.exec('INSERT INTO process_undoes VALUES (?,?)',
(self.id_, condition.id_))
assert isinstance(self.id_, int)