Mercurial > hg > rlgallery-misc
changeset 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 | c05050f78d81 |
| children | 10b79bca2142 |
| files | py/rlgalldb.py web/recent.cgi |
| diffstat | 2 files changed, 26 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/py/rlgalldb.py Mon Sep 17 11:41:11 2012 -0700 +++ b/py/rlgalldb.py Mon Sep 17 13:41:10 2012 -0700 @@ -171,7 +171,6 @@ break entlist.append(self.logtoDict(nextentry)) return - # TODO how does this work with postprocess? def loadnew(self): conn = getconn() if conn == None: @@ -239,6 +238,29 @@ conn.commit() cur.close() return + def tablerecent(self, of): + "Prints the most recent games from the logfile, NOT the database." + newest = [] + try: + scr = open(self.scores) + except IOError: + pass + else: + try: + scr.seek(self.lookback, 2) + except IOError: + scr.seek(0) # The file wasn't that long, start at the beginning + if scr.tell() != 0: + scr.readline() # Throw away the incomplete line + self.getEntryDicts(scr, newest) + newest.reverse() + scr.close() + of.write(secthead.format(self.name)) + if not newest: + of.write("<div>No one has braved this dungeon yet.</div>\n") + else: + printTable(newest, self.fields, of) + return # End Game class definition class RogueGame(Game): @@ -251,6 +273,7 @@ "name": "varchar(20)", "xl": "int", "fate": "text", "ttyrecs": "text ARRAY", "startt": "timestamptz"} self.logdelim = " " + self.lookback = -1500 colspec = "(" valspec = "(" for i, col in enumerate(self.sqltypes.keys()): @@ -379,6 +402,7 @@ "maxdepth": "int", "quest": "int", "hadquest": "bool", "fate": "text", "ttyrecs": "text ARRAY", "startt": "timestamptz"} self.logdelim = " " + self.lookback = -1800 colspec = "(" valspec = "(" for i, col in enumerate(self.sqltypes.keys()):