Add a resource utilization page

JIRA: RELENG-12

Signed-off-by: maxbr <maxbr@mi.fu-berlin.de>

2 files changed, 25 insertions, 0 deletions

diff --git a/tools/pharos-dashboard/dashboard/urls.py b/tools/pharos-dashboard/dashboard/urls.py
index cf6340f6..2223e39c 100644
--- a/tools/pharos-dashboard/dashboard/urls.py
+++ b/tools/pharos-dashboard/dashboard/urls.py
@@ -21,6 +21,8 @@ urlpatterns = [
     url(r'^ci_pods/$', CIPodsView.as_view(), name='ci_pods'),
     url(r'^dev_pods/$', DevelopmentPodsView.as_view(), name='dev_pods'),
     url(r'^jenkins_slaves/$', JenkinsSlavesView.as_view(), name='jenkins_slaves'),
+    url(r'^resource/all/utilization$', ResourceUtilizationView.as_view(),
+        name='resource_utilization'),
 
     url(r'^$', DevelopmentPodsView.as_view(), name="index"),
 ]
diff --git a/tools/pharos-dashboard/dashboard/views.py b/tools/pharos-dashboard/dashboard/views.py
index a4c0c4e9..da31802f 100644
--- a/tools/pharos-dashboard/dashboard/views.py
+++ b/tools/pharos-dashboard/dashboard/views.py
@@ -48,3 +48,26 @@ class DevelopmentPodsView(TemplateView):
         context = super(DevelopmentPodsView, self).get_context_data(**kwargs)
         context.update({'title': "Development Pods", 'dev_pods': dev_pods})
         return context
+
+
+class ResourceUtilizationView(TemplateView):
+    template_name = "dashboard/resource_utilization.html"
+
+    def get_context_data(self, **kwargs):
+        resources = Resource.objects.all()
+        pods = []
+        for resource in resources:
+            utilization = {'idle': 0, 'online': 0, 'offline': 0}
+            # query measurement points for the last week
+            statistics = JenkinsStatistic.objects.filter(slave=resource.slave,
+                                                         timestamp__gte=timezone.now() - timedelta(
+                                                             days=7))
+            statistics_cnt = statistics.count()
+            if statistics_cnt != 0:
+                utilization['idle'] = statistics.filter(idle=True).count()
+                utilization['online'] = statistics.filter(online=True).count()
+                utilization['offline'] = statistics.filter(offline=True).count()
+            pods.append((resource, utilization))
+        context = super(ResourceUtilizationView, self).get_context_data(**kwargs)
+        context.update({'title': "Development Pods", 'pods': pods})
+        return context