Adding new utility function for finding a context ID

, according to the new database schema.

Reviewed-By: jasplin

1 files changed, 12 insertions, 0 deletions

diff --git a/scripts/misc.py b/scripts/misc.py
index 5d01974..3fed597 100644
--- a/scripts/misc.py
+++ b/scripts/misc.py
@@ -55,6 +55,18 @@ def metricIdToLowerIsBetter(metricId):
 
     return lib;
 
+def getContext(host, platform, branch, sha1):
+    result = execQuery("SELECT id FROM context"
+                " WHERE hostId = %d"
+                " AND platformId = %d"
+                " AND branchId = %d"
+                " AND sha1Id = %d"
+                "LIMIT 1;"
+                % (host, platform, branch, sha1))
+    if len(result):
+        return result[0][0]
+    return -1
+
 # Returns the test case, test function, and data tag components of
 # a benchmark of the form <tc>:<tf>(<dt>). The test case and test function
 # components may not contain whitespace, or a ':', '(', or ')' character.