Mercurial > hg > rlgallery-misc
view py/cleandb.py @ 21:453278a81371
Add tablerecent() so recent.cgi will work as before.
Port the tablerecent() function, which reads the most recent games
directly from the logfile instead of the database. This allows
recent.cgi to show games immediately without waiting for the recorder
to put them in the database.
author | John "Elwin" Edwards <elwin@sdf.org> |
---|---|
date | Mon, 17 Sep 2012 13:41:10 -0700 |
parents | 5ba2123d2c20 |
children | e8f3b7994d88 |
line wrap: on
line source
#!/usr/bin/python # cleandb.py: empty the database in an orderly fashion import rlgalldb as rlgall import psycopg2 dbconn = psycopg2.connect("dbname=rlg") dbcur = dbconn.cursor() dbcur.execute("UPDATE games SET offbytes = %s", [0]) for game in rlgall.gamelist: dbcur.execute("DELETE FROM " + game.uname + ";") dbcur.execute("DELETE FROM players;") dbconn.commit() dbcur.close() dbconn.close() exit()