I am doing very simple update query on a table. If I check on the database later the change did not happen. If I try the same query in the sql studio it works. Select querys work too.
The query in question is:
cur.execute("UPDATE interfaces SET unpluggable='1' where interfaceid=15558 and nodeid=233")
(I already remove the variables in my debugging)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I am doing very simple update query on a table. If I check on the database later the change did not happen. If I try the same query in the sql studio it works. Select querys work too.
The query in question is:
cur.execute("UPDATE interfaces SET unpluggable='1' where interfaceid=15558 and nodeid=233")
(I already remove the variables in my debugging)
connection.commit() # you must call commit() to persist your data unless you set autocommit to True
Many thanks that did the tricks