SQL update command with python not working

Question

I'm having an issue getting my python script to update my sqlite db.

The first part seems to work fine:

conn = sqlite3.connect('/Users/test/Desktop/my-accounts.db')
currentAccount = None

for row in conn.execute('SELECT email FROM accounts WHERE active=0'):
    currentAccount = row[0]
    print "Checking out: ",currentAccount
    break

if currentAccount is None:
    print "No available accounts"

Then this next part I want to take the variable currentAccount and update the row in the db where that value is.

else:
    conn.execute('UPDATE accounts SET active=1 WHERE email=?', [currentAccount,])

conn.close()

I don't get any errors in the console but the db does not update. The email column is a VARCHAR and the active column is an INT.

Thanks.

SOLUTION was to add conn.commit() after execute()

I've tried both as a tuple and a list. Neither one successfully updates the db. — user1630543
– user1630543, Commented Mar 30, 2013 at 8:00
try to add conn.commit() after conn.execute("XXX"). Sometimes sqlite3 doesn't auto commit the execution. — Yarkee
– Yarkee, Commented Mar 30, 2013 at 8:01
All DB-API 2.0 compatible driver disable auto commit by default. — Kien Truong
– Kien Truong, Commented Mar 30, 2013 at 8:19

Yarkee · Accepted Answer · 2013-03-30 08:15:48Z

1

try to add conn.commit() after conn.execute("XXX"). Sometimes sqlite3 doesn't auto commit the execution.

answered Mar 30, 2013 at 8:15

Yarkee

9,4806 gold badges30 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kien Truong Over a year ago

It's not sometime, auto commit is disabled by default

Collectives™ on Stack Overflow

SQL update command with python not working

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related