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