通过列计算字符串

Question

我对python或编程非常陌生，所以我想获得关于以下问题的帮助--我的表设置如下：https://i.imgur.com/KFPq2DI.png

现在，我尝试计算所有的'✓‘，并将数字设置为列Teilnahme。

teilnahmencounter(ctx):
i=0
#  Connect
connection = sqlite3.connect("kekse.db")
#  cursor
cursor = connection.cursor()

#  Abfrage
sql = "SELECT * FROM kekse ORDER BY ID"
cursor.execute(sql)
connection.commit()
for dsatz in cursor:
    i = 0
    for x in range(2 , 19):
        if str(dsatz[x]) == '✓':
            i += 1
    cursor.execute('UPDATE kekse SET Teilnahme='+str(i)+' WHERE ID=?', dsatz[0]
                   )
    connection.commit()
    #print(dsatz[1], i, "Teilnahmen")

connection.close()

Answer 1

尝试在更新中使用cast，如果更新-

import sqlite3
#  Connect
con = sqlite3.connect("dbname.db")
#  cursor
cur = con.cursor()
for row in cur.execute("select * from testtab"):
    print(row)
 
cur.execute("update testtab set id=21 where id = cast("+str(2)+" as int)")
con.commit()
con.close()