1 files changed, 34 insertions, 0 deletions
diff --git a/scripts/getnamemappings.py b/scripts/getnamemappings.py
new file mode 100644
index 0000000..2768449
--- /dev/null
+++ b/scripts/getnamemappings.py
@@ -0,0 +1,34 @@
+import sys, json
+from dbaccess import execQuery
+from misc import printJSONHeader
+
+
+class GetNameMappings:
+
+    def __init__(self):
+        pass
+
+    def execute(self):
+        self.hosts = dict(execQuery("SELECT id, value FROM host", ()))
+        self.platforms = dict(execQuery("SELECT id, value FROM platform", ()))
+        self.branches = dict(execQuery("SELECT id, value FROM branch", ()))
+        self.sha1s = dict(execQuery("SELECT id, value FROM sha1", ()))
+        self.benchmarks = dict(execQuery("SELECT id, value FROM benchmark", ()))
+        self.metrics = dict(execQuery("SELECT id, value FROM metric", ()))
+        self.writeOutput()
+
+    def writeOutputAsJSON(self):
+        printJSONHeader()
+        json.dump({
+                'hosts': self.hosts,
+                'platforms': self.platforms,
+                'branches': self.branches,
+                'sha1s': self.sha1s,
+                'benchmarks': self.benchmarks,
+                'metrics': self.metrics
+                }, sys.stdout)
+
+
+class GetNameMappingsAsJSON(GetNameMappings):
+    def writeOutput(self):
+        self.writeOutputAsJSON()