Add new build time statistics page.

[people/jschlag/pbs.git] / backend / builds.py

diff --git a/backend/builds.py b/backend/builds.py
index 317f5354323e518a81282f9d007daf0ea66561b8..ce2e1ed234ae391fa65207c236c286aa73a36cf0 100644 (file)
--- a/backend/builds.py
+++ b/backend/builds.py
@@ -332,6 +332,41 @@ class Builds(base.Object):
 
                return comments
 
+       def get_build_times_summary(self, name=None, job_type=None):
+               query = "\
+                       SELECT \
+                               builds_times.arch AS arch, \
+                               MAX(duration) AS maximum, \
+                               MIN(duration) AS minimum, \
+                               AVG(duration) AS average, \
+                               SUM(duration) AS sum, \
+                               STDDEV_POP(duration) AS stddev \
+                       FROM builds_times \
+                               LEFT JOIN builds ON builds_times.build_id = builds.id \
+                               LEFT JOIN packages ON builds.pkg_id = packages.id"
+
+               args = []
+               conditions = []
+
+               # Filter for name.
+               if name:
+                       conditions.append("packages.name = %s")
+                       args.append(name)
+
+               # Filter by job types.
+               if type:
+                       conditions.append("builds_times.job_type = %s")
+                       args.append(job_type)
+
+               # Add conditions.
+               if conditions:
+                       query += " WHERE %s" % " AND ".join(conditions)
+
+               # Grouping and sorting.
+               query += " GROUP BY arch ORDER BY arch DESC"
+
+               return self.db.query(query, *args)
+
 
 class Build(base.Object):
        def __init__(self, pakfire, id, data=None):