Good afternoon I'm trying to delete a row, in Treeview (Tkinter) in Postgresql database (Psycopg2). But I deleted all the records and I can not get it to apply for a single row, I have tried with% or% s, among others. I would appreciate the collaboration, thanks.
def delete_empleado(self): self.message['text'] = '' try: ( self.tree.item(self.tree.selection())) # ['texto'][] except IndexError as e: self.message['text'] = 'Please select a Record' return self.message['text'] = '' self.num = self.tree.item(self.tree.selection())['values'] #query =("""DELETE FROM empleado WHERE (numdocEmp = %(numdoEmp)s or %(numdocEmp)s is null)""") query =("DELETE FROM empleado WHERE id_emp= id_emp " ) self.run_query(query,(self.num, )) self.message['text'] = 'Record {} deleted Successfully'.format(self.nombre1Emp) self.get_empleados()
this is the console output
{'text': '1', 'image': '', 'values': [2222, 'sfdsf', 'asfa', 'safsa', 'sasfaf'], 'open': 0, 'tags': ''}But when I execute the query, I get this error: return self.tk.call (self._w, 'cget', '-' + key) TypeError: can only concatenate str (not "int") to str