英文:
Why doesn't this update query work when I run it through Python?
问题
UPDATE: 大家不用担心，问题已解决。原来你需要在每次操作后使用 connection.commit() 提交你的操作。感谢我的朋友 user56700。
我对编程还很陌生，我使用Python和MySQL创建了一个能够创建、读取、更新和删除表格的程序。为简单起见，更新表格只会添加预定义的元素。以下代码负责这个过程：
mySql_Update_CV_Query = """INSERT INTO valuesTable (CVCode) VALUE (1);"""
# 数据库 = valuesBase
if userRequestUpdate == 1:
cursor
result4 = cursor.execute(mySql_Update_CV_Query)
cursor.close()
print("CVCode 更新成功。")
mySql_Update_Values_Query = """UPDATE valuesTable
SET factoryValue = 3, customValue = 0
WHERE CVCode = 1;"""
elif userRequestUpdate == 2:
cursor
result4 = cursor.execute(mySql_Update_Values_Query)
cursor.close()
print("userValue 更新成功。")
我在MySQL Workbench中运行了完全相同的查询，它们运行得很好，但是当我尝试以这种方式运行它们时，尽管打印出了"成功"的语句，但表格实际上并没有被更新。
英文:
UPDATE: Nevermind folks, I got it working. Turns out you need to commit your actions using connection.commit() each time. Big up my mate user56700.
I'm quite new to coding, I made a program using Python and MySQL that is able to create, read, update and delete tables. For simplicity's sake, updating the table only adds pre-specified elements. The following code is responsible for the process:
mySql_Update_CV_Query = """INSERT INTO valuesTable (CVCode) VALUE (1);"""
#database = valuesBase
if userRequestUpdate == 1:
cursor
result4 = cursor.execute(mySql_Update_CV_Query)
cursor.close()
print("CVCode updated successfully.")
mySql_Update_Values_Query = """UPDATE valuesTable
SET factoryValue = 3, customValue = 0
WHERE CVCode = 1;"""
elif userRequestUpdate == 2:
cursor
result4 = cursor.execute(mySql_Update_Values_Query)
cursor.close()
print("userValue updated successfully.")
I ran the exact same queries in MySQL Workbench and they ran just fine, but when I attempted to run them this way, the table wasn't actually getting updated despite the "successful" statement printing.
答案1
得分: 1
make sure your commit happens before you close the cursor and, of course, don't forget to manage the rollback as well if an error triggers
mySql_Update_CV_Query = """INSERT INTO valuesTable (CVCode) VALUE (1);"""
#database = valuesBase
if userRequestUpdate == 1:
cursor
try:
result4 = cursor.execute(mySql_Update_CV_Query)
cursor.commit() # <--- this
print("CVCode updated successfully.")
except Exception as e:
print(f"Error triggered: {e}")
cursor.rollback() # <--- if something goes wrong
cursor.close()
mySql_Update_Values_Query = """UPDATE valuesTable
SET factoryValue = 3, customValue = 0
WHERE CVCode = 1;"""
elif userRequestUpdate == 2:
cursor
try:
result4 = cursor.execute(mySql_Update_Values_Query)
cursor.commit() # <--- this
print("userValue updated successfully.")
except Exception as e:
print(f"Error triggered: {e}")
cursor.rollback() # <--- if something goes wrong
cursor.close()
英文:
I am glad you made your code work, I'm writing this so other users with your problem can have an example on how to use this:
make sure your commit happens before you close the cursor and, of course, don't forget to manage the rollback as well if an error triggers
mySql_Update_CV_Query = """INSERT INTO valuesTable (CVCode) VALUE (1);"""
#database = valuesBase
if userRequestUpdate == 1:
cursor
try:
result4 = cursor.execute(mySql_Update_CV_Query)
cursor.commit() # <--- this
print("CVCode updated successfully.")
except Exception as e:
print(f"Error triggered: {e}")
cursor.rollback() # <--- if something goes wrong
cursor.close()
mySql_Update_Values_Query = """UPDATE valuesTable
SET factoryValue = 3, customValue = 0
WHERE CVCode = 1;"""
elif userRequestUpdate == 2:
cursor
try:
result4 = cursor.execute(mySql_Update_Values_Query)
cursor.commit() # <--- this
print("userValue updated successfully.")
except Exception as e:
print(f"Error triggered: {e}")
cursor.rollback() # <--- if something goes wrong
cursor.close()
</details>
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论