Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def edit_records(self, nombre, new_nombre, salario, new_salario):
- id=0
- nombre=new_nombre
- salario=new_salario
- con = None
- try:
- con = psycopg2.connect("host=localhost dbname=videotk_3 user=postgres password=111")
- cur = con.cursor()
- cur.execute("UPDATE empleado SET empleado_id =(SELECT id FROM empleado WHERE nombre=%s AND salario=%s AND id=%s", [nombre, salario,id])
- con.commit()
- except psycopg2.DatabaseError as e:
- if con:
- con.rollback()
- print('Error %s' % e)
- sys.exit(1)
- finally:
- if con:
- con.close()
- print(cur.rowcount)
- if __name__ == '__main__':
- window = root()
- application = Empleado(window)
- window.mainloop()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement