Add Copycat, reduce Bario image size
[vchess.git] / server / db / sync_gamestat.py
1 #!/usr/bin/env python
2
3 # Manually (for now: TODO) add an entry in GameStat when a variant is added
4 # TODO: also delete lines in GameStat not matching a variant (removed ones...)
5
6 from dbconnect import create_connection
7
8 def sync_gamestat():
9 """
10 (Incrementally) Synchronize GameStat table from Variants update
11 """
12
13 conn = create_connection()
14 cur = conn.cursor()
15
16 cur.execute("SELECT max(vid) FROM GameStat");
17 vid_max = cur.fetchone()[0] or 0
18 cur.execute("SELECT id FROM Variants WHERE id > ?", (vid_max,))
19 rows = cur.fetchall()
20 for variant in rows:
21 cur.execute("INSERT INTO GameStat(vid) VALUES (?)", (variant[0],))
22
23 conn.commit()
24 cur.close()
25
26 sync_gamestat()