Mercurial > hg > rlgallery-misc
view py/cleandb.py @ 68:67bcca6e3cb1
Prevent crashes if no ttyrec files can be associated with a game.
If the postprocessing step finds no ttyrec files created between a
game's end and the previous game's end, it will no longer index an
empty list and crash.
The condition of finding no ttyrec files is still a bug that requires
investigation.
author | John "Elwin" Edwards |
---|---|
date | Sat, 16 Jan 2016 02:12:50 +0000 |
parents | 25843238434a |
children |
line wrap: on
line source
#!/usr/bin/python3 # cleandb.py: empty the database in an orderly fashion import 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()