How do I determine if a Python sqlite UPDATE worked?

Question

I'm using sqlite3 in Python. I want to know if my UPDATE statement worked or not without doing another database query:

c.execute('update students set gpa=3.5 where stuid=123')

If there isn't a student with stuid 123 then obviously the update fails.

Answer 1

cursor.rowcount will be 1 if the update was successful (affecting 1 row) or 0 if it failed.

Answer 2

For a slightly more complete answer for if you want to handle error and success:

c.execute('update students set gpa=3.5 where stuid=123')

if c.rowcount < 1:
    #error
else:
    #success