Indicate for which snapshots rankings are available.

An 'R' in front of the SHA-1 indicates that rankings
have been computed (and is available in the database)
for this snapshot.

2 files changed, 16 insertions, 3 deletions

diff --git a/scripts/listcontexts.py b/scripts/listcontexts.py
index 3de1d53..2a513a5 100644
--- a/scripts/listcontexts.py
+++ b/scripts/listcontexts.py
@@ -5,6 +5,13 @@ from dbaccess import execQuery
 from misc import idToText, printJSONHeader
 
 class ListContexts:
+
+    def rankingsExist(self, contextId):
+        rankings = execQuery(
+            "SELECT id FROM ranking WHERE context2Id = %d LIMIT 1;" % contextId)
+        return len(rankings) > 0
+
+
     def execute(self):
 
         # Get all host/platform/branch/sha1 combinations:
@@ -23,7 +30,9 @@ class ListContexts:
         id, host, platform, branch, sha1, timestamp = contexts[0]
 
         curHost, curPlatform, curBranch = host, platform, branch
-        curSnapshots = [(idToText('sha1', sha1), timestamp, id)]
+        curSnapshots = [
+            (idToText('sha1', sha1), timestamp,
+             1 if self.rankingsExist(id) else 0)]
 
         for (id, host, platform, branch, sha1, timestamp) in contexts[1:]:
             if (host, platform, branch) != (curHost, curPlatform, curBranch):
@@ -37,7 +46,9 @@ class ListContexts:
                 curHost, curPlatform, curBranch = host, platform, branch
                 curSnapshots = []
 
-            curSnapshots.append((idToText('sha1', sha1), timestamp, id))
+            curSnapshots.append(
+                (idToText('sha1', sha1), timestamp,
+                 1 if self.rankingsExist(id) else 0))
 
         self.writeOutput()
 
diff --git a/web/getstats/main.js b/web/getstats/main.js
index 302cc9e..3f7ba59 100644
--- a/web/getstats/main.js
+++ b/web/getstats/main.js
@@ -366,7 +366,9 @@ function fetchContexts() {
                                 "background-color:" + ageColor_ +
                                 "; font-family:lucida sans typewriter, " +
                                 "courier new\" value=\"" + sha1 +
-                                "\">" + sha1 + "  (first upload: " +
+                                "\">" +
+                                (snapshot[2] ? "R " : "  ") +
+                                sha1 + "  (first upload: " +
                                 secsToDays(secsAgo) +
                                 " days ago)</option>";
                         }