Python mysql doesn't see data change in database

Question

i need some help with python an mysql.

I have the following code, which is executing in infinite loop:

db = MySQLdb.connect("127.0.0.1","user","password","dbname" )
while True:
    cursor = db.cursor()
    cursor.execute("SELECT * FROM requests WHERE status <> 'Finished'")
    all_pending_requests = cursor.fetchall()
    cursor.close()

And that works fine the first time i run it. But when i go to a tool like mysql workbench or i type it myself in in terminal, i update some rows and set their status to something that is not "Finished". So by doing that the next time the loop executes i should get those rows as a result but i get nothing. Do you guys now why this is happening maybe?

Thanks for help.

Does MySQL need to be committed?

kylieCatt
– kylieCatt

2014-11-26 18:14:41 +00:00
Commented Nov 26, 2014 at 18:14 — kylieCatt
– kylieCatt, Commented Nov 26, 2014 at 18:14

sid1408 · Accepted Answer · 2014-11-27 07:47:43Z

1

I am not certain but would assume that you are using InnoDB storage engine in MySQL and MySQLdb version >=1.2.0. You need to commit before the changes are being reflected. As of version 1.2.0, MySQLdb disables auto-commit by default. Confirmation of the same is here. Try adding db.commit() as the last line in the loop.

answered Nov 27, 2014 at 7:47

sid1408

4243 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Python mysql doesn't see data change in database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related