[vchess.git] / server / db / sync_gamestat.py

#!/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()
Commit	Line	Data
4a209313 BA	1	#!/usr/bin/env python
	2
	3	# Manually (for now: TODO) add an entry in GameStat when a variant is added
	4
	5	from dbconnect import create_connection
	6
	7	def sync_gamestat():
	8	"""
	9	(Incrementally) Synchronize GameStat table from Variants update
	10	"""
	11
	12	conn = create_connection()
	13	cur = conn.cursor()
	14
	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,))
	18	rows = cur.fetchall()
	19	for variant in rows:
	20	cur.execute("INSERT INTO GameStat(vid) VALUES (?)", (variant[0],))
	21
	22	conn.commit()
	23	cur.close()
	24
	25	sync_gamestat()