Merge lp:~qa-dashboard/qa-dashboard/idle-power into lp:qa-dashboard

[Chris Johnston]

Adds power idle to the dashboard

[lp:~qa-dashboard/qa-dashboard/idle-power]

336. By Chris Johnston on 2013-04-15

[r=Joe Talbott] Move power urls to power/urls.py, change /power/ and /api/power/ links to /power/software/ and /api/power/software/ from Chris Johnston

337. By Chris Johnston on 2013-04-15

[r=Andy Doan] Only run bzr pull, syncdb, migrate, collectstatic if there is a branch update. Also graceful apache from Chris Johnston

338. By Chris Johnston on 2013-04-16

Release version 2013.04.15

339. By Joe Talbott on 2013-04-16

[r=Andy Doan] Fix duplicate metrics due to recent utah log fix. from Joe Talbott

[Andy Doan (doanac)]

A couple of things:

 237 +from .models import (

We stopped using relative imports in lp:utah, might be good to not continue the pattern here.

496 + logging.info("Adding new log: {}".format(log))
logging.info("Adding new log: %s", log)

830 + path = models.CharField(max_length=512)
831 + name = models.CharField(max_length=100)

I'd make those arbitrarily large since postgres doesn't care

847 + command = models.CharField(max_length=4096)

We should probably name this "testcase" so that it stays inline with the YAML and our general terminology

[Andy Doan (doanac)]

872 + def job_bugs(self):
guessing that's a copy/paste thing, but I don't think we have a use for this at the time, so should probably remove it.

1066 === added file 'idle_power/tests.py'
that file is useless, i'd just kill it until there's something useful for it.

1202 + logging.error("{} {}".format(logfile_path, e))
1206 + logging.warn("Unable to parse {}".format(logfile_path))
bad logging form

def process_idle_power_log(....
This function is too large. You could probably break out the logic in the for loops that builds the detail object into its own function.

[lp:~qa-dashboard/qa-dashboard/idle-power]

340. By Chris Johnston on 2013-04-16

[r=Joe Talbott] Fix issue where power url's show up as api/power/software from Chris Johnston

341. By Chris Johnston on 2013-04-16

resolve conflict

[Andy Doan (doanac)]

review: Approve

=== modified file 'common/management/__init__.py'
--- common/management/__init__.py	2013-04-02 19:30:47 +0000
+++ common/management/__init__.py	2013-04-16 20:51:23 +0000
@@ -18,6 +18,7 @@
 import logging
 import re
 import urllib2
+import yaml
 
 from django.core.management.base import BaseCommand
 from optparse import make_option
@@ -113,6 +114,13 @@
                 'MemoryResult',
                 'MemoryUpgrade',
             ]
+        elif arg == 'idlepower' or arg == 'idle_power':
+            klass_list += [
+                'IdlePowerImage',
+                'IdlePowerLog',
+                'IdlePowerMachine',
+                'IdlePowerMetric',
+            ]
         else:
             klass_list.append(arg)
 
@@ -170,6 +178,30 @@
     )
 
 
+def get_kernel(build_url, artifact):
+    """ Try to find a kernel in a utah log artifact. """
+    retval = "unknown"
+
+    if artifact is None:
+        return retval
+
+    log_path = "{}artifact/{}".format(
+        build_url,
+        artifact['relativePath'],
+    )
+
+    data = jenkins_get(log_path, as_json=False)
+    try:
+        data = yaml.load(data)
+    except yaml.YAMLError:
+        logging.warn("failed to parse data: %s", data)
+        raise
+
+    kernel = data['uname'][2]
+
+    return kernel
+
+
 def profile(fn):
     """ Decorator for time profiling function calls.
 

=== modified file 'common/management/commands/clear_items.py'
--- common/management/commands/clear_items.py	2013-03-01 22:09:19 +0000
+++ common/management/commands/clear_items.py	2013-04-16 20:51:23 +0000
@@ -51,6 +51,14 @@
     PowerMetric,
 )
 
+from idle_power.models import (
+    IdlePowerBuild,
+    IdlePowerDetail,
+    IdlePowerImage,
+    IdlePowerLog,
+    IdlePowerMachine,
+)
+
 from memory.models import (
     MemoryBuild,
     MemoryDetail,
@@ -103,6 +111,11 @@
             MemoryDetail,
             MemoryLog,
             MemoryProcess,
+            IdlePowerImage,
+            IdlePowerLog,
+            IdlePowerMachine,
+            IdlePowerBuild,
+            IdlePowerDetail,
         ]
 
         verbosity = int(options.get('verbosity'))

=== modified file 'common/management/commands/list_items.py'
--- common/management/commands/list_items.py	2013-03-01 22:09:19 +0000
+++ common/management/commands/list_items.py	2013-04-16 20:51:23 +0000
@@ -64,6 +64,13 @@
     MemoryUpgrade,
 )
 
+from idle_power.models import (
+    IdlePowerBuild,
+    IdlePowerDetail,
+    IdlePowerImage,
+    IdlePowerLog,
+    IdlePowerMachine,
+)
 from common.management import process_class_list
 
 
@@ -103,6 +110,11 @@
             MemoryResult,
             MemoryUpgrade,
             MemoryProcess,
+            IdlePowerImage,
+            IdlePowerLog,
+            IdlePowerMachine,
+            IdlePowerBuild,
+            IdlePowerDetail,
         ]
 
         verbosity = int(options.get('verbosity'))

=== modified file 'common/static/css/style.css'
--- common/static/css/style.css	2013-04-11 15:40:42 +0000
+++ common/static/css/style.css	2013-04-16 20:51:23 +0000
@@ -400,6 +400,11 @@
     margin-top: 1.2em; /** 18px (desired value) / 15px (computed font-size value) */
 }
 
+h5 {
+    font-size : 1em;
+    margin-bottom : 0.75em;
+}
+
 p {
     font-size: 1em;
     line-height: 1.4;
@@ -415,8 +420,12 @@
     font-weight:bold;
 }
 
-table.basic thead a , table.basic tfoot a {
-    text-decoration:underline;
+table.basic thead a, table.basic tfoot a {
+    text-decoration: none;
+}
+
+table.basic thead a:hover, table.basic tfoot a:hover {
+    text-decoration: underline;
 }
 
 table.basic {
@@ -724,3 +733,32 @@
  width: 100%;
  background-position:center;
 }
+
+.box-padded {
+    border-radius : 4px;
+    background : #efefef;
+    border : 0;
+    margin-bottom : 20px;
+    padding : 6px 5px 6px;
+}
+
+.box-padded h3 {
+    font-size : 1.219em;
+    margin-bottom : 0.615em;
+    margin-left : 5px;
+    margin-top : 5px;
+}
+
+.box-padded li h3 {
+    font-size : 1.219em;
+    margin-bottom : 0.615em;
+    margin : 0;
+}
+
+.box-padded div {
+    border-radius : 4px;
+    background : #fff;
+    overflow : hidden;
+    padding : 8px 8px 2px;
+}
+

=== renamed file 'smoke/utah_parser.py' => 'common/utah_parser.py'
=== modified file 'common/utils.py'
--- common/utils.py	2013-03-21 18:59:36 +0000
+++ common/utils.py	2013-04-16 20:51:23 +0000
@@ -28,6 +28,9 @@
     'power': re.compile(
         ur"^power-(milestone|backfill|raring)-(desktop)-([^-]*)-(.*)"
     ),
+    'idlepower': re.compile(
+        ur"^poweridle-(milestone|backfill|raring)-(desktop)-([^-]*)-(.*)"
+    ),
     'upgrade': re.compile(
         ur".*-upgrade-.*"
     ),

=== added directory 'idle_power'
=== added file 'idle_power/__init__.py'
--- idle_power/__init__.py	1970-01-01 00:00:00 +0000
+++ idle_power/__init__.py	2013-04-16 20:51:23 +0000
@@ -0,0 +1,14 @@
+# QA Dashboard
+# Copyright 2012-2013 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.

=== added file 'idle_power/admin.py'
--- idle_power/admin.py	1970-01-01 00:00:00 +0000
+++ idle_power/admin.py	2013-04-16 20:51:23 +0000
@@ -0,0 +1,77 @@
+# QA Dashboard
+# Copyright 2013 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
+from .models import (
+    IdlePowerImage,
+    IdlePowerMachine,
+    IdlePowerLog,
+    IdlePowerDetail,
+    IdlePowerBuild,
+)
+
+from django.contrib import admin
+
+
+class IdlePowerMachineAdmin(admin.ModelAdmin):
+    list_display = ('name', 'mac_address')
+    search_fields = ['name', 'mac_address']
+
+
+class IdlePowerLogAdmin(admin.ModelAdmin):
+    list_display = ('name', 'path')
+    search_fields = ['name', 'path']
+
+
+class IdlePowerImageAdmin(admin.ModelAdmin):
+    list_display = (
+        'release',
+        'variant',
+        'arch',
+        'build_number',
+        'image_type',
+    )
+    list_filter = [
+        'release',
+        'variant',
+        'arch',
+        'build_number',
+    ]
+    search_fields = [
+        'release',
+        'variant',
+        'arch',
+        'build_number',
+    ]
+
+
+class IdlePowerDetailAdmin(admin.ModelAdmin):
+    list_display = (
+        'image',
+        'testcase',
+    )
+
+
+class IdlePowerBuildAdmin(admin.ModelAdmin):
+    list_display = (
+        'image',
+        'build',
+    )
+
+
+admin.site.register(IdlePowerMachine, IdlePowerMachineAdmin)
+admin.site.register(IdlePowerLog, IdlePowerLogAdmin)
+admin.site.register(IdlePowerImage, IdlePowerImageAdmin)
+admin.site.register(IdlePowerDetail, IdlePowerDetailAdmin)
+admin.site.register(IdlePowerBuild, IdlePowerBuildAdmin)

=== added directory 'idle_power/management'
=== added file 'idle_power/management/__init__.py'
--- idle_power/management/__init__.py	1970-01-01 00:00:00 +0000
+++ idle_power/management/__init__.py	2013-04-16 20:51:23 +0000
@@ -0,0 +1,14 @@
+# QA Dashboard
+# Copyright 2012-2013 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.

=== added directory 'idle_power/management/commands'
=== added file 'idle_power/management/commands/__init__.py'
--- idle_power/management/commands/__init__.py	1970-01-01 00:00:00 +0000
+++ idle_power/management/commands/__init__.py	2013-04-16 20:51:23 +0000
@@ -0,0 +1,14 @@
+# QA Dashboard
+# Copyright 2012-2013 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.

=== added file 'idle_power/management/commands/jenkins_pull_idlepower.py'
--- idle_power/management/commands/jenkins_pull_idlepower.py	1970-01-01 00:00:00 +0000
+++ idle_power/management/commands/jenkins_pull_idlepower.py	2013-04-16 20:51:23 +0000
@@ -0,0 +1,208 @@
+# QA Dashboard
+# Copyright 2013 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License version
+# 3, as published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public
+# License along with this program.  If not, see
+# <http://www.gnu.org/licenses/>.
+
+
+import logging
+import re
+
+from common.management import (
+    JenkinsBaseCommand,
+    get_kernel,
+)
+
+from common.utils import regexes
+
+from performance.management import get_image_build_number
+
+from idle_power.models import (
+    IdlePowerImage,
+    IdlePowerLog,
+    IdlePowerMachine,
+    IdlePowerBuild,
+)
+
+from idle_power.utah_utils import process_idle_power_log
+
+
+def _get_power_logs(artifacts):
+    """ Check for valid power results.
+
+    :returns: a list of power logs.
+
+    """
+    logs = []
+    utah_log_regex = re.compile(ur'^clientlogs\/utah.*.yaml')
+
+    for artifact in artifacts:
+        logging.debug(artifact['relativePath'])
+        path = artifact['relativePath']
+        logging.debug("found %s", path)
+        if utah_log_regex.match(path):
+            logs.append(artifact)
+
+    return logs
+
+
+def _process_utah_logs(
+    logs,
+    image,
+    machine,
+    jenkins_url=None,
+    name=None,
+):
+
+    details = []
+
+    for log in logs:
+        logging.debug("log: %s", log)
+        detail = process_idle_power_log(
+            log,
+            image,
+            machine,
+            jenkins_url=jenkins_url,
+            name=name,
+        )
+
+        if detail:
+            details.append(detail)
+
+    return details
+
+
+class Command(JenkinsBaseCommand):
+    """ The command. """
+
+    job_regex = regexes['idlepower']
+    job_types = ['milestone', 'backfill']
+
+    def extract_data(self, name):
+        m = self.job_regex.match(name)
+
+        if m:
+            self.release = m.group(1)
+            self.variant = m.group(2)
+            self.arch = m.group(3)
+            self.machine_name = m.group(4)
+
+            self.install_data = dict(
+                release=self.release,
+                variant=self.variant,
+                arch=self.arch,
+                machine=self.machine_name,
+            )
+
+    def process_job(self, job):
+        self.machine, new_machine = IdlePowerMachine.objects.get_or_create(
+            name=self.machine_name,
+        )
+
+        if new_machine:
+            logging.debug("Added new machine: %s", self.machine_name)
+
+    def _process_logs(self, build, build_date, install_data, func):
+
+        if not hasattr(func, '__call__'):
+            raise Exception("invalid callable: %s", func)
+
+        logs = _get_power_logs(build['artifacts'])
+        self.image_build_number = get_image_build_number(build)
+        self.build_url = build['url']
+        for log in logs:
+            kernel = get_kernel(build['url'], log)
+            log_path = "{}artifact/{}".format(
+                build['url'],
+                log['relativePath'],
+            )
+            dashboard_data = dict(
+                build_date=build_date,
+                build_number=self.image_build_number,
+                log=log,
+                log_path=log_path,
+                release=install_data['release'],
+                variant=install_data['variant'],
+                arch=install_data['arch'],
+                kernel=kernel,
+            )
+            if 'jenkins_build' in install_data:
+                dashboard_data['jenkins_build'] = install_data['jenkins_build']
+
+            func(build, dashboard_data)
+
+    def add_result(self, build, dashboard_data):
+        build_logs = []
+        for l in dashboard_data['log']:
+            log, new_log = IdlePowerLog.objects.get_or_create(
+                path=dashboard_data['log_path'],
+                name=dashboard_data['log']['relativePath'],
+            )
+
+            if new_log:
+                logging.info("Adding new log: %s", log)
+
+            build_logs.append(log)
+
+        self.image, new_image = IdlePowerImage.objects.get_or_create(
+            release=dashboard_data['release'],
+            variant=dashboard_data['variant'],
+            arch=dashboard_data['arch'],
+            build_number=dashboard_data['build_number'],
+            # fake an md5 since we don't have the data
+            md5="{}{}{}{}".format(
+                self.arch,
+                dashboard_data['release'],
+                self.variant,
+                dashboard_data['build_number'],
+            )
+        )
+
+        if new_image:
+            logging.debug("Added new image: %s", self.image)
+
+        build, new_build = IdlePowerBuild.objects.get_or_create(
+            image=self.image,
+            machine=self.machine,
+            build=dashboard_data['jenkins_build']
+        )
+
+        if len(build_logs) > 0:
+            _process_utah_logs(
+                build_logs,
+                image=self.image,
+                machine=self.machine,
+                jenkins_url=self.build_url,
+            )
+
+    def remove_result(self, build, dashboard_data):
+        """ Remove power data from the database """
+        logging.info("Removing power result")
+
+        try:
+            image = IdlePowerImage.objects.get(
+                arch=self.arch,
+                release=self.release,
+                variant=self.variant,
+                build_number=self.image_build_number,
+                md5="{}{}{}{}".format(
+                    self.arch,
+                    self.release,
+                    self.variant,
+                    self.image_build_number,
+                )
+            )
+
+            image.delete()
+        except IdlePowerImage.DoesNotExist:
+            pass

=== added directory 'idle_power/migrations'
=== added file 'idle_power/migrations/0001_initial.py'
--- idle_power/migrations/0001_initial.py	1970-01-01 00:00:00 +0000
+++ idle_power/migrations/0001_initial.py	2013-04-16 20:51:23 +0000
@@ -0,0 +1,201 @@
+# -*- coding: utf-8 -*-
+import datetime
+from south.db import db
+from south.v2 import SchemaMigration
+from django.db import models
+
+
+class Migration(SchemaMigration):
+
+    def forwards(self, orm):
+        # Adding model 'IdlePowerImage'
+        db.create_table('idle_power_images', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
+            ('updated_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
+            ('internal', self.gf('django.db.models.fields.BooleanField')(default=True)),
+            ('publish', self.gf('django.db.models.fields.BooleanField')(default=True)),
+            ('release', self.gf('django.db.models.fields.CharField')(max_length=200)),
+            ('variant', self.gf('django.db.models.fields.CharField')(max_length=200)),
+            ('arch', self.gf('django.db.models.fields.CharField')(max_length=200)),
+            ('md5', self.gf('django.db.models.fields.CharField')(unique=True, max_length=200)),
+            ('build_number', self.gf('django.db.models.fields.CharField')(max_length=50)),
+            ('image_type', self.gf('django.db.models.fields.CharField')(default=u'daily', max_length=10)),
+        ))
+        db.send_create_signal('idle_power', ['IdlePowerImage'])
+
+        # Adding model 'IdlePowerMachine'
+        db.create_table('idle_power_machines', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
+            ('updated_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
+            ('internal', self.gf('django.db.models.fields.BooleanField')(default=True)),
+            ('publish', self.gf('django.db.models.fields.BooleanField')(default=True)),
+            ('name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=200)),
+            ('mac_address', self.gf('django.db.models.fields.CharField')(max_length=200)),
+        ))
+        db.send_create_signal('idle_power', ['IdlePowerMachine'])
+
+        # Adding model 'IdlePowerLog'
+        db.create_table('idle_power_logs', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
+            ('updated_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
+            ('internal', self.gf('django.db.models.fields.BooleanField')(default=True)),
+            ('publish', self.gf('django.db.models.fields.BooleanField')(default=True)),
+            ('path', self.gf('django.db.models.fields.CharField')(max_length=4096)),
+            ('name', self.gf('django.db.models.fields.CharField')(max_length=4096)),
+        ))
+        db.send_create_signal('idle_power', ['IdlePowerLog'])
+
+        # Adding model 'IdlePowerDetail'
+        db.create_table('idle_power_details', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
+            ('updated_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
+            ('internal', self.gf('django.db.models.fields.BooleanField')(default=True)),
+            ('publish', self.gf('django.db.models.fields.BooleanField')(default=True)),
+            ('image', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['idle_power.IdlePowerImage'], null=True)),
+            ('machine', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['idle_power.IdlePowerMachine'])),
+            ('testcase', self.gf('django.db.models.fields.CharField')(max_length=4096)),
+            ('calculated_energy', self.gf('django.db.models.fields.PositiveIntegerField')()),
+            ('charge_start', self.gf('django.db.models.fields.PositiveIntegerField')()),
+            ('charge_used', self.gf('django.db.models.fields.PositiveIntegerField')()),
+            ('energy_start', self.gf('django.db.models.fields.PositiveIntegerField')()),
+            ('energy_used', self.gf('django.db.models.fields.PositiveIntegerField')()),
+            ('ran_at', self.gf('django.db.models.fields.DateTimeField')()),
+            ('jenkins_url', self.gf('django.db.models.fields.URLField')(max_length=200)),
+        ))
+        db.send_create_signal('idle_power', ['IdlePowerDetail'])
+
+        # Adding model 'IdlePowerBuild'
+        db.create_table('idle_power_builds', (
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
+            ('updated_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
+            ('internal', self.gf('django.db.models.fields.BooleanField')(default=True)),
+            ('publish', self.gf('django.db.models.fields.BooleanField')(default=True)),
+            ('image', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['idle_power.IdlePowerImage'], null=True)),
+            ('machine', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['idle_power.IdlePowerMachine'])),
+            ('build', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['common.JenkinsBuild'])),
+        ))
+        db.send_create_signal('idle_power', ['IdlePowerBuild'])
+
+
+    def backwards(self, orm):
+        # Deleting model 'IdlePowerImage'
+        db.delete_table('idle_power_images')
+
+        # Deleting model 'IdlePowerMachine'
+        db.delete_table('idle_power_machines')
+
+        # Deleting model 'IdlePowerLog'
+        db.delete_table('idle_power_logs')
+
+        # Deleting model 'IdlePowerDetail'
+        db.delete_table('idle_power_details')
+
+        # Deleting model 'IdlePowerBuild'
+        db.delete_table('idle_power_builds')
+
+
+    models = {
+        'common.bug': {
+            'Meta': {'object_name': 'Bug', 'db_table': "'bugs'"},
+            'bug_no': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'status': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        },
+        'common.jenkinsbuild': {
+            'Meta': {'unique_together': "(('job', 'build_number'),)", 'object_name': 'JenkinsBuild', 'db_table': "'jenkins_builds'"},
+            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'build_bugs'", 'symmetrical': 'False', 'to': "orm['common.Bug']"}),
+            'build_number': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'failed': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'job': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['common.JenkinsJob']"}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        },
+        'common.jenkinsjob': {
+            'Meta': {'object_name': 'JenkinsJob', 'db_table': "'jenkins_jobs'"},
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '200'}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
+            'url': ('django.db.models.fields.URLField', [], {'max_length': '200'})
+        },
+        'idle_power.idlepowerbuild': {
+            'Meta': {'object_name': 'IdlePowerBuild', 'db_table': "'idle_power_builds'"},
+            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['common.JenkinsBuild']"}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'image': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['idle_power.IdlePowerImage']", 'null': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'machine': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['idle_power.IdlePowerMachine']"}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        },
+        'idle_power.idlepowerdetail': {
+            'Meta': {'object_name': 'IdlePowerDetail', 'db_table': "'idle_power_details'"},
+            'calculated_energy': ('django.db.models.fields.PositiveIntegerField', [], {}),
+            'charge_start': ('django.db.models.fields.PositiveIntegerField', [], {}),
+            'charge_used': ('django.db.models.fields.PositiveIntegerField', [], {}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'energy_start': ('django.db.models.fields.PositiveIntegerField', [], {}),
+            'energy_used': ('django.db.models.fields.PositiveIntegerField', [], {}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'image': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['idle_power.IdlePowerImage']", 'null': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
+            'machine': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['idle_power.IdlePowerMachine']"}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
+            'testcase': ('django.db.models.fields.CharField', [], {'max_length': '4096'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        },
+        'idle_power.idlepowerimage': {
+            'Meta': {'object_name': 'IdlePowerImage', 'db_table': "'idle_power_images'"},
+            'arch': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
+            'build_number': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'image_type': ('django.db.models.fields.CharField', [], {'default': "u'daily'", 'max_length': '10'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'md5': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '200'}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'release': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
+            'variant': ('django.db.models.fields.CharField', [], {'max_length': '200'})
+        },
+        'idle_power.idlepowerlog': {
+            'Meta': {'object_name': 'IdlePowerLog', 'db_table': "'idle_power_logs'"},
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'name': ('django.db.models.fields.CharField', [], {'max_length': '4096'}),
+            'path': ('django.db.models.fields.CharField', [], {'max_length': '4096'}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        },
+        'idle_power.idlepowermachine': {
+            'Meta': {'object_name': 'IdlePowerMachine', 'db_table': "'idle_power_machines'"},
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'mac_address': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
+            'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '200'}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        }
+    }
+
+    complete_apps = ['idle_power']
\ No newline at end of file

=== added file 'idle_power/migrations/__init__.py'
--- idle_power/migrations/__init__.py	1970-01-01 00:00:00 +0000
+++ idle_power/migrations/__init__.py	2013-04-16 20:51:23 +0000
@@ -0,0 +1,14 @@
+# QA Dashboard
+# Copyright 2012-2013 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.

=== added file 'idle_power/models.py'
--- idle_power/models.py	1970-01-01 00:00:00 +0000
+++ idle_power/models.py	2013-04-16 20:51:23 +0000
@@ -0,0 +1,85 @@
+# QA Dashboard
+# Copyright 2012-2013 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
+from django.db import models
+
+from common.models import (
+    DashboardBaseModel,
+    JenkinsBuild,
+)
+
+from performance.models import (
+    ImageBase,
+    MachineBase,
+)
+
+
+class IdlePowerImage(ImageBase):
+    """ Idle Power Image model. """
+
+    class Meta:
+        db_table = "idle_power_images"
+
+
+class IdlePowerMachine(MachineBase):
+    """ Idle Power Machine model. """
+
+    class Meta:
+        db_table = "idle_power_machines"
+
+
+class IdlePowerLog(DashboardBaseModel):
+    """ Idle Power logs for a build. """
+
+    class Meta:
+        db_table = "idle_power_logs"
+
+    path = models.CharField(max_length=4096)
+    name = models.CharField(max_length=4096)
+
+    def __unicode__(self):
+        return "{}".format(self.name)
+
+
+class IdlePowerDetail(DashboardBaseModel):
+    """ Idle Power raw data. """
+
+    class Meta:
+        db_table = "idle_power_details"
+
+    image = models.ForeignKey(IdlePowerImage, null=True)
+    machine = models.ForeignKey(IdlePowerMachine)
+    testcase = models.CharField(max_length=4096)
+    calculated_energy = models.PositiveIntegerField()
+    charge_start = models.PositiveIntegerField()
+    charge_used = models.PositiveIntegerField()
+    energy_start = models.PositiveIntegerField()
+    energy_used = models.PositiveIntegerField()
+    ran_at = models.DateTimeField("date run")
+    jenkins_url = models.URLField()
+
+    def __unicode__(self):
+        return "{}".format(self.testcase)
+
+
+class IdlePowerBuild(DashboardBaseModel):
+    """ Jenkins Build image. """
+
+    class Meta:
+        db_table = "idle_power_builds"
+
+    image = models.ForeignKey(IdlePowerImage, null=True)
+    machine = models.ForeignKey(IdlePowerMachine)
+    build = models.ForeignKey(JenkinsBuild)

=== added file 'idle_power/tables.py'
--- idle_power/tables.py	1970-01-01 00:00:00 +0000
+++ idle_power/tables.py	2013-04-16 20:51:23 +0000
@@ -0,0 +1,72 @@
+# QA Dashboard
+# Copyright 2012-2013 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
+import django_tables2 as tables
+from django_tables2.utils import Accessor as A
+
+
+class MachineTable(tables.Table):
+    build_number = tables.LinkColumn(
+        'idle_machine_raw_data',
+        accessor='image__build_number',
+        kwargs={
+            'machine_id': A('machine__id'),
+            'arch': A('image__arch'),
+            'build_number': A('image__build_number'),
+        },
+        verbose_name="Build Number",
+    )
+    testcase = tables.Column(verbose_name="Test Case")
+    energy_avg = tables.TemplateColumn(
+        '{{ record.energy_avg|floatformat:2 }}',
+        verbose_name="Average Energy used (mW)",
+        attrs={'td': {'class': 'num'}},
+    )
+    energy_stddev = tables.TemplateColumn(
+        '{{ record.energy_stddev|floatformat:2 }}',
+        verbose_name="Standard Deviation",
+        attrs={'td': {'class': 'num'}},
+    )
+
+    class Meta:
+        attrs = {'class': 'basic'}
+
+
+class DataTable(tables.Table):
+    testcase = tables.Column(verbose_name="Test Case")
+    energy_start = tables.Column(
+        verbose_name="Energy Start (mW)",
+        attrs={'td': {'class': 'num'}},
+    )
+    energy_used = tables.Column(
+        verbose_name="Energy used (mW)",
+        attrs={'td': {'class': 'num'}},
+    )
+    calculated_energy = tables.Column(
+        verbose_name="Calculated Energy (mW)",
+        attrs={'td': {'class': 'num'}},
+    )
+    charge_start = tables.Column(
+        verbose_name="Charge Start (mA)",
+        attrs={'td': {'class': 'num'}},
+    )
+    charge_used = tables.Column(
+        verbose_name="Charge Used (mA)",
+        attrs={'td': {'class': 'num'}},
+    )
+
+    class Meta:
+        attrs = {'class': 'basic'}
+        order_by = ('testcase',)

=== added directory 'idle_power/templates'
=== added directory 'idle_power/templates/idle_power'
=== added file 'idle_power/templates/idle_power/machine_raw_data.html'
--- idle_power/templates/idle_power/machine_raw_data.html	1970-01-01 00:00:00 +0000
+++ idle_power/templates/idle_power/machine_raw_data.html	2013-04-16 20:51:23 +0000
@@ -0,0 +1,37 @@
+{% extends "power/power_layout.html" %}
+{% load dashboard_extras %}
+{% load render_table from django_tables2 %}
+
+{% block page_name %}{{ name }} - {{ arch }} - raw data{% endblock %}
+{% block extra_headers %}
+<style>
+td {
+    font-size: 0.8em;
+}
+th {
+    font-size: 0.9em;
+}
+.box-padded {
+    margin: 20px;
+}
+</style>
+{% endblock extra_headers %}
+
+{% block content %}
+<div class='grid_15'>
+    <h2>{{ name }} raw data</h2>
+    <p>
+    <strong>Build #:</strong> <a href="{{ jenkins_url }}">{{ build_number }}</a><br />
+    <strong>Ran at:</strong> {{ ran_at }}<br />
+    <strong>Arch:</strong> {{ arch }}<br />
+    <strong>Release:</strong> {{ release }}<br />
+    <strong>Variant:</strong> {{ variant }}
+    </p>
+</div>
+<div class='grid_8'>
+{% render_table table %}
+</div>
+<div class='grid_7'>
+    {% include "idle_power/metrics.html" %}
+</div>
+{% endblock %}

=== added file 'idle_power/templates/idle_power/machine_table.html'
--- idle_power/templates/idle_power/machine_table.html	1970-01-01 00:00:00 +0000
+++ idle_power/templates/idle_power/machine_table.html	2013-04-16 20:51:23 +0000
@@ -0,0 +1,30 @@
+{% extends "power/power_layout.html" %}
+{% load dashboard_extras %}
+{% load render_table from django_tables2 %}
+
+{% block page_name %}{{ name }}{% endblock %}
+{% block extra_headers %}
+<style>
+td {
+    font-size: 0.8em;
+}
+th {
+    font-size: 0.9em;
+}
+.box-padded {
+    margin: 20px;
+}
+</style>
+{% endblock extra_headers %}
+
+{% block content %}
+<div class='grid_15'>
+    <h2>{{ name }} Data Overview</h2>
+    <p>
+    <strong>Arch:</strong> {{ arch }}<br />
+    </p>
+</div>
+<div class='grid_8'>
+{% render_table table %}
+</div>
+{% endblock %}

=== added file 'idle_power/templates/idle_power/metrics.html'
--- idle_power/templates/idle_power/metrics.html	1970-01-01 00:00:00 +0000
+++ idle_power/templates/idle_power/metrics.html	2013-04-16 20:51:23 +0000
@@ -0,0 +1,28 @@
+<div class="box box-padded">
+<h3>Metrics Explained</h3>
+<div>
+The metrics in this chart come from the <a href="https://www.kernel.org/doc/Documentation/power/power_supply_class.txt">power supply</a> driver in the kernel.
+
+    <dl>
+        <dt>Energy Start</dt>
+        <dd>The amount of energy in mW the battery contained.</dd>
+        <dt>Energy Used</dt>
+        <dd>This is difference between the "energy_now" measurements at the
+        start and end of the test. It represents the actual energy
+        that was consumed.</dd>
+        <dt>Computed Energy</dt>
+        <dd>We can multiple the "charge used" by an estimate of the
+        voltage:
+        <pre>end_voltage + 0.5 * abs(start_voltage - end_voltage)</pre>
+        to make a sanity check on the "energy used" metric. If this
+        value has a >1% difference, then we mark it so you'll know
+        something is inconsistent.</dd>
+        <dt>Charge Start</dt>
+        <dd>The amount of charge (in mA) reported by the battery at the
+        beginning of the test.</dd>
+        <dt>Charge Used</dt>
+        <dd>The difference of the "charge_now" metric at the start and end
+        the test.</dd>
+    </dl>
+</div>
+</div>

=== added file 'idle_power/urls.py'
--- idle_power/urls.py	1970-01-01 00:00:00 +0000
+++ idle_power/urls.py	2013-04-16 20:51:23 +0000
@@ -0,0 +1,33 @@
+# QA Dashboard
+# Copyright 2012-2013 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
+from django.conf.urls.defaults import (
+    patterns,
+    url,
+)
+
+urlpatterns = patterns(
+    'idle_power.views',
+    url(
+        r'^machine/(?P<machine_id>\d+)/(?P<arch>\w+)/$',
+        'machine_detail',
+        name='idle_machine_detail'
+    ),
+    url(
+        r'^machine/(?P<machine_id>\d+)/(?P<arch>\w+)/(?P<build_number>\d+)/$',
+        'machine_raw_data',
+        name='idle_machine_raw_data'
+    ),
+)

=== added file 'idle_power/utah_utils.py'
--- idle_power/utah_utils.py	1970-01-01 00:00:00 +0000
+++ idle_power/utah_utils.py	2013-04-16 20:51:23 +0000
@@ -0,0 +1,112 @@
+# QA Dashboard
+# Copyright 2012-2013 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
+"""
+UTAH result parsing code.
+"""
+
+import logging
+
+from common.utah_parser import UTAHParser, ParserError
+
+from .models import (
+    IdlePowerDetail,
+)
+
+FLAVOR = 'ubuntu'
+
+
+def process_idle_power_log(
+    logfile,
+    image,
+    machine,
+    jenkins_url=None,
+    name=None
+):
+    """
+    Parse a utah client log for smoke test results.
+    """
+    details = []
+
+    logfile_path = logfile
+    if jenkins_url is not None:
+        logfile_path = "{}/artifact/{}".format(
+            jenkins_url,
+            logfile,
+        )
+
+    if jenkins_url is None:
+        jenkins_url = "http://jenkins.qa.ubuntu.com/"
+
+    parser = UTAHParser()
+
+    try:
+        data = parser.parse(logfile_path)
+    except ParserError as e:
+        if not e.zero_entry:
+            logging.error("%s %s", logfile_path, e)
+            return details
+
+    if data is None:
+        logging.warn("Unable to parse %s", logfile_path)
+        return details
+
+    # Use the name from the logs if there is one, if there isn't one
+    # and one is passed in use that.
+    if 'name' not in data:
+        data['name'] = 'unnamed'
+
+    if name is None or data['name'] != 'unnamed':
+        name = data['name']
+    data['machine'] = machine
+    data['image'] = image
+    data['jenkins_url'] = jenkins_url
+
+    _add_details(details, data)
+
+
+def _add_details(details, data):
+    for command in data['commands']:
+        if command['cmd_type'] != 'testcase_test':
+            continue
+        testcase = command['testcase']
+        start_voltage = command['battery']['start']['voltage_now'] / 1000
+        end_voltage = command['battery']['end']['voltage_now'] / 1000
+        energy_start = command['battery']['start']['energy_now'] / 1000
+        energy_end = command['battery']['end']['energy_now'] / 1000
+        energy_used = energy_start - energy_end
+        charge_start = command['battery']['start']['charge_now'] / 1000
+        charge_end = command['battery']['end']['charge_now'] / 1000
+        charge_used = charge_start - charge_end
+        ran_at = command['start_time']
+        voltage_est = (
+            end_voltage + 0.5 * abs(start_voltage - end_voltage)
+        ) / 1000
+        calculated_energy = charge_used * voltage_est
+        detail, new_detail = IdlePowerDetail.objects.get_or_create(
+            image=data['image'],
+            machine=data['machine'],
+            jenkins_url=data['jenkins_url'],
+            ran_at=ran_at,
+            testcase=testcase,
+            calculated_energy=calculated_energy,
+            charge_start=charge_start,
+            charge_used=charge_used,
+            energy_start=energy_start,
+            energy_used=energy_used,
+        )
+        details.append(detail)
+
+    return details

=== added file 'idle_power/views.py'
--- idle_power/views.py	1970-01-01 00:00:00 +0000
+++ idle_power/views.py	2013-04-16 20:51:23 +0000
@@ -0,0 +1,104 @@
+# QA Dashboard
+# Copyright 2012-2013 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
+from django.views.decorators.http import require_GET
+from django.template import RequestContext
+from django.db.models import Avg, StdDev
+
+from django.shortcuts import (
+    render_to_response,
+    get_object_or_404,
+)
+
+from django_tables2 import RequestConfig
+
+from idle_power.models import (
+    IdlePowerMachine,
+    IdlePowerDetail,
+)
+
+from idle_power.tables import DataTable, MachineTable
+
+
+@require_GET
+def machine_detail(request, machine_id, arch):
+    machine = get_object_or_404(IdlePowerMachine, id=machine_id)
+    qs = IdlePowerDetail.objects.filter(
+        machine__id=machine_id
+    ).values(
+        'image__build_number',
+        'image__arch',
+        'testcase',
+        'machine__id',
+    ).annotate(
+        energy_avg=Avg('energy_used'),
+        energy_stddev=StdDev('energy_used'),
+    ).order_by('-image__build_number')
+    table = MachineTable(qs)
+    RequestConfig(request, paginate={"per_page": 100}).configure(table)
+    data = {
+        'name': machine.name,
+        'arch': arch,
+        'table': table,
+    }
+
+    return render_to_response(
+        'idle_power/machine_table.html',
+        data,
+        RequestContext(request)
+    )
+
+
+@require_GET
+def machine_raw_data(request, machine_id, arch, build_number):
+    machine = get_object_or_404(IdlePowerMachine, id=machine_id)
+
+    qs = IdlePowerDetail.objects.filter(
+        machine__id=machine_id,
+        image__build_number=build_number,
+        image__arch=arch,
+    ).values(
+        'image__build_number',
+        'image__arch',
+        'image__release',
+        'image__variant',
+        'ran_at',
+        'testcase',
+        'energy_start',
+        'energy_used',
+        'calculated_energy',
+        'charge_start',
+        'charge_used',
+        'jenkins_url',
+    )
+    table = DataTable(qs)
+    RequestConfig(request, paginate={"per_page": 100}).configure(table)
+    details = qs[0]
+    data = {
+        'name': machine.name,
+        'id': machine.id,
+        'arch': details['image__arch'],
+        'table': table,
+        'build_number': build_number,
+        'release': details['image__release'],
+        'ran_at': details['ran_at'],
+        'variant': details['image__variant'],
+        'jenkins_url': details['jenkins_url'],
+    }
+    return render_to_response(
+        "idle_power/machine_raw_data.html",
+        data,
+        RequestContext(request)
+    )

=== modified file 'power/templates/power/power_layout.html'
--- power/templates/power/power_layout.html	2013-04-02 21:09:05 +0000
+++ power/templates/power/power_layout.html	2013-04-16 20:51:23 +0000
@@ -1,2 +1,5 @@
 {% extends "layout.html" %}
-{% block sub_nav %}{% endblock %}
+{% block sub_nav_links %}
+<li {% ifequal url.1 'software' %}class="active"{% endifequal %}><a class="sub-nav-item" href="{% url power_arch_overview 'amd64' %}">Software Testing</a></li>
+<li {% ifequal url.1 'idle' %}class="active"{% endifequal %}><a class="sub-nav-item" href="{% url idle_machine_detail 1 'armhf' %}">Idle Testing</a></li>
+{% endblock %}

=== modified file 'qa_dashboard/settings.py'
--- qa_dashboard/settings.py	2013-04-05 00:37:07 +0000
+++ qa_dashboard/settings.py	2013-04-16 20:51:23 +0000
@@ -147,6 +147,7 @@
     'power',
     'smoke',
     'sru',
+    'idle_power',
 )
 
 INSTALLED_APPS = (

=== modified file 'qa_dashboard/urls.py'
--- qa_dashboard/urls.py	2013-04-16 11:57:48 +0000
+++ qa_dashboard/urls.py	2013-04-16 20:51:23 +0000
@@ -28,6 +28,7 @@
     '',
     url(r'^power/software/', include('power.urls')),
     url(r'^api/power/software/', include('power.urls_api')),
+    url(r'^power/idle/', include('idle_power.urls')),
 )
 
 urlpatterns += patterns(

=== added file 'scripts/fakeup_idle_power.py'
--- scripts/fakeup_idle_power.py	1970-01-01 00:00:00 +0000
+++ scripts/fakeup_idle_power.py	2013-04-16 20:51:23 +0000
@@ -0,0 +1,134 @@
+import datetime
+import logging
+import os
+import random
+import time
+import sys
+
+sys.path.append(os.path.join(os.path.dirname(__file__), '..'))
+os.environ['DJANGO_SETTINGS_MODULE'] = 'qa_dashboard.settings'
+
+logging.basicConfig(level=logging.INFO)
+
+from idle_power.models import (
+    IdlePowerDetail,
+    IdlePowerImage,
+    IdlePowerMachine,
+    IdlePowerResult,
+    IdlePowerLog,
+)
+
+
+def add_machines(count=3):
+
+    machines = []
+
+    for i in range(count):
+        machines.append(
+            IdlePowerMachine.objects.create(
+                name='idle-power-test-{}'.format(i),
+            )
+        )
+
+    return machines
+
+
+def add_log():
+    log = IdlePowerLog.objects.create(
+        path='idle-power-test-path',
+        name='idle-power-test-name',
+    )
+    return log
+
+
+def add_images(count=1):
+
+    images = []
+
+    for i in range(count):
+        images.append(
+            IdlePowerImage.objects.create(
+                arch='amd64',
+                variant='desktop',
+                release='raring',
+                build_number='{}'.format(i),
+                md5='fake{}'.format(i),
+            )
+        )
+        images.append(
+            IdlePowerImage.objects.create(
+                arch='i386',
+                variant='desktop',
+                release='raring',
+                build_number='{}'.format(i),
+                md5='fake1{}'.format(i),
+            )
+        )
+
+    return images
+
+
+def add_details(machine, log, image=None, upgrade=None, count=3):
+
+    details = []
+
+    for j in range(count):
+        date = datetime.datetime.now()
+        result = IdlePowerResult.objects.create(
+            image=image,
+            machine=machine,
+            value=0,
+            ran_at=date,
+            name=m,
+            log=log,
+        )
+        for i in range(count):
+            details.append(
+                IdlePowerDetail.objects.create(
+                    image=image,
+                    machine=machine,
+                    command="idle",
+                    voltage_avg=random.uniform(0.1, 1) * 100,
+                    energy_used=random.uniform(0.1, 5) * 100,
+                    energy_start=random.uniform(0.1, 1) * 100,
+                    charge_start=random.uniform(0.1, 1) * 100,
+                    charge_used=random.uniform(1.1, 2) * 100,
+                    ran_at=date,
+                    result=result,
+                )
+                )
+                time.sleep(2)
+
+
+def cleanup():
+
+    for klass in [
+        IdlePowerDetail,
+        IdlePowerResult,
+        IdlePowerMachine,
+        IdlePowerImage,
+        IdlePowerLog
+    ]:
+        logging.debug("klass: {}".format(klass))
+        klass.objects.all().delete()
+
+
+def list_stuff():
+
+    for klass in [
+        IdlePowerImage,
+        IdlePowerMachine,
+        IdlePowerDetail,
+        IdlePowerLog,
+    ]:
+        for item in klass.objects.all():
+            logging.debug(item)
+
+if __name__ == "__main__":
+    cleanup()
+    machines = add_machines(count=3)
+    images = add_images(count=10)
+    log = add_log()
+    for image in images:
+        for machine in machines:
+            add_details(machine, log, image=image)

=== modified file 'smoke/utah_utils.py'
--- smoke/utah_utils.py	2013-03-22 20:05:56 +0000
+++ smoke/utah_utils.py	2013-04-16 20:51:23 +0000
@@ -19,7 +19,8 @@
 
 import logging
 
-from smoke.utah_parser import UTAHParser, ParserError
+from common.utah_parser import UTAHParser, ParserError
+
 from smoke.models import (
     Build,
     Run,