query and conversion completed

[build-farm.git] / buildfarm / __init__.py

diff --git a/buildfarm/__init__.py b/buildfarm/__init__.py
index 7c4428e80bd4aa374ce425f68f8a9b3c0d42a615..cf7f92e3aca2b63b7daa1be7cf767bc20858bde8 100644 (file)
--- a/buildfarm/__init__.py
+++ b/buildfarm/__init__.py
@@ -143,6 +143,10 @@ class BuildFarm(object):
         result = self._get_store().find(StormBuild)
         return distinct_builds(result.order_by(Desc(StormBuild.upload_time)))
 
+    def get_summary_builds(self):
+        store = self._get_store()
+        return store.execute("SELECT tree,status FROM build GROUP BY tree,host,compiler having max(age);")
+
     def get_tree_builds(self, tree):
         result = self._get_store().find(StormBuild,
             Cast(StormBuild.tree, "TEXT") == Cast(tree, "TEXT"))