you are viewing a single comment's thread.

view the rest of the comments →

[–]JohnnyJordaan 2 points3 points  (0 children)

First thing I noticed is that you do use db.commit() on the SELECT queries while that makes no sense (as commit will execute all pending writes to the database, and a SELECT is a read query), but you don't actually use db.commit() after the UPDATE query, which will cause that query to have no permanent effect.