pyodbc for loop and commit（）

Question

我有一个python脚本，它循环遍历表，并根据特定的条件更新日期字段。在

我是必须在循环中的每次更新后执行提交，还是可以在脚本的末尾循环后只进行一次提交？ 以下部分脚本：

for row in rows:
    WO = row[0]
    PLINE = str(row[2])[5:8].strip()
    PPD = row[10]
    if PLINE == "IP":
        c_IP += 1
        cursor.execute("UPDATE KSKWorkOrder SET PlanProductionDate = ? WHERE WorkOrder = ?",PPDates[c2_IP - 1], WO)
        if c_IP == IP_CAP:
            c_IP = 0
            c2_IP = c2_IP + 1
    if PLINE == "EB":
        c_JB += 1
        cursor.execute("UPDATE KSKWorkOrder SET PlanProductionDate = ? WHERE WorkOrder = ?",PPDates[c2_JB - 1], WO)
        if c_JB == JB_CAP:
            c_JB = 0
            c2_JB = c2_JB + 1
    if PLINE == "DLF":
        c_DLF += 1
        cursor.execute("UPDATE KSKWorkOrder SET PlanProductionDate = ? WHERE WorkOrder = ?",PPDates[c2_DLF - 1], WO)
        if c_DLF == DLF_CAP:
            c_DLF = 0
            c2_DLF = c2_DLF + 1    

Answer 1

退出循环后，您应该能够执行单个commit()，如果这是您的首选。在