CS50 Lec7 - SqLite SameTime Update Error - Transaction


In a scenario, Bob and David clicked the like button on Instagram at the same time.
they all got the same value before it changed, like 1000.
So, after Bob clicked, and Added the like number, the result was 1001,
but same as David, got the previous value from the data base as 1000, so the result would not be 1002, but 1001.

How to resolve this problem?
We lock this process with transaction, the new command will not execute untill the last one complete (commit the transaction).

Transaction

db.execute("BEGIN TRANSACTION");
rows = db.execute("SELECT likes FROM posts WHERE id = ?", id);
like = row[0]["likes"];
db.execute("UPDATE POSTS SET likes = ? WHERE id = ?", likes + 1, id);
db.execute("COMMIT");
#SQL #sqllite #Transaction #cs50






你可能感興趣的文章

Day 01 七天學會基本演算法(一)踏入演算法學習前應該了解的資料結構

Day 01 七天學會基本演算法(一)踏入演算法學習前應該了解的資料結構

MTR04_1111

MTR04_1111

七天打造自己的 Google Map 應用入門 - Day04

七天打造自己的 Google Map 應用入門 - Day04






留言討論