3 # Manually (for now: TODO) add an entry in GameStat when a variant is added
5 from dbconnect
import create_connection
9 (Incrementally) Synchronize GameStat table from Variants update
12 conn
= create_connection()
15 cur
.execute("SELECT max(vid) FROM GameStat");
16 vid_max
= cur
.fetchone()[0] or 0
17 cur
.execute("SELECT id FROM Variants WHERE id > ?", (vid_max
,))
20 cur
.execute("INSERT INTO GameStat(vid) VALUES (?)", (variant
[0],))