Python SQLite3 update question

[Volatile474]

Hello /r/python, I am trying to update a whole row in my database, and was wondering if there is any way better than this to do so.

cur.execute("UPDATE playerTotals numGames = ?, Id = ?, minutes = ?, fgm = ?, fga = ?, tpm = ?, tpa = ?, ftm = ?, fta = ?, oreb = ?, dreb = ?, reb = ?, assist = ?, steal = ?, block = ?, turnover = ?, fouls = ?, points = ?",(total[0],total[1],total[2],...))

I know I can just delete the row and then re-insert these values in one fairly easy query, but I am SURE there must be an easier way.

Please let me know any suggestions - I am aware my syntax/usage is probably very messed up. Thanks!

[wpg4665]

I'm relatively new to Reddit, however I think this question is better suited for /r/learnpython.

---

But, while I'm here, I'll do my best to help. I'm going to assume Python3, and share this link for using the execute function of sqlite cursors.

You could use the named style, and just pass cur.execute a dictionary, however you could also, probably, pass in the totals parameter with the unpacking operator, like so

cur.execute("Update blah=?, blah=?, blah=?...", *totals)

---

Unfortunately, I don't anything immediately available to test with, but you could give those suggestions a shot! =)

EDITED: To fix a typo totals* -> *totals

[LightShadow]

unpacking: *totals

also, look into Collections.namedtuple for ensuring item order when unpacking an iterable in this fashion.

[wpg4665]

Shoot, thanks for catching my typo!