def setData(self, index, value, role=Qt.EditRole): if index.isValid() and role == Qt.EditRole: node = index.internalPointer() qval = patts.escape_string(value, quote=True) patts.query("UPDATE TaskType SET displayName={} WHERE id={}".format(qval, node.type_id)) node.set_name(value) return False
def setData(self, index, value, role=Qt.EditRole): if index.isValid() and role == Qt.EditRole: node = index.internalPointer() qval = patts.escape_string(value, quote=True) patts.query( 'UPDATE TaskType SET displayName={} WHERE id={}'.format( qval, node.type_id)) node.set_name(value) return False
def _change_pw(self): d = ChangePasswordDialog(self._pw, self) pw = d.get_new_pw() if not d.canceled: try: pw = patts.escape_string(pw) patts.query("SET PASSWORD=PASSWORD('{}')".format(pw)) except Exception as e: ExceptionDialog(format_exc()).exec_() self._pw = pw patts.cleanup() self._log_in()
def __init__(self, parent=None): super().__init__(parent) query = "SELECT id,parentID,displayName FROM TaskType WHERE state=1 " "ORDER BY parentID,displayName" type_list = patts.query(query) self._root = TaskTypeTreeNode("0", "") load_tree(type_list, self._root)
def __init__(self, parent=None): super().__init__(parent) query = ('SELECT id,parentID,displayName FROM TaskType WHERE state=1 ' 'ORDER BY parentID,displayName') type_list = patts.query(query) self._root = TaskTypeTreeNode('0', '') load_tree(type_list, self._root)
def _run_report(self): if None in (self._query, self._query_format, self._header, self._result_dialog_type): raise NotImplementedError('No query for report') try: query = self._query.format(*self._query_format) results = task_time_sum(patts.query(query)) self._result_dialog_type(self._header, results, self.parent()).exec_() except Exception: ExceptionDialog(format_exc()).exec_()