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 _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_()
