X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fdb%2Fsync_gamestat.py;fp=server%2Fdb%2Fsync_gamestat.py;h=0800656c11cf94f9352580084c4ca0ce3b2ef991;hp=0000000000000000000000000000000000000000;hb=4a2093139089632727de4f510127ef186cab528e;hpb=3cf543959e84a8a5aa3f39f4f294790e2050b3b6

diff --git a/server/db/sync_gamestat.py b/server/db/sync_gamestat.py
new file mode 100755
index 00000000..0800656c
--- /dev/null
+++ b/server/db/sync_gamestat.py
@@ -0,0 +1,25 @@
+#!/usr/bin/env python
+
+# Manually (for now: TODO) add an entry in GameStat when a variant is added
+
+from dbconnect import create_connection
+
+def sync_gamestat():
+    """
+    (Incrementally) Synchronize GameStat table from Variants update
+    """
+
+    conn = create_connection()
+    cur = conn.cursor()
+
+    cur.execute("SELECT max(vid) FROM GameStat");
+    vid_max = cur.fetchone()[0] or 0
+    cur.execute("SELECT id FROM Variants WHERE id > ?", (vid_max,))
+    rows = cur.fetchall()
+    for variant in rows:
+        cur.execute("INSERT INTO GameStat(vid) VALUES (?)", (variant[0],))
+
+    conn.commit()
+    cur.close()
+
+sync_gamestat()