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 format(self, val):
if self._bool:
return str(int(bool(val)))
return patts.escape_string(str(val), self._quoted)
def primary_key_value(self, i):
return patts.escape_string(super().primary_key_value(i), quote=True)
def format(self, val):
if self._bool:
return str(int(bool(val)))
return patts.escape_string(str(val), self._quoted)
def primary_key_value(self, i):
return patts.escape_string(super().primary_key_value(i), quote=True)
