Delete row in Treeview with Psycopg2 and not all records

0

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

    
asked by Jsierra2017 23.11.2018 в 23:36
source

0 answers