diff py/rlgall.py @ 62:df7acc5653b3

Make the final depth appear in Advanced Rogue 5 tables. Along the way, "SELECT name FROM table WHERE name = ..." was removed from any queries where it had been carelessly placed.
author John "Elwin" Edwards
date Fri, 30 Jan 2015 20:24:47 -0500
parents 4549b3c0cd28
children ad103f9f2e3a
line wrap: on
line diff
--- a/py/rlgall.py	Fri Jan 30 09:25:32 2015 -0500
+++ b/py/rlgall.py	Fri Jan 30 20:24:47 2015 -0500
@@ -54,7 +54,8 @@
 
 # This would be more useful if we had to do translation
 headerbook = {"endt":"End time", "score":"Score", "name":"Name", "xl":"XL", 
-              "fate":"Fate", "rank":"Rank", "game":"Game", "class": "Class"}
+              "fate":"Fate", "rank":"Rank", "game":"Game", "class":"Class",
+              "depth":"Depth"}
 # Queries for the games table
 offselstr = "SELECT offbytes FROM games WHERE gname = %s;"
 newoffstr = "UPDATE games SET offbytes = %s WHERE gname = %s;"
@@ -123,6 +124,8 @@
           clist.append((thing.name, cell))
         elif field == "xl" or field == "score" or field == "rank": # Numerics
           clist.append((str(thing), rcell))
+        elif field == "depth" or field == "maxdepth":
+          clist.append((str(thing), cell))
         elif field == "name":
           clist.append((playerlink(thing), cell))
         elif field == "fate":
@@ -425,7 +428,7 @@
     return dictlist
   def getPlayer(self, player):
     "Gets all player's games from the database."
-    qstr = "SELECT endt, score, name, xl, fate, startt FROM " + self.uname + " WHERE name = %s;"
+    qstr = "SELECT endt, score, xl, fate, startt FROM " + self.uname + " WHERE name = %s;"
     conn = getconn()
     if conn == None:
       return []
@@ -434,12 +437,12 @@
     cur.execute(qstr, [player])
     for record in cur:
       ndict = {"game": self}
+      ndict["name"] = self.uname
       ndict["endt"] = record[0]
       ndict["score"] = record[1]
-      ndict["name"] = record[2]
-      ndict["xl"] = record[3]
-      ndict["fate"] = record[4]
-      ndict["startt"] = record[5]
+      ndict["xl"] = record[2]
+      ndict["fate"] = record[3]
+      ndict["startt"] = record[4]
       entries.append(ndict)
     cur.close()
     conn.close()
@@ -495,14 +498,14 @@
     self.insertq = "INSERT INTO {0} ({1}) VALUES ({2});".format(self.uname, 
                     colspec, valspec)
   # Class variables
-  fields = ["name", "score", "class", "xl", "fate", "endt"]
-  rankfields = ["rank", "score", "name", "class", "xl", "fate", "endt"]
-  pfields = ["score", "class", "xl", "fate", "endt"]
+  fields = ["name", "score", "class", "xl", "fate", "depth", "endt"]
+  rankfields = ["rank", "score", "name", "class", "xl", "fate", "depth", "endt"]
+  pfields = ["score", "class", "xl", "fate", "depth", "endt"]
   def getRecent(self, n=20):
     return []
   def getPlayer(self, player):
     "Gets all player's games from the database."
-    qstr = "SELECT endt, score, name, xl, class, fate FROM " + self.uname + " WHERE name = %s;"
+    qstr = "SELECT endt, score, xl, class, fate, depth FROM " + self.uname + " WHERE name = %s;"
     conn = getconn()
     if conn == None:
       return []
@@ -511,12 +514,13 @@
     cur.execute(qstr, [player])
     for record in cur:
       ndict = {"game": self}
+      ndict["name"] = self.uname
       ndict["endt"] = record[0]
       ndict["score"] = record[1]
-      ndict["name"] = record[2]
-      ndict["xl"] = record[3]
-      ndict["class"] = record[4]
-      ndict["fate"] = record[5]
+      ndict["xl"] = record[2]
+      ndict["class"] = record[3]
+      ndict["fate"] = record[4]
+      ndict["depth"] = record[5]
       entries.append(ndict)
     cur.close()
     conn.close()