Merge lp:~cjohnston/qa-dashboard/migrating-away into lp:qa-dashboard

[Chris Johnston]

Separates code out into sru and smoke apps, plus moves common items to common app.

* Moves helpers, index, DasboardBaseModel and Bug to common app
* Creates SRU app
* Moves SRU related code/models/views to SRU app
* Creates smoke app
* Moves smoke related code/models/views to smoke app
* Updates urls
* Removes dashboard app

REQUIRED:
./manage.py syncdb
./manage.py migrate common 0001 --fake
./manage.py migrate common 0002 --fake
./manage.py migrate smoke 0001 --fake
./manage.py migrate smoke 0002 --fake
./manage.py migrate sru 0001 --fake

I'm not quite at 4,000 lines, let me come up with something else to add. :-)

[lp:~cjohnston/qa-dashboard/migrating-away]

204. By Chris Johnston on 2012-12-20

Removes dashboard app

205. By Chris Johnston on 2012-12-20

Move sru templates to sru app

206. By Chris Johnston on 2012-12-20

I guess fixing imports is good too

207. By Chris Johnston on 2013-01-01

Fixes clear_items

208. By Chris Johnston on 2013-01-02

Updates list_items

209. By Chris Johnston on 2013-01-02

Oops.. we use smoke now

Unmerged revisions

209. By Chris Johnston on 2013-01-02

Oops.. we use smoke now

208. By Chris Johnston on 2013-01-02

Updates list_items

207. By Chris Johnston on 2013-01-01

Fixes clear_items

206. By Chris Johnston on 2012-12-20

I guess fixing imports is good too

205. By Chris Johnston on 2012-12-20

Move sru templates to sru app

204. By Chris Johnston on 2012-12-20

Removes dashboard app

203. By Chris Johnston on 2012-12-20

Move bug model to common

202. By Chris Johnston on 2012-12-20

Oops.. smoke API

201. By Chris Johnston on 2012-12-19

Fix urls

200. By Chris Johnston on 2012-12-19

More cleanup

=== modified file 'bootspeed/api.py'
--- bootspeed/api.py	2012-12-13 23:57:52 +0000
+++ bootspeed/api.py	2012-12-20 01:49:23 +0000
@@ -17,8 +17,7 @@
 from django.views.decorators.http import require_GET
 from django.shortcuts import get_object_or_404
 
-###Move to common
-from dashboard.utils import (
+from common.utils import (
         JSONResponse,
         MySerializer,
         )

=== modified file 'bootspeed/models.py'
--- bootspeed/models.py	2012-12-13 02:32:26 +0000
+++ bootspeed/models.py	2012-12-20 01:49:23 +0000
@@ -17,7 +17,7 @@
 import math
 
 from django.db import models
-from dashboard.models import DashboardBaseModel
+from common.models import DashboardBaseModel
 
 
 # Bootspeed Models

=== added file 'common/helpers.py'
--- common/helpers.py	1970-01-01 00:00:00 +0000
+++ common/helpers.py	2012-12-20 01:49:23 +0000
@@ -0,0 +1,42 @@
+# QA Dashboard
+# Copyright 2012 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 json
+import urllib2
+
+BUILD_COUNT_MAX=20 # XXX: DEBUG
+JOB_COUNT_MAX=20 # XXX: DEBUG
+DEBUG_LIMITS=False
+
+def jenkins_get(loc, as_json=True):
+    req = urllib2.Request(loc)
+    response = ''
+    try_count = 0
+
+    while try_count < 5:
+        try:
+            f = urllib2.urlopen(req)
+            response = f.read()
+            f.close()
+            break
+        except urllib2.HTTPError:
+            try_count += 1
+        except urllib2.URLError as e:
+            try_count += 1
+
+    if response != '' and as_json:
+        return json.loads(response)
+    else:
+        return response

=== added directory 'common/migrations'
=== added file 'common/migrations/0001_create_common_app.py'
--- common/migrations/0001_create_common_app.py	1970-01-01 00:00:00 +0000
+++ common/migrations/0001_create_common_app.py	2012-12-20 01:49:23 +0000
@@ -0,0 +1,20 @@
+# -*- 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):
+        pass
+
+    def backwards(self, orm):
+        pass
+
+    models = {
+        
+    }
+
+    complete_apps = ['common']
\ No newline at end of file

=== added file 'common/migrations/0002_add_bug_model.py'
--- common/migrations/0002_add_bug_model.py	1970-01-01 00:00:00 +0000
+++ common/migrations/0002_add_bug_model.py	2012-12-20 01:49:23 +0000
@@ -0,0 +1,42 @@
+# -*- 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 'Bug'
+        db.create_table('bugs', (
+            ('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)),
+            ('bug_no', self.gf('django.db.models.fields.CharField')(max_length=255)),
+            ('status', self.gf('django.db.models.fields.CharField')(max_length=255)),
+        ))
+        db.send_create_signal('common', ['Bug'])
+
+
+    def backwards(self, orm):
+        # Deleting model 'Bug'
+        db.delete_table('bugs')
+
+
+    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'})
+        }
+    }
+
+    complete_apps = ['common']
\ No newline at end of file

=== added file 'common/migrations/__init__.py'
=== modified file 'common/models.py'
--- common/models.py	2012-12-02 02:51:10 +0000
+++ common/models.py	2012-12-20 01:49:23 +0000
@@ -13,4 +13,38 @@
 # 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
+import datetime
+
+
+class DashboardBaseModel(models.Model):
+    """
+    Common base class that provides fields needed on every model.
+    """
+    class Meta:
+        abstract = True
+
+    created_at    = models.DateTimeField(auto_now_add = True)
+    updated_at    = models.DateTimeField(auto_now = True)
+    internal      = models.BooleanField(default=True)
+    publish       = models.BooleanField(default=True)
+
+
+class Bug(DashboardBaseModel):
+    class Meta:
+        db_table = 'bugs'
+    bug_no        = models.CharField(max_length=255)
+    status        = models.CharField(max_length=255)
+
+    def __unicode__(self):
+        return self.bug_no
+
+    @property
+    def debug_str(self):
+        return "{}-{}-{}-{}-{}".format(
+                self.id,
+                self.bug_no,
+                self.status,
+                self.created_at,
+                self.updated_at,
+                )

=== renamed file 'dashboard/utils.py' => 'common/utils.py'
=== modified file 'common/views.py'
--- common/views.py	2012-12-02 02:51:10 +0000
+++ common/views.py	2012-12-20 01:49:23 +0000
@@ -13,4 +13,23 @@
 # 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/>.
 
-# Create your views here.
+from django.views.decorators.http import require_GET
+from django.shortcuts import redirect, render_to_response
+import json
+
+from django.views.decorators.csrf import csrf_exempt
+from django.views.decorators.http import (
+        require_GET,
+        )
+
+from common.utils import (
+        JSONResponse,
+        )
+
+@require_GET
+def index(request):
+    return redirect('smoke/raring/flat/')
+
+@require_GET
+def api_help(request):
+    return render_to_response('api_help.html')

=== removed directory 'dashboard'
=== removed directory 'dashboard/migrations'
=== removed file 'dashboard/migrations/0001_initial.py'
--- dashboard/migrations/0001_initial.py	2012-12-02 02:51:10 +0000
+++ dashboard/migrations/0001_initial.py	1970-01-01 00:00:00 +0000
@@ -1,179 +0,0 @@
-# QA Dashboard
-# Copyright 2012 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/>.
-
-# -*- 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 'Bug'
-        db.create_table('bugs', (
-            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
-            ('bug_no', self.gf('django.db.models.fields.CharField')(max_length=255)),
-            ('status', self.gf('django.db.models.fields.CharField')(max_length=255)),
-            ('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)),
-        ))
-        db.send_create_signal('dashboard', ['Bug'])
-
-        # Adding model 'ResultLog'
-        db.create_table('result_logs', (
-            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
-            ('display_name', self.gf('django.db.models.fields.CharField')(max_length=255, null=True)),
-            ('path', self.gf('django.db.models.fields.TextField')()),
-            ('result', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['dashboard.Result'])),
-            ('remote_url', self.gf('django.db.models.fields.URLField')(max_length=200)),
-            ('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)),
-        ))
-        db.send_create_signal('dashboard', ['ResultLog'])
-
-        # Adding model 'Run'
-        db.create_table('runs', (
-            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
-            ('build_no', self.gf('django.db.models.fields.CharField')(max_length=200, db_index=True)),
-            ('release', self.gf('django.db.models.fields.CharField')(max_length=200, db_index=True)),
-            ('flavor', self.gf('django.db.models.fields.CharField')(max_length=200, db_index=True)),
-            ('test_type', self.gf('django.db.models.fields.IntegerField')(null=True)),
-            ('ran_at', self.gf('django.db.models.fields.DateTimeField')()),
-            ('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)),
-        ))
-        db.send_create_signal('dashboard', ['Run'])
-
-        # Adding model 'Build'
-        db.create_table('builds', (
-            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
-            ('run', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['dashboard.Run'])),
-            ('name', self.gf('django.db.models.fields.CharField')(max_length=200, null=True)),
-            ('flavor', 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)),
-            ('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)),
-        ))
-        db.send_create_signal('dashboard', ['Build'])
-
-        # Adding model 'Result'
-        db.create_table('results', (
-            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
-            ('build', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['dashboard.Build'])),
-            ('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
-            ('jenkins_build', self.gf('django.db.models.fields.CharField')(max_length=255)),
-            ('jenkins_url', self.gf('django.db.models.fields.URLField')(max_length=200)),
-            ('fail_count', self.gf('django.db.models.fields.IntegerField')()),
-            ('skip_count', self.gf('django.db.models.fields.IntegerField')()),
-            ('pass_count', self.gf('django.db.models.fields.IntegerField')()),
-            ('total_count', self.gf('django.db.models.fields.IntegerField')()),
-            ('ran_at', self.gf('django.db.models.fields.DateTimeField')()),
-            ('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)),
-        ))
-        db.send_create_signal('dashboard', ['Result'])
-
-        # Adding M2M table for field bugs on 'Result'
-        db.create_table('results_bugs', (
-            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
-            ('result', models.ForeignKey(orm['dashboard.result'], null=False)),
-            ('bug', models.ForeignKey(orm['dashboard.bug'], null=False))
-        ))
-        db.create_unique('results_bugs', ['result_id', 'bug_id'])
-
-
-    def backwards(self, orm):
-        # Deleting model 'Bug'
-        db.delete_table('bugs')
-
-        # Deleting model 'ResultLog'
-        db.delete_table('result_logs')
-
-        # Deleting model 'Run'
-        db.delete_table('runs')
-
-        # Deleting model 'Build'
-        db.delete_table('builds')
-
-        # Deleting model 'Result'
-        db.delete_table('results')
-
-        # Removing M2M table for field bugs on 'Result'
-        db.delete_table('results_bugs')
-
-
-    models = {
-        'dashboard.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'}),
-            'status': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.build': {
-            'Meta': {'object_name': 'Build', 'db_table': "'builds'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '200', 'null': 'True'}),
-            'run': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Run']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '200'})
-        },
-        'dashboard.result': {
-            'Meta': {'object_name': 'Result', 'db_table': "'results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Build']"}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.resultlog': {
-            'Meta': {'object_name': 'ResultLog', 'db_table': "'result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Result']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.run': {
-            'Meta': {'object_name': 'Run', 'db_table': "'runs'"},
-            'build_no': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'test_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        }
-    }
-
-    complete_apps = ['dashboard']
\ No newline at end of file

=== removed file 'dashboard/migrations/0002_auto__add_field_run_internal__add_field_bug_internal__add_field_build_.py'
--- dashboard/migrations/0002_auto__add_field_run_internal__add_field_bug_internal__add_field_build_.py	2012-12-02 02:51:10 +0000
+++ dashboard/migrations/0002_auto__add_field_run_internal__add_field_bug_internal__add_field_build_.py	1970-01-01 00:00:00 +0000
@@ -1,133 +0,0 @@
-# QA Dashboard
-# Copyright 2012 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/>.
-
-# -*- 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 field 'Run.internal'
-        db.add_column('runs', 'internal',
-                      self.gf('django.db.models.fields.BooleanField')(default=True),
-                      keep_default=False)
-
-        # Adding field 'Bug.internal'
-        db.add_column('bugs', 'internal',
-                      self.gf('django.db.models.fields.BooleanField')(default=True),
-                      keep_default=False)
-
-        # Adding field 'Build.internal'
-        db.add_column('builds', 'internal',
-                      self.gf('django.db.models.fields.BooleanField')(default=True),
-                      keep_default=False)
-
-        # Adding field 'ResultLog.internal'
-        db.add_column('result_logs', 'internal',
-                      self.gf('django.db.models.fields.BooleanField')(default=True),
-                      keep_default=False)
-
-        # Adding field 'Result.internal'
-        db.add_column('results', 'internal',
-                      self.gf('django.db.models.fields.BooleanField')(default=True),
-                      keep_default=False)
-
-
-    def backwards(self, orm):
-        # Deleting field 'Run.internal'
-        db.delete_column('runs', 'internal')
-
-        # Deleting field 'Bug.internal'
-        db.delete_column('bugs', 'internal')
-
-        # Deleting field 'Build.internal'
-        db.delete_column('builds', 'internal')
-
-        # Deleting field 'ResultLog.internal'
-        db.delete_column('result_logs', 'internal')
-
-        # Deleting field 'Result.internal'
-        db.delete_column('results', 'internal')
-
-
-    models = {
-        'dashboard.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'}),
-            'status': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.build': {
-            'Meta': {'object_name': 'Build', 'db_table': "'builds'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            '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': '200', 'null': 'True'}),
-            'run': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Run']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '200'})
-        },
-        'dashboard.result': {
-            'Meta': {'object_name': 'Result', 'db_table': "'results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Build']"}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.resultlog': {
-            'Meta': {'object_name': 'ResultLog', 'db_table': "'result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Result']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.run': {
-            'Meta': {'object_name': 'Run', 'db_table': "'runs'"},
-            'build_no': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'test_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        }
-    }
-
-    complete_apps = ['dashboard']
\ No newline at end of file

=== removed file 'dashboard/migrations/0003_auto__add_field_run_publish__add_field_bug_publish__add_field_build_pu.py'
--- dashboard/migrations/0003_auto__add_field_run_publish__add_field_bug_publish__add_field_build_pu.py	2012-12-02 02:51:10 +0000
+++ dashboard/migrations/0003_auto__add_field_run_publish__add_field_bug_publish__add_field_build_pu.py	1970-01-01 00:00:00 +0000
@@ -1,138 +0,0 @@
-# QA Dashboard
-# Copyright 2012 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/>.
-
-# -*- 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 field 'Run.publish'
-        db.add_column('runs', 'publish',
-                      self.gf('django.db.models.fields.BooleanField')(default=True),
-                      keep_default=False)
-
-        # Adding field 'Bug.publish'
-        db.add_column('bugs', 'publish',
-                      self.gf('django.db.models.fields.BooleanField')(default=True),
-                      keep_default=False)
-
-        # Adding field 'Build.publish'
-        db.add_column('builds', 'publish',
-                      self.gf('django.db.models.fields.BooleanField')(default=True),
-                      keep_default=False)
-
-        # Adding field 'ResultLog.publish'
-        db.add_column('result_logs', 'publish',
-                      self.gf('django.db.models.fields.BooleanField')(default=True),
-                      keep_default=False)
-
-        # Adding field 'Result.publish'
-        db.add_column('results', 'publish',
-                      self.gf('django.db.models.fields.BooleanField')(default=True),
-                      keep_default=False)
-
-
-    def backwards(self, orm):
-        # Deleting field 'Run.publish'
-        db.delete_column('runs', 'publish')
-
-        # Deleting field 'Bug.publish'
-        db.delete_column('bugs', 'publish')
-
-        # Deleting field 'Build.publish'
-        db.delete_column('builds', 'publish')
-
-        # Deleting field 'ResultLog.publish'
-        db.delete_column('result_logs', 'publish')
-
-        # Deleting field 'Result.publish'
-        db.delete_column('results', 'publish')
-
-
-    models = {
-        'dashboard.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'})
-        },
-        'dashboard.build': {
-            'Meta': {'object_name': 'Build', 'db_table': "'builds'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            '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': '200', 'null': 'True'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'run': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Run']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '200'})
-        },
-        'dashboard.result': {
-            'Meta': {'object_name': 'Result', 'db_table': "'results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Build']"}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.resultlog': {
-            'Meta': {'object_name': 'ResultLog', 'db_table': "'result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Result']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.run': {
-            'Meta': {'object_name': 'Run', 'db_table': "'runs'"},
-            'build_no': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': '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'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'test_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        }
-    }
-
-    complete_apps = ['dashboard']
\ No newline at end of file

=== removed file 'dashboard/migrations/0004_auto__add_kernel__add_sruresult__add_sruresultlog.py'
--- dashboard/migrations/0004_auto__add_kernel__add_sruresult__add_sruresultlog.py	2012-12-02 02:51:10 +0000
+++ dashboard/migrations/0004_auto__add_kernel__add_sruresult__add_sruresultlog.py	1970-01-01 00:00:00 +0000
@@ -1,208 +0,0 @@
-# QA Dashboard
-# Copyright 2012 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/>.
-
-# encoding: 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 'Kernel'
-        db.create_table('kernels', (
-            ('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=100)),
-            ('variant', self.gf('django.db.models.fields.CharField')(max_length=100)),
-            ('arch', self.gf('django.db.models.fields.CharField')(max_length=100)),
-            ('gpu', self.gf('django.db.models.fields.CharField')(max_length=100)),
-        ))
-        db.send_create_signal('dashboard', ['Kernel'])
-
-        # Adding model 'SRUResult'
-        db.create_table('sru_results', (
-            ('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)),
-            ('kernel', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['dashboard.Kernel'])),
-            ('jenkins_build', self.gf('django.db.models.fields.CharField')(max_length=255)),
-            ('jenkins_url', self.gf('django.db.models.fields.URLField')(max_length=200)),
-            ('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
-            ('pass_count', self.gf('django.db.models.fields.IntegerField')()),
-            ('fail_count', self.gf('django.db.models.fields.IntegerField')()),
-            ('skip_count', self.gf('django.db.models.fields.IntegerField')()),
-            ('total_count', self.gf('django.db.models.fields.IntegerField')()),
-            ('ran_at', self.gf('django.db.models.fields.DateTimeField')()),
-        ))
-        db.send_create_signal('dashboard', ['SRUResult'])
-
-        # Adding M2M table for field bugs on 'SRUResult'
-        db.create_table('sru_results_bugs', (
-            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
-            ('sruresult', models.ForeignKey(orm['dashboard.sruresult'], null=False)),
-            ('bug', models.ForeignKey(orm['dashboard.bug'], null=False))
-        ))
-        db.create_unique('sru_results_bugs', ['sruresult_id', 'bug_id'])
-
-        # Adding model 'SRUResultLog'
-        db.create_table('sru_result_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)),
-            ('display_name', self.gf('django.db.models.fields.CharField')(max_length=255, null=True)),
-            ('path', self.gf('django.db.models.fields.TextField')()),
-            ('sru_result', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['dashboard.SRUResult'])),
-            ('remote_url', self.gf('django.db.models.fields.URLField')(max_length=200)),
-        ))
-        db.send_create_signal('dashboard', ['SRUResultLog'])
-
-
-    def backwards(self, orm):
-        
-        # Deleting model 'Kernel'
-        db.delete_table('kernels')
-
-        # Deleting model 'SRUResult'
-        db.delete_table('sru_results')
-
-        # Removing M2M table for field bugs on 'SRUResult'
-        db.delete_table('sru_results_bugs')
-
-        # Deleting model 'SRUResultLog'
-        db.delete_table('sru_result_logs')
-
-
-    models = {
-        'dashboard.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'})
-        },
-        'dashboard.build': {
-            'Meta': {'object_name': 'Build', 'db_table': "'builds'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            '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': '200', 'null': 'True'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'run': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Run']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '200'})
-        },
-        'dashboard.kernel': {
-            'Meta': {'object_name': 'Kernel', 'db_table': "'kernels'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'gpu': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            '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'}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '100'})
-        },
-        'dashboard.result': {
-            'Meta': {'object_name': 'Result', 'db_table': "'results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Build']"}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.resultlog': {
-            'Meta': {'object_name': 'ResultLog', 'db_table': "'result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Result']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.run': {
-            'Meta': {'object_name': 'Run', 'db_table': "'runs'"},
-            'build_no': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': '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'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'test_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresult': {
-            'Meta': {'object_name': 'SRUResult', 'db_table': "'sru_results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'kernel': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Kernel']"}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresultlog': {
-            'Meta': {'object_name': 'SRUResultLog', 'db_table': "'sru_result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'sru_result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.SRUResult']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        }
-    }
-
-    complete_apps = ['dashboard']

=== removed file 'dashboard/migrations/0005_auto__add_field_kernel_job_type.py'
--- dashboard/migrations/0005_auto__add_field_kernel_job_type.py	2012-12-02 02:51:10 +0000
+++ dashboard/migrations/0005_auto__add_field_kernel_job_type.py	1970-01-01 00:00:00 +0000
@@ -1,148 +0,0 @@
-# QA Dashboard
-# Copyright 2012 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/>.
-
-# encoding: 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 field 'Kernel.job_type'
-        db.add_column('kernels', 'job_type', self.gf('django.db.models.fields.CharField')(default='sru_kernel', max_length=100), keep_default=False)
-
-
-    def backwards(self, orm):
-        
-        # Deleting field 'Kernel.job_type'
-        db.delete_column('kernels', 'job_type')
-
-
-    models = {
-        'dashboard.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'})
-        },
-        'dashboard.build': {
-            'Meta': {'object_name': 'Build', 'db_table': "'builds'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            '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': '200', 'null': 'True'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'run': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Run']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '200'})
-        },
-        'dashboard.kernel': {
-            'Meta': {'object_name': 'Kernel', 'db_table': "'kernels'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'gpu': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'job_type': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '100'})
-        },
-        'dashboard.result': {
-            'Meta': {'object_name': 'Result', 'db_table': "'results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Build']"}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.resultlog': {
-            'Meta': {'object_name': 'ResultLog', 'db_table': "'result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Result']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.run': {
-            'Meta': {'object_name': 'Run', 'db_table': "'runs'"},
-            'build_no': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': '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'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'test_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresult': {
-            'Meta': {'object_name': 'SRUResult', 'db_table': "'sru_results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'kernel': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Kernel']"}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresultlog': {
-            'Meta': {'object_name': 'SRUResultLog', 'db_table': "'sru_result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'sru_result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.SRUResult']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        }
-    }
-
-    complete_apps = ['dashboard']

=== removed file 'dashboard/migrations/0006_auto__add_field_sruresult_kernel_version.py'
--- dashboard/migrations/0006_auto__add_field_sruresult_kernel_version.py	2012-12-02 02:51:10 +0000
+++ dashboard/migrations/0006_auto__add_field_sruresult_kernel_version.py	1970-01-01 00:00:00 +0000
@@ -1,149 +0,0 @@
-# QA Dashboard
-# Copyright 2012 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/>.
-
-# encoding: 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 field 'SRUResult.kernel_version'
-        db.add_column('sru_results', 'kernel_version', self.gf('django.db.models.fields.CharField')(default='Unknown', max_length=100), keep_default=False)
-
-
-    def backwards(self, orm):
-        
-        # Deleting field 'SRUResult.kernel_version'
-        db.delete_column('sru_results', 'kernel_version')
-
-
-    models = {
-        'dashboard.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'})
-        },
-        'dashboard.build': {
-            'Meta': {'object_name': 'Build', 'db_table': "'builds'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            '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': '200', 'null': 'True'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'run': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Run']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '200'})
-        },
-        'dashboard.kernel': {
-            'Meta': {'object_name': 'Kernel', 'db_table': "'kernels'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'gpu': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'job_type': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '100'})
-        },
-        'dashboard.result': {
-            'Meta': {'object_name': 'Result', 'db_table': "'results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Build']"}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.resultlog': {
-            'Meta': {'object_name': 'ResultLog', 'db_table': "'result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Result']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.run': {
-            'Meta': {'object_name': 'Run', 'db_table': "'runs'"},
-            'build_no': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': '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'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'test_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresult': {
-            'Meta': {'object_name': 'SRUResult', 'db_table': "'sru_results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'kernel': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Kernel']"}),
-            'kernel_version': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresultlog': {
-            'Meta': {'object_name': 'SRUResultLog', 'db_table': "'sru_result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'sru_result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.SRUResult']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        }
-    }
-
-    complete_apps = ['dashboard']

=== removed file 'dashboard/migrations/0007_auto__add_field_kernel_version__del_field_sruresult_kernel_version.py'
--- dashboard/migrations/0007_auto__add_field_kernel_version__del_field_sruresult_kernel_version.py	2012-12-02 02:51:10 +0000
+++ dashboard/migrations/0007_auto__add_field_kernel_version__del_field_sruresult_kernel_version.py	1970-01-01 00:00:00 +0000
@@ -1,155 +0,0 @@
-# QA Dashboard
-# Copyright 2012 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/>.
-
-# encoding: 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 field 'Kernel.version'
-        db.add_column('kernels', 'version', self.gf('django.db.models.fields.CharField')(default='Unknown', max_length=100), keep_default=False)
-
-        # Deleting field 'SRUResult.kernel_version'
-        db.delete_column('sru_results', 'kernel_version')
-
-
-    def backwards(self, orm):
-        
-        # Deleting field 'Kernel.version'
-        db.delete_column('kernels', 'version')
-
-        # Adding field 'SRUResult.kernel_version'
-        db.add_column('sru_results', 'kernel_version', self.gf('django.db.models.fields.CharField')(default='Unknown', max_length=100), keep_default=False)
-
-
-    models = {
-        'dashboard.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'})
-        },
-        'dashboard.build': {
-            'Meta': {'object_name': 'Build', 'db_table': "'builds'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            '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': '200', 'null': 'True'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'run': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Run']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '200'})
-        },
-        'dashboard.kernel': {
-            'Meta': {'object_name': 'Kernel', 'db_table': "'kernels'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'gpu': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'job_type': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'version': ('django.db.models.fields.CharField', [], {'max_length': '100'})
-        },
-        'dashboard.result': {
-            'Meta': {'object_name': 'Result', 'db_table': "'results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Build']"}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.resultlog': {
-            'Meta': {'object_name': 'ResultLog', 'db_table': "'result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Result']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.run': {
-            'Meta': {'object_name': 'Run', 'db_table': "'runs'"},
-            'build_no': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': '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'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'test_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresult': {
-            'Meta': {'object_name': 'SRUResult', 'db_table': "'sru_results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'kernel': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Kernel']"}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresultlog': {
-            'Meta': {'object_name': 'SRUResultLog', 'db_table': "'sru_result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'sru_result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.SRUResult']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        }
-    }
-
-    complete_apps = ['dashboard']

=== removed file 'dashboard/migrations/0008_auto__add_imageresult__add_machine__add_image.py'
--- dashboard/migrations/0008_auto__add_imageresult__add_machine__add_image.py	2012-12-02 02:51:10 +0000
+++ dashboard/migrations/0008_auto__add_imageresult__add_machine__add_image.py	1970-01-01 00:00:00 +0000
@@ -1,238 +0,0 @@
-# QA Dashboard
-# Copyright 2012 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/>.
-
-# encoding: 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 'ImageResult'
-        db.create_table('images_results', (
-            ('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['dashboard.Image'])),
-            ('machine', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['dashboard.Machine'])),
-            ('ran_at', self.gf('django.db.models.fields.DateTimeField')()),
-            ('kernel_init', self.gf('django.db.models.fields.FloatField')()),
-            ('kernel', self.gf('django.db.models.fields.FloatField')()),
-            ('plumbing', self.gf('django.db.models.fields.FloatField')()),
-            ('xorg', self.gf('django.db.models.fields.FloatField')()),
-            ('desktop', self.gf('django.db.models.fields.FloatField')()),
-            ('boot', self.gf('django.db.models.fields.FloatField')()),
-        ))
-        db.send_create_signal('dashboard', ['ImageResult'])
-
-        # Adding model 'Machine'
-        db.create_table('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')(max_length=200)),
-            ('mac_address', self.gf('django.db.models.fields.CharField')(max_length=200)),
-        ))
-        db.send_create_signal('dashboard', ['Machine'])
-
-        # Adding model 'Image'
-        db.create_table('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')(max_length=200)),
-            ('build_number', self.gf('django.db.models.fields.CharField')(max_length=50)),
-        ))
-        db.send_create_signal('dashboard', ['Image'])
-
-
-    def backwards(self, orm):
-        
-        # Deleting model 'ImageResult'
-        db.delete_table('images_results')
-
-        # Deleting model 'Machine'
-        db.delete_table('machines')
-
-        # Deleting model 'Image'
-        db.delete_table('images')
-
-
-    models = {
-        'dashboard.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'})
-        },
-        'dashboard.build': {
-            'Meta': {'object_name': 'Build', 'db_table': "'builds'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            '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': '200', 'null': 'True'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'run': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Run']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '200'})
-        },
-        'dashboard.image': {
-            'Meta': {'object_name': 'Image', 'db_table': "'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'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'md5': ('django.db.models.fields.CharField', [], {'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'})
-        },
-        'dashboard.imageresult': {
-            'Meta': {'object_name': 'ImageResult', 'db_table': "'images_results'"},
-            'boot': ('django.db.models.fields.FloatField', [], {}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'desktop': ('django.db.models.fields.FloatField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'image': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Image']"}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'kernel': ('django.db.models.fields.FloatField', [], {}),
-            'kernel_init': ('django.db.models.fields.FloatField', [], {}),
-            'machine': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Machine']"}),
-            'plumbing': ('django.db.models.fields.FloatField', [], {}),
-            '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'}),
-            'xorg': ('django.db.models.fields.FloatField', [], {})
-        },
-        'dashboard.kernel': {
-            'Meta': {'object_name': 'Kernel', 'db_table': "'kernels'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'gpu': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'job_type': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'version': ('django.db.models.fields.CharField', [], {'max_length': '100'})
-        },
-        'dashboard.machine': {
-            'Meta': {'object_name': 'Machine', 'db_table': "'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', [], {'max_length': '200'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.result': {
-            'Meta': {'object_name': 'Result', 'db_table': "'results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Build']"}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.resultlog': {
-            'Meta': {'object_name': 'ResultLog', 'db_table': "'result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Result']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.run': {
-            'Meta': {'object_name': 'Run', 'db_table': "'runs'"},
-            'build_no': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': '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'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'test_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresult': {
-            'Meta': {'object_name': 'SRUResult', 'db_table': "'sru_results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'kernel': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Kernel']"}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresultlog': {
-            'Meta': {'object_name': 'SRUResultLog', 'db_table': "'sru_result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'sru_result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.SRUResult']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        }
-    }
-
-    complete_apps = ['dashboard']

=== removed file 'dashboard/migrations/0009_auto__add_unique_machine_name__add_unique_image_release_arch_variant_b.py'
--- dashboard/migrations/0009_auto__add_unique_machine_name__add_unique_image_release_arch_variant_b.py	2012-12-02 02:51:10 +0000
+++ dashboard/migrations/0009_auto__add_unique_machine_name__add_unique_image_release_arch_variant_b.py	1970-01-01 00:00:00 +0000
@@ -1,195 +0,0 @@
-# QA Dashboard
-# Copyright 2012 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/>.
-
-# encoding: 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 unique constraint on 'Machine', fields ['name']
-        db.create_unique('machines', ['name'])
-
-        # Adding unique constraint on 'Image', fields ['release', 'arch', 'variant', 'build_number']
-        db.create_unique('images', ['release', 'arch', 'variant', 'build_number'])
-
-
-    def backwards(self, orm):
-        
-        # Removing unique constraint on 'Image', fields ['release', 'arch', 'variant', 'build_number']
-        db.delete_unique('images', ['release', 'arch', 'variant', 'build_number'])
-
-        # Removing unique constraint on 'Machine', fields ['name']
-        db.delete_unique('machines', ['name'])
-
-
-    models = {
-        'dashboard.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'})
-        },
-        'dashboard.build': {
-            'Meta': {'object_name': 'Build', 'db_table': "'builds'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            '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': '200', 'null': 'True'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'run': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Run']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '200'})
-        },
-        'dashboard.image': {
-            'Meta': {'unique_together': "(('release', 'variant', 'arch', 'build_number'),)", 'object_name': 'Image', 'db_table': "'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'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'md5': ('django.db.models.fields.CharField', [], {'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'})
-        },
-        'dashboard.imageresult': {
-            'Meta': {'object_name': 'ImageResult', 'db_table': "'images_results'"},
-            'boot': ('django.db.models.fields.FloatField', [], {}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'desktop': ('django.db.models.fields.FloatField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'image': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Image']"}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'kernel': ('django.db.models.fields.FloatField', [], {}),
-            'kernel_init': ('django.db.models.fields.FloatField', [], {}),
-            'machine': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Machine']"}),
-            'plumbing': ('django.db.models.fields.FloatField', [], {}),
-            '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'}),
-            'xorg': ('django.db.models.fields.FloatField', [], {})
-        },
-        'dashboard.kernel': {
-            'Meta': {'object_name': 'Kernel', 'db_table': "'kernels'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'gpu': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'job_type': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'version': ('django.db.models.fields.CharField', [], {'max_length': '100'})
-        },
-        'dashboard.machine': {
-            'Meta': {'object_name': 'Machine', 'db_table': "'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'})
-        },
-        'dashboard.result': {
-            'Meta': {'object_name': 'Result', 'db_table': "'results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Build']"}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.resultlog': {
-            'Meta': {'object_name': 'ResultLog', 'db_table': "'result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Result']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.run': {
-            'Meta': {'object_name': 'Run', 'db_table': "'runs'"},
-            'build_no': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': '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'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'test_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresult': {
-            'Meta': {'object_name': 'SRUResult', 'db_table': "'sru_results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'kernel': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Kernel']"}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresultlog': {
-            'Meta': {'object_name': 'SRUResultLog', 'db_table': "'sru_result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'sru_result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.SRUResult']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        }
-    }
-
-    complete_apps = ['dashboard']

=== removed file 'dashboard/migrations/0010_auto__add_unique_image_md5.py'
--- dashboard/migrations/0010_auto__add_unique_image_md5.py	2012-12-02 02:51:10 +0000
+++ dashboard/migrations/0010_auto__add_unique_image_md5.py	1970-01-01 00:00:00 +0000
@@ -1,189 +0,0 @@
-# QA Dashboard
-# Copyright 2012 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/>.
-
-# encoding: 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 unique constraint on 'Image', fields ['md5']
-        db.create_unique('images', ['md5'])
-
-
-    def backwards(self, orm):
-        
-        # Removing unique constraint on 'Image', fields ['md5']
-        db.delete_unique('images', ['md5'])
-
-
-    models = {
-        'dashboard.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'})
-        },
-        'dashboard.build': {
-            'Meta': {'object_name': 'Build', 'db_table': "'builds'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            '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': '200', 'null': 'True'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'run': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Run']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '200'})
-        },
-        'dashboard.image': {
-            'Meta': {'unique_together': "(('release', 'variant', 'arch', 'build_number'),)", 'object_name': 'Image', 'db_table': "'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'}),
-            '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'})
-        },
-        'dashboard.imageresult': {
-            'Meta': {'object_name': 'ImageResult', 'db_table': "'images_results'"},
-            'boot': ('django.db.models.fields.FloatField', [], {}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'desktop': ('django.db.models.fields.FloatField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'image': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Image']"}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'kernel': ('django.db.models.fields.FloatField', [], {}),
-            'kernel_init': ('django.db.models.fields.FloatField', [], {}),
-            'machine': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Machine']"}),
-            'plumbing': ('django.db.models.fields.FloatField', [], {}),
-            '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'}),
-            'xorg': ('django.db.models.fields.FloatField', [], {})
-        },
-        'dashboard.kernel': {
-            'Meta': {'object_name': 'Kernel', 'db_table': "'kernels'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'gpu': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'job_type': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'version': ('django.db.models.fields.CharField', [], {'max_length': '100'})
-        },
-        'dashboard.machine': {
-            'Meta': {'object_name': 'Machine', 'db_table': "'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'})
-        },
-        'dashboard.result': {
-            'Meta': {'object_name': 'Result', 'db_table': "'results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Build']"}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.resultlog': {
-            'Meta': {'object_name': 'ResultLog', 'db_table': "'result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Result']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.run': {
-            'Meta': {'object_name': 'Run', 'db_table': "'runs'"},
-            'build_no': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': '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'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'test_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresult': {
-            'Meta': {'object_name': 'SRUResult', 'db_table': "'sru_results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'kernel': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Kernel']"}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresultlog': {
-            'Meta': {'object_name': 'SRUResultLog', 'db_table': "'sru_result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'sru_result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.SRUResult']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        }
-    }
-
-    complete_apps = ['dashboard']

=== removed file 'dashboard/migrations/0011_removing_bootspeed.py'
--- dashboard/migrations/0011_removing_bootspeed.py	2012-12-02 02:51:10 +0000
+++ dashboard/migrations/0011_removing_bootspeed.py	1970-01-01 00:00:00 +0000
@@ -1,203 +0,0 @@
-# QA Dashboard
-# Copyright 2012 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/>.
-
-# -*- 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):
-        # Removing unique constraint on 'Image', fields ['release', 'variant', 'arch', 'build_number']
-        db.delete_unique('images', ['release', 'variant', 'arch', 'build_number'])
-
-        # Deleting model 'ImageResult'
-        db.delete_table('images_results')
-
-        # Deleting model 'Machine'
-        db.delete_table('machines')
-
-        # Deleting model 'Image'
-        db.delete_table('images')
-
-
-    def backwards(self, orm):
-        # Adding model 'ImageResult'
-        db.create_table('images_results', (
-            ('kernel', self.gf('django.db.models.fields.FloatField')()),
-            ('image', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['dashboard.Image'])),
-            ('updated_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
-            ('xorg', self.gf('django.db.models.fields.FloatField')()),
-            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
-            ('ran_at', self.gf('django.db.models.fields.DateTimeField')()),
-            ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
-            ('kernel_init', self.gf('django.db.models.fields.FloatField')()),
-            ('boot', self.gf('django.db.models.fields.FloatField')()),
-            ('publish', self.gf('django.db.models.fields.BooleanField')(default=True)),
-            ('desktop', self.gf('django.db.models.fields.FloatField')()),
-            ('machine', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['dashboard.Machine'])),
-            ('internal', self.gf('django.db.models.fields.BooleanField')(default=True)),
-            ('plumbing', self.gf('django.db.models.fields.FloatField')()),
-        ))
-        db.send_create_signal('dashboard', ['ImageResult'])
-
-        # Adding model 'Machine'
-        db.create_table('machines', (
-            ('name', self.gf('django.db.models.fields.CharField')(max_length=200, unique=True)),
-            ('internal', self.gf('django.db.models.fields.BooleanField')(default=True)),
-            ('mac_address', self.gf('django.db.models.fields.CharField')(max_length=200)),
-            ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
-            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
-            ('publish', self.gf('django.db.models.fields.BooleanField')(default=True)),
-            ('updated_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
-        ))
-        db.send_create_signal('dashboard', ['Machine'])
-
-        # Adding model 'Image'
-        db.create_table('images', (
-            ('variant', self.gf('django.db.models.fields.CharField')(max_length=200)),
-            ('updated_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
-            ('arch', self.gf('django.db.models.fields.CharField')(max_length=200)),
-            ('internal', self.gf('django.db.models.fields.BooleanField')(default=True)),
-            ('md5', self.gf('django.db.models.fields.CharField')(max_length=200, unique=True)),
-            ('build_number', self.gf('django.db.models.fields.CharField')(max_length=50)),
-            ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
-            ('publish', self.gf('django.db.models.fields.BooleanField')(default=True)),
-            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
-            ('release', self.gf('django.db.models.fields.CharField')(max_length=200)),
-        ))
-        db.send_create_signal('dashboard', ['Image'])
-
-        # Adding unique constraint on 'Image', fields ['release', 'variant', 'arch', 'build_number']
-        db.create_unique('images', ['release', 'variant', 'arch', 'build_number'])
-
-
-    models = {
-        'dashboard.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'})
-        },
-        'dashboard.build': {
-            'Meta': {'object_name': 'Build', 'db_table': "'builds'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            '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': '200', 'null': 'True'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'run': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Run']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '200'})
-        },
-        'dashboard.kernel': {
-            'Meta': {'object_name': 'Kernel', 'db_table': "'kernels'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'gpu': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'job_type': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'version': ('django.db.models.fields.CharField', [], {'max_length': '100'})
-        },
-        'dashboard.result': {
-            'Meta': {'object_name': 'Result', 'db_table': "'results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Build']"}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.resultlog': {
-            'Meta': {'object_name': 'ResultLog', 'db_table': "'result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Result']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.run': {
-            'Meta': {'object_name': 'Run', 'db_table': "'runs'"},
-            'build_no': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': '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'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'test_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresult': {
-            'Meta': {'object_name': 'SRUResult', 'db_table': "'sru_results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'kernel': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Kernel']"}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresultlog': {
-            'Meta': {'object_name': 'SRUResultLog', 'db_table': "'sru_result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'sru_result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.SRUResult']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        }
-    }
-
-    complete_apps = ['dashboard']
\ No newline at end of file

=== removed file 'dashboard/migrations/0012_change_skip_to_error.py'
--- dashboard/migrations/0012_change_skip_to_error.py	2012-12-05 22:24:13 +0000
+++ dashboard/migrations/0012_change_skip_to_error.py	1970-01-01 00:00:00 +0000
@@ -1,143 +0,0 @@
-# -*- 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):
-        # Deleting field 'Result.skip_count'
-        db.delete_column('results', 'skip_count')
-
-        # Adding field 'Result.error_count'
-        db.add_column('results', 'error_count',
-                      self.gf('django.db.models.fields.IntegerField')(default=0),
-                      keep_default=False)
-
-
-    def backwards(self, orm):
-        # Adding field 'Result.skip_count'
-        db.add_column('results', 'skip_count',
-                      self.gf('django.db.models.fields.IntegerField')(default=0),
-                      keep_default=False)
-
-        # Deleting field 'Result.error_count'
-        db.delete_column('results', 'error_count')
-
-
-    models = {
-        'dashboard.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'})
-        },
-        'dashboard.build': {
-            'Meta': {'object_name': 'Build', 'db_table': "'builds'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
-            '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': '200', 'null': 'True'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'run': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Run']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '200'})
-        },
-        'dashboard.kernel': {
-            'Meta': {'object_name': 'Kernel', 'db_table': "'kernels'"},
-            'arch': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'gpu': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'job_type': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
-            'variant': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
-            'version': ('django.db.models.fields.CharField', [], {'max_length': '100'})
-        },
-        'dashboard.result': {
-            'Meta': {'object_name': 'Result', 'db_table': "'results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Build']"}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'error_count': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.resultlog': {
-            'Meta': {'object_name': 'ResultLog', 'db_table': "'result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Result']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.run': {
-            'Meta': {'object_name': 'Run', 'db_table': "'runs'"},
-            'build_no': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': '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'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'release': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
-            'test_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresult': {
-            'Meta': {'object_name': 'SRUResult', 'db_table': "'sru_results'"},
-            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'kernel': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.Kernel']"}),
-            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
-            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
-            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
-            'total_count': ('django.db.models.fields.IntegerField', [], {}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        },
-        'dashboard.sruresultlog': {
-            'Meta': {'object_name': 'SRUResultLog', 'db_table': "'sru_result_logs'"},
-            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
-            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
-            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
-            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'path': ('django.db.models.fields.TextField', [], {}),
-            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
-            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
-            'sru_result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['dashboard.SRUResult']"}),
-            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
-        }
-    }
-
-    complete_apps = ['dashboard']
\ No newline at end of file

=== removed file 'dashboard/migrations/__init__.py'
--- dashboard/migrations/__init__.py	2012-12-02 02:51:10 +0000
+++ dashboard/migrations/__init__.py	1970-01-01 00:00:00 +0000
@@ -1,15 +0,0 @@
-# QA Dashboard
-# Copyright 2012 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/>.
-

=== removed directory 'dashboard/views'
=== removed file 'dashboard/views/__init__.py'
--- dashboard/views/__init__.py	2012-12-04 22:45:22 +0000
+++ dashboard/views/__init__.py	1970-01-01 00:00:00 +0000
@@ -1,21 +0,0 @@
-# QA Dashboard
-# Copyright 2012 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.shortcuts import redirect
-
-@require_GET
-def index(request):
-    return redirect('smoke/raring/flat/')

=== removed directory 'dashboard/views/api'
=== removed file 'dashboard/views/api/__init__.py'
--- dashboard/views/api/__init__.py	2012-12-13 02:03:19 +0000
+++ dashboard/views/api/__init__.py	1970-01-01 00:00:00 +0000
@@ -1,35 +0,0 @@
-# QA Dashboard
-# Copyright 2012 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 json
-
-from django.shortcuts import render_to_response
-from django.views.decorators.csrf import csrf_exempt
-from django.views.decorators.http import (
-        require_GET,
-        )
-
-from dashboard.forms import (
-        ResultSmokeAddForm,
-        ResultKernelSRUAddForm,
-        BugForm,
-        )
-from dashboard.utils import (
-        JSONResponse,
-        )
-
-@require_GET
-def api_help(request):
-    return render_to_response('api_help.html')

=== removed file 'dashboard/views/sru.py'
--- dashboard/views/sru.py	2012-12-14 23:59:31 +0000
+++ dashboard/views/sru.py	1970-01-01 00:00:00 +0000
@@ -1,142 +0,0 @@
-# QA Dashboard
-# Copyright 2012 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.shortcuts import render_to_response
-from django.views.decorators.http import require_GET
-from django.db.models import Sum, F
-from django.template import RequestContext
-
-from dashboard.models import Kernel
-from dashboard.utils import (
-        JSONResponse,
-        MySerializer,
-        get_verbose,
-        )
-
-def _get_kernel_names():
-    kernels = []
-    for kernel in Kernel.objects.values('variant').distinct().exclude(publish=False).order_by('variant'):
-        kernels.append(kernel['variant'])
-
-    return kernels
-
-def _get_kernel_releases():
-    releases = []
-    for kernel in Kernel.objects.values('release').distinct().exclude(publish=False).order_by('-release'):
-        releases.append(kernel['release'])
-
-    return releases
-
-@require_GET
-def api_overview(request, release='', version=''):
-    kernels = Kernel.objects.all()
-
-    if release != '':
-        kernels = kernels.filter(release=release)
-
-    if version != '':
-        kernels = kernels.filter(version=version)
-
-    serializer = MySerializer(use_extra_fields=get_verbose(request, True))
-    data = serializer.serialize(kernels)
-
-    return JSONResponse(data)
-
-@require_GET
-def overview(request, release=''):
-    data = {}
-    data['kernel_names'] = _get_kernel_names()
-    data['releases'] = _get_kernel_releases()
-    data['kernels'] = []
-    data['show_unknown'] = True
-
-    show_unknown = request.GET.get('show_unknown')
-
-    kernels = Kernel.objects.all()
-
-    if show_unknown is None or show_unknown != "1":
-        data['show_unknown'] = False
-        kernels = kernels.exclude(version__startswith="Unknown")
-
-    if release != '':
-        kernels = kernels.filter(release=release)
-
-    kernel_data = {}
-    for kernel in kernels:
-        version = kernel.version
-        if version not in kernel_data:
-            kernel_data[version] = {
-                    'version': version,
-                    'pass_count': 0,
-                    'fail_count': 0,
-                    'skip_count': 0,
-                    'total_count': 0,
-                    'bug_count': 0,
-                    }
-
-        kernel_data[version]['pass_count'] += kernel.pass_count
-        kernel_data[version]['skip_count'] += kernel.skip_count
-        kernel_data[version]['fail_count'] += kernel.fail_count
-        kernel_data[version]['total_count'] += kernel.total_count
-        kernel_data[version]['bug_count'] += kernel.bug_count
-        kernel_data[version]['release'] = kernel.release
-        kernel_data[version]['last_run_date'] = kernel.last_run_date
-
-
-    for k,v in kernel_data.iteritems():
-        if v['total_count'] == 0:
-            v['pass_rate'] = 0
-        else:
-            v['pass_rate'] = v['pass_count'] * 1.0 / v['total_count']
-
-        v['pass_rate_pct'] = "{:<.2%}".format(v['pass_rate'])
-
-        data['kernels'].append(v)
-
-    return render_to_response('sru/overview.html', data, RequestContext(request))
-
-@require_GET
-def overview_kernel(request, release=None, kernel_version=None):
-    kernels = Kernel.objects.filter(version=kernel_version).select_related()
-
-    data = {
-        'kernels': kernels,
-        'kernel_version': kernel_version,
-        'release': release
-    }
-
-    totals = {
-            'skip_count': 0,
-            'pass_count': 0,
-            'fail_count': 0,
-            'total_count': 0,
-            'pass_rate': 0.0,
-            }
-
-    for k in kernels:
-        totals['skip_count'] += k.skip_count
-        totals['pass_count'] += k.pass_count
-        totals['fail_count'] += k.fail_count
-        totals['total_count'] += k.total_count
-
-    if totals['total_count'] == 0:
-        totals['pass_rate'] = 0.0
-    else:
-        totals['pass_rate'] = totals['pass_count'] * 1.0 / totals['total_count']
-    totals['pass_rate_pct'] = "{:.2%}".format(totals['pass_rate'])
-
-    data['totals'] = totals
-
-    return render_to_response('sru/overview_kernel.html', data, RequestContext(request))

=== modified file 'qa_dashboard/settings.py'
--- qa_dashboard/settings.py	2012-12-14 23:59:31 +0000
+++ qa_dashboard/settings.py	2012-12-20 01:49:23 +0000
@@ -142,9 +142,10 @@
     'django.contrib.sessions',
     'django.contrib.staticfiles',
     'django_tables2',
-    'dashboard',
     'bootspeed',
     'common',
+    'smoke',
+    'sru',
     'south',
 )
 

=== modified file 'qa_dashboard/urls.py'
--- qa_dashboard/urls.py	2012-12-13 03:33:47 +0000
+++ qa_dashboard/urls.py	2012-12-20 01:49:23 +0000
@@ -17,33 +17,38 @@
 
 from django.conf.urls.defaults import patterns, url
 
-urlpatterns = patterns('dashboard.views',
+urlpatterns = patterns('common.views',
     url(r'^$', 'index', name='index'),
-    url(r'^smoke/(?P<release>\w+)/$', 'smoke.overview', name='smoke_overview'),
-    url(r'^smoke/(?P<release>\w+)/flat/$', 'smoke.overview', dict(is_flat=True), name='flat'),
-    url(r'^smoke/(?P<release>\w+)/run/(?P<run_id>\d+)/$', 'smoke.build_overview', name='build_overview'),
-    url(r'^smoke/(?P<release>\w+)/run/(?P<run_id>\d+)/pie/$', 'smoke.build_pie', name='build_pie'),
-    url(r'^smoke/(?P<release>\w+)/run/(?P<run_id>\d+)/image/(?P<image_id>\d+)/$', 'smoke.results', name='smoke_results'),
-    url(r'^smoke/(?P<release>\w+)/run/(?P<run_id>\d+)/image/(?P<image_id>\d+)/pie/$', 'smoke.results_pie', name='results_pie'),
-    url(r'^smoke/(?P<release>\w+)/run/(?P<run_id>\d+)/image/(?P<image_id>\d+)/logs/(?P<result_id>\d+)/$', 'smoke.results_logs', name='results_logs'),
-    url(r'^api/stats/$', 'api.smoke.api_stats'),
-    url(r'^api/stats/(?P<release>\w+)/$', 'api.smoke.api_stats'),
-    url(r'^api/smoke/(?P<release>\w+)/run/$', 'api.smoke.api_runs'),
-    url(r'^api/smoke/run/$', 'api.smoke.api_runs'),
-    url(r'^api/smoke/run/(?P<run_id>\d+)/$', 'api.smoke.api_run'),
-    url(r'^api/smoke/run/(?P<run_id>\d+)/image/$', 'api.smoke.api_images'),
-    url(r'^api/smoke/run/(?P<run_id>\d+)/image/(?P<image_id>\d+)/$', 'api.smoke.api_image'),
-    url(r'^api/smoke/run/(?P<run_id>\d+)/image/(?P<image_id>\d+)/result/$', 'api.smoke.api_results'),
-    url(r'^api/smoke/run/(?P<run_id>\d+)/image/(?P<image_id>\d+)/result/(?P<result_id>\d+)/$', 'api.smoke.api_result'),
-    url(r'^sru/$', 'sru.overview', name='sru'),
-    url(r'^sru/(?P<release>\w+)/$', 'sru.overview', name='sru_overview'),
-    url(r'^sru/(?P<release>\w+)/version/(?P<kernel_version>[^/]+)/$', 'sru.overview_kernel', name='sru_overview_kernel'),
-    url(r'^api/sru/$', 'sru.api_overview'),
-    url(r'^api/sru/(?P<release>\w+)/$', 'sru.api_overview'),
-    url(r'^api/sru/(?P<release>\w+)/(?P<version>[^/]+)/$', 'sru.api_overview'),
-    url(r'^api/help/$', 'api.api_help', name='api_help'),
-)
-    
+    url(r'^api/help/$', 'api_help', name='api_help'),
+)
+
+urlpatterns += patterns('smoke.views',
+    url(r'^smoke/(?P<release>\w+)/$', 'overview', name='smoke_overview'),
+    url(r'^smoke/(?P<release>\w+)/flat/$', 'overview', dict(is_flat=True), name='flat'),
+    url(r'^smoke/(?P<release>\w+)/run/(?P<run_id>\d+)/$', 'build_overview', name='build_overview'),
+    url(r'^smoke/(?P<release>\w+)/run/(?P<run_id>\d+)/pie/$', 'build_pie', name='build_pie'),
+    url(r'^smoke/(?P<release>\w+)/run/(?P<run_id>\d+)/image/(?P<image_id>\d+)/$', 'results', name='smoke_results'),
+    url(r'^smoke/(?P<release>\w+)/run/(?P<run_id>\d+)/image/(?P<image_id>\d+)/pie/$', 'results_pie', name='results_pie'),
+    url(r'^smoke/(?P<release>\w+)/run/(?P<run_id>\d+)/image/(?P<image_id>\d+)/logs/(?P<result_id>\d+)/$', 'results_logs', name='results_logs'),
+)
+
+urlpatterns += patterns('smoke.api',
+    url(r'^api/stats/$', 'api_stats'),
+    url(r'^api/stats/(?P<release>\w+)/$', 'api_stats'),
+    url(r'^api/smoke/(?P<release>\w+)/run/$', 'api_runs'),
+    url(r'^api/smoke/run/$', 'api_runs'),
+    url(r'^api/smoke/run/(?P<run_id>\d+)/$', 'api_run'),
+    url(r'^api/smoke/run/(?P<run_id>\d+)/image/$', 'api_images'),
+    url(r'^api/smoke/run/(?P<run_id>\d+)/image/(?P<image_id>\d+)/$', 'api_image'),
+    url(r'^api/smoke/run/(?P<run_id>\d+)/image/(?P<image_id>\d+)/result/$', 'api_results'),
+    url(r'^api/smoke/run/(?P<run_id>\d+)/image/(?P<image_id>\d+)/result/(?P<result_id>\d+)/$', 'api_result'),
+)
+
+urlpatterns += patterns('sru.views',
+    url(r'^sru/$', 'overview', name='sru'),
+    url(r'^sru/(?P<release>\w+)/$', 'overview', name='sru_overview'),
+    url(r'^sru/(?P<release>\w+)/version/(?P<kernel_version>[^/]+)/$', 'overview_kernel', name='sru_overview_kernel'),
+)
 urlpatterns += patterns('bootspeed.views',
     url(r'^bootspeed/$', 'arch_overview', name='bootspeed_arch'),
     url(r'^bootspeed/arch/(?P<arch>\w+)/$', 'arch_overview', name='bootspeed_arch_overview'),

=== added directory 'smoke'
=== renamed file 'dashboard/NOTES' => 'smoke/NOTES'
=== renamed file 'dashboard/__init__.py' => 'smoke/__init__.py'
=== renamed file 'dashboard/views/api/smoke.py' => 'smoke/api.py'
--- dashboard/views/api/smoke.py	2012-12-13 02:03:19 +0000
+++ smoke/api.py	2012-12-20 01:49:23 +0000
@@ -23,7 +23,6 @@
 
 from dashboard.forms import (
         ResultSmokeAddForm,
-        ResultKernelSRUAddForm,
         BugForm,
         )
 
@@ -35,7 +34,7 @@
         ResultLog,
         )
 
-from dashboard.utils import (
+from common.utils import (
         get_smoke_data,
         JSONResponse,
         MySerializer,

=== renamed file 'dashboard/forms.py' => 'smoke/forms.py'
--- dashboard/forms.py	2012-12-05 22:05:06 +0000
+++ smoke/forms.py	2012-12-20 01:49:23 +0000
@@ -24,21 +24,6 @@
         model = Result
         fields = ['name']
 
-class ResultKernelSRUAddForm(forms.Form):
-    build_no = forms.CharField(max_length=200)
-    job_type = forms.CharField(max_length=200)
-    flavor = forms.CharField(max_length=200)
-    release = forms.CharField(max_length=200)
-    variant = forms.CharField(max_length=200)
-    arch = forms.CharField(max_length=200)
-    version = forms.CharField(max_length=200)
-    build_name = forms.CharField(max_length=200)
-    ran_at = forms.DateTimeField()
-
-    pass_count = forms.IntegerField()
-    fail_count = forms.IntegerField()
-    skip_count = forms.IntegerField()
-
 class ResultSmokeAddForm(forms.Form):
     # Needed for Run class
     build_no = forms.CharField(max_length=200)

=== renamed directory 'dashboard/management' => 'smoke/management'
=== modified file 'smoke/management/__init__.py'
--- dashboard/management/__init__.py	2012-12-02 02:51:10 +0000
+++ smoke/management/__init__.py	2012-12-20 01:49:23 +0000
@@ -12,31 +12,3 @@
 
 # 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 json
-import urllib2
-
-BUILD_COUNT_MAX=20 # XXX: DEBUG
-JOB_COUNT_MAX=20 # XXX: DEBUG
-DEBUG_LIMITS=False
-
-def jenkins_get(loc, as_json=True):
-    req = urllib2.Request(loc)
-    response = ''
-    try_count = 0
-
-    while try_count < 5:
-        try:
-            f = urllib2.urlopen(req)
-            response = f.read()
-            f.close()
-            break
-        except urllib2.HTTPError:
-            try_count += 1
-        except urllib2.URLError as e:
-            try_count += 1
-
-    if response != '' and as_json:
-        return json.loads(response)
-    else:
-        return response

=== modified file 'smoke/management/commands/jenkins_pull.py'
--- dashboard/management/commands/jenkins_pull.py	2012-12-14 15:36:30 +0000
+++ smoke/management/commands/jenkins_pull.py	2012-12-20 01:49:23 +0000
@@ -24,27 +24,27 @@
 
 from optparse import make_option
 
-from dashboard.models import (
+from smoke.models import (
         Bug,
         Build,
         Result,
         ResultLog,
         Run,
         )
-from dashboard.management import (
+from common.helpers import (
         jenkins_get,
         BUILD_COUNT_MAX,
         JOB_COUNT_MAX,
         DEBUG_LIMITS,
         )
 
-from dashboard.utah_utils import process_smoke_log
+from smoke.utah_utils import process_smoke_log
 
 #l = logging.getLogger('django.db.backends')
 #l.setLevel(logging.DEBUG)
 #l.addHandler(logging.StreamHandler())
 
-from dashboard.utils import regexes
+from common.utils import regexes
 
 def _get_utah_logs(artifacts):
     """

=== added directory 'smoke/migrations'
=== added file 'smoke/migrations/0001_create_smoke_app.py'
--- smoke/migrations/0001_create_smoke_app.py	1970-01-01 00:00:00 +0000
+++ smoke/migrations/0001_create_smoke_app.py	2012-12-20 01:49:23 +0000
@@ -0,0 +1,184 @@
+# -*- 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 'Bug'
+        db.create_table('bugs', (
+            ('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)),
+            ('bug_no', self.gf('django.db.models.fields.CharField')(max_length=255)),
+            ('status', self.gf('django.db.models.fields.CharField')(max_length=255)),
+        ))
+        db.send_create_signal('smoke', ['Bug'])
+
+        # Adding model 'ResultLog'
+        db.create_table('result_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)),
+            ('display_name', self.gf('django.db.models.fields.CharField')(max_length=255, null=True)),
+            ('path', self.gf('django.db.models.fields.TextField')()),
+            ('result', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['smoke.Result'])),
+            ('remote_url', self.gf('django.db.models.fields.URLField')(max_length=200)),
+        ))
+        db.send_create_signal('smoke', ['ResultLog'])
+
+        # Adding model 'Run'
+        db.create_table('runs', (
+            ('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)),
+            ('build_no', self.gf('django.db.models.fields.CharField')(max_length=200, db_index=True)),
+            ('release', self.gf('django.db.models.fields.CharField')(max_length=200, db_index=True)),
+            ('flavor', self.gf('django.db.models.fields.CharField')(max_length=200, db_index=True)),
+            ('test_type', self.gf('django.db.models.fields.IntegerField')(null=True)),
+            ('ran_at', self.gf('django.db.models.fields.DateTimeField')()),
+        ))
+        db.send_create_signal('smoke', ['Run'])
+
+        # Adding model 'Build'
+        db.create_table('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)),
+            ('run', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['smoke.Run'])),
+            ('name', self.gf('django.db.models.fields.CharField')(max_length=200, null=True)),
+            ('flavor', 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)),
+        ))
+        db.send_create_signal('smoke', ['Build'])
+
+        # Adding model 'Result'
+        db.create_table('results', (
+            ('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)),
+            ('build', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['smoke.Build'])),
+            ('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
+            ('jenkins_build', self.gf('django.db.models.fields.CharField')(max_length=255)),
+            ('jenkins_url', self.gf('django.db.models.fields.URLField')(max_length=200)),
+            ('fail_count', self.gf('django.db.models.fields.IntegerField')()),
+            ('error_count', self.gf('django.db.models.fields.IntegerField')(default=0)),
+            ('pass_count', self.gf('django.db.models.fields.IntegerField')()),
+            ('total_count', self.gf('django.db.models.fields.IntegerField')()),
+            ('ran_at', self.gf('django.db.models.fields.DateTimeField')()),
+        ))
+        db.send_create_signal('smoke', ['Result'])
+
+        # Adding M2M table for field bugs on 'Result'
+        db.create_table('results_bugs', (
+            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
+            ('result', models.ForeignKey(orm['smoke.result'], null=False)),
+            ('bug', models.ForeignKey(orm['smoke.bug'], null=False))
+        ))
+        db.create_unique('results_bugs', ['result_id', 'bug_id'])
+
+
+    def backwards(self, orm):
+        # Deleting model 'Bug'
+        db.delete_table('bugs')
+
+        # Deleting model 'ResultLog'
+        db.delete_table('result_logs')
+
+        # Deleting model 'Run'
+        db.delete_table('runs')
+
+        # Deleting model 'Build'
+        db.delete_table('builds')
+
+        # Deleting model 'Result'
+        db.delete_table('results')
+
+        # Removing M2M table for field bugs on 'Result'
+        db.delete_table('results_bugs')
+
+
+    models = {
+        'smoke.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'})
+        },
+        'smoke.build': {
+            'Meta': {'object_name': 'Build', 'db_table': "'builds'"},
+            'arch': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
+            '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': '200', 'null': 'True'}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'run': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['smoke.Run']"}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
+            'variant': ('django.db.models.fields.CharField', [], {'max_length': '200'})
+        },
+        'smoke.result': {
+            'Meta': {'object_name': 'Result', 'db_table': "'results'"},
+            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['smoke.Bug']", 'symmetrical': 'False'}),
+            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['smoke.Build']"}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'error_count': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
+            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
+            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
+            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
+            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
+            'total_count': ('django.db.models.fields.IntegerField', [], {}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        },
+        'smoke.resultlog': {
+            'Meta': {'object_name': 'ResultLog', 'db_table': "'result_logs'"},
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'path': ('django.db.models.fields.TextField', [], {}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
+            'result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['smoke.Result']"}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        },
+        'smoke.run': {
+            'Meta': {'object_name': 'Run', 'db_table': "'runs'"},
+            'build_no': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': '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'}),
+            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
+            'release': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
+            'test_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        }
+    }
+
+    complete_apps = ['smoke']
\ No newline at end of file

=== added file 'smoke/migrations/0002_remove_bug_model.py'
--- smoke/migrations/0002_remove_bug_model.py	1970-01-01 00:00:00 +0000
+++ smoke/migrations/0002_remove_bug_model.py	2012-12-20 01:49:23 +0000
@@ -0,0 +1,98 @@
+# -*- 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):
+        # Deleting model 'Bug'
+        db.delete_table('bugs')
+
+
+    def backwards(self, orm):
+        # Adding model 'Bug'
+        db.create_table('bugs', (
+            ('status', self.gf('django.db.models.fields.CharField')(max_length=255)),
+            ('internal', self.gf('django.db.models.fields.BooleanField')(default=True)),
+            ('updated_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
+            ('bug_no', self.gf('django.db.models.fields.CharField')(max_length=255)),
+            ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
+            ('publish', self.gf('django.db.models.fields.BooleanField')(default=True)),
+            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+        ))
+        db.send_create_signal('smoke', ['Bug'])
+
+
+    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'})
+        },
+        'smoke.build': {
+            'Meta': {'object_name': 'Build', 'db_table': "'builds'"},
+            'arch': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
+            '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': '200', 'null': 'True'}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'run': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['smoke.Run']"}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
+            'variant': ('django.db.models.fields.CharField', [], {'max_length': '200'})
+        },
+        'smoke.result': {
+            'Meta': {'object_name': 'Result', 'db_table': "'results'"},
+            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['common.Bug']", 'symmetrical': 'False'}),
+            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['smoke.Build']"}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'error_count': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
+            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
+            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
+            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
+            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
+            'total_count': ('django.db.models.fields.IntegerField', [], {}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        },
+        'smoke.resultlog': {
+            'Meta': {'object_name': 'ResultLog', 'db_table': "'result_logs'"},
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'path': ('django.db.models.fields.TextField', [], {}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
+            'result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['smoke.Result']"}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        },
+        'smoke.run': {
+            'Meta': {'object_name': 'Run', 'db_table': "'runs'"},
+            'build_no': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'flavor': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': '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'}),
+            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
+            'release': ('django.db.models.fields.CharField', [], {'max_length': '200', 'db_index': 'True'}),
+            'test_type': ('django.db.models.fields.IntegerField', [], {'null': 'True'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        }
+    }
+
+    complete_apps = ['smoke']
\ No newline at end of file

=== added file 'smoke/migrations/__init__.py'
=== renamed file 'dashboard/models.py' => 'smoke/models.py'
--- dashboard/models.py	2012-12-06 20:00:30 +0000
+++ smoke/models.py	2012-12-20 01:49:23 +0000
@@ -16,40 +16,9 @@
 from django.db import models
 import datetime
 
-class DashboardBaseModel(models.Model):
-    """
-    Common base class that provides fields needed on every model.
-    """
-    class Meta:
-        abstract = True
-
-    created_at    = models.DateTimeField(auto_now_add = True)
-    updated_at    = models.DateTimeField(auto_now = True)
-    internal      = models.BooleanField(default=True)
-    publish       = models.BooleanField(default=True)
-
-class Bug(DashboardBaseModel):
-    class Meta:
-        db_table = 'bugs'
-    bug_no        = models.CharField(max_length=255)
-    status        = models.CharField(max_length=255)
-
-    def __unicode__(self):
-        return self.bug_no
-
-    @property
-    def debug_str(self):
-        return "{}-{}-{}-{}-{}".format(
-                self.id,
-                self.bug_no,
-                self.status,
-                self.created_at,
-                self.updated_at,
-                )
-
-###
-# Smoke
-###
+from common.models import DashboardBaseModel, Bug
+
+
 class ResultLog(DashboardBaseModel):
     class Meta:
         db_table = 'result_logs'
@@ -265,132 +234,3 @@
     @property
     def log_count(self):
         return self.resultlog_set.count()
-
-###
-# Kernel SRU
-###
-
-class Kernel(DashboardBaseModel):
-    class Meta:
-        db_table = "kernels"
-
-    job_type = models.CharField(max_length=100)
-    release = models.CharField(max_length=100)
-    variant = models.CharField(max_length=100)
-    arch = models.CharField(max_length=100)
-    gpu = models.CharField(max_length=100)
-    version = models.CharField(max_length=100)
-
-    # Used by MySerializer to add property fields to the JSON representation
-    # of an instance of this class.
-    extra_fields = [
-            'pass_count',
-            'skip_count',
-            'fail_count',
-            'total_count',
-            'pass_rate',
-            'pass_rate_pct',
-            'bug_count',
-            'log_count',
-            ]
-
-    def debug_str(self):
-        return "{}-{}-{}-{}".format(
-                self.release,
-                self.variant,
-                self.arch,
-                self.gpu,
-                )
-
-    @property
-    def name(self):
-        return "{}-{}".format(self.release, self.variant)
-
-    @property
-    def total_count(self):
-        return self.sruresult_set.aggregate(models.Sum('total_count'))['total_count__sum'] or 0
-
-    @property
-    def pass_count(self):
-        return self.sruresult_set.aggregate(models.Sum('pass_count'))['pass_count__sum'] or 0
-
-    @property
-    def fail_count(self):
-        return self.sruresult_set.aggregate(models.Sum('fail_count'))['fail_count__sum'] or 0
-
-    @property
-    def skip_count(self):
-        return self.sruresult_set.aggregate(models.Sum('skip_count'))['skip_count__sum'] or 0
-
-    @property
-    def pass_rate(self):
-        return self.pass_count*1.0 / self.total_count if self.total_count > 0 else 0
-
-    @property
-    def pass_rate_pct(self):
-        return "%d%%" % int(self.pass_rate*100)
-
-    @property
-    def bug_count(self):
-        return self.sruresult_set.annotate(num_bugs=models.Count('bugs')).aggregate(models.Sum('num_bugs'))['num_bugs__sum'] or 0
-
-    @property
-    def log_count(self):
-        return self.sruresultlog_set.count()
-
-    @property
-    def last_run_date(self):
-        return self.sruresult_set.aggregate(models.Max('ran_at'))['ran_at__max'].strftime("%Y-%m-%d %H:%M")
-
-# XXX: refactor this and Result
-class SRUResult(DashboardBaseModel):
-    class Meta:
-        db_table = 'sru_results'
-
-    kernel = models.ForeignKey(Kernel)
-    bugs = models.ManyToManyField(Bug)
-
-    jenkins_build = models.CharField(max_length=255)
-    jenkins_url = models.URLField()
-    name = models.CharField(max_length=255)
-    pass_count = models.IntegerField()
-    fail_count = models.IntegerField()
-    skip_count = models.IntegerField()
-    total_count = models.IntegerField()
-    ran_at = models.DateTimeField('date run')
-
-    # Used by MySerializer to add property fields to the JSON representation
-    # of an instance of this class.
-    extra_fields = [
-            'pass_rate',
-            'pass_rate_pct',
-            'bug_count',
-            'log_count',
-            ]
-
-    @property
-    def pass_rate(self):
-        return self.pass_count*1.0 / self.total_count if self.total_count > 0 else 0
-
-    @property
-    def pass_rate_pct(self):
-        return "%d%%" % int(self.pass_rate*100)
-
-    @property
-    def bug_count(self):
-        return self.bugs.count()
-
-    @property
-    def log_count(self):
-        return self.resultlog_set.count()
-
-class SRUResultLog(DashboardBaseModel):
-    class Meta:
-        db_table = 'sru_result_logs'
-    display_name = models.CharField(max_length=255, null = True)
-    path = models.TextField() 
-    sru_result = models.ForeignKey('SRUResult')
-    remote_url = models.URLField()
-
-    def __unicode__(self):
-        return self.path

=== renamed directory 'dashboard/templates' => 'smoke/templates'
=== renamed directory 'dashboard/templatetags' => 'smoke/templatetags'
=== renamed file 'dashboard/tests.py' => 'smoke/tests.py'
=== renamed file 'dashboard/utah_parser.py' => 'smoke/utah_parser.py'
--- dashboard/utah_parser.py	2012-12-13 23:48:40 +0000
+++ smoke/utah_parser.py	2012-12-20 01:49:23 +0000
@@ -1,3 +1,18 @@
+# QA Dashboard
+# Copyright 2012 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 Client log parser."""
 import argparse
 import urllib2

=== renamed file 'dashboard/utah_utils.py' => 'smoke/utah_utils.py'
--- dashboard/utah_utils.py	2012-12-14 14:02:04 +0000
+++ smoke/utah_utils.py	2012-12-20 01:49:23 +0000
@@ -19,8 +19,8 @@
 
 import logging
 
-from dashboard.utah_parser import UTAHParser, ParserError
-from dashboard.models import (
+from smoke.utah_parser import UTAHParser, ParserError
+from smoke.models import (
         Build,
         Run,
         Result,

=== renamed file 'dashboard/views/smoke.py' => 'smoke/views.py'
--- dashboard/views/smoke.py	2012-12-14 23:59:31 +0000
+++ smoke/views.py	2012-12-20 01:49:23 +0000
@@ -41,10 +41,10 @@
 
 from dashboard.forms import (
         ResultSmokeAddForm,
-        ResultKernelSRUAddForm,
         BugForm,
         )
-from dashboard.utils import (
+
+from common.utils import (
         get_smoke_data,
         require_API_TOKEN,
         JSONResponse,

=== added directory 'sru'
=== added file 'sru/__init__.py'
--- sru/__init__.py	1970-01-01 00:00:00 +0000
+++ sru/__init__.py	2012-12-20 01:49:23 +0000
@@ -0,0 +1,14 @@
+# QA Dashboard
+# Copyright 2012 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 'sru/forms.py'
--- sru/forms.py	1970-01-01 00:00:00 +0000
+++ sru/forms.py	2012-12-20 01:49:23 +0000
@@ -0,0 +1,33 @@
+# QA Dashboard
+# Copyright 2012 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/>.
+
+# Make sure field lengths match those in dashboard/models.py
+
+from django import forms
+
+class ResultKernelSRUAddForm(forms.Form):
+    build_no = forms.CharField(max_length=200)
+    job_type = forms.CharField(max_length=200)
+    flavor = forms.CharField(max_length=200)
+    release = forms.CharField(max_length=200)
+    variant = forms.CharField(max_length=200)
+    arch = forms.CharField(max_length=200)
+    version = forms.CharField(max_length=200)
+    build_name = forms.CharField(max_length=200)
+    ran_at = forms.DateTimeField()
+
+    pass_count = forms.IntegerField()
+    fail_count = forms.IntegerField()
+    skip_count = forms.IntegerField()

=== added directory 'sru/management'
=== added file 'sru/management/__init__.py'
--- sru/management/__init__.py	1970-01-01 00:00:00 +0000
+++ sru/management/__init__.py	2012-12-20 01:49:23 +0000
@@ -0,0 +1,14 @@
+# QA Dashboard
+# Copyright 2012 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 'sru/management/commands'
=== added file 'sru/management/commands/__init__.py'
--- sru/management/commands/__init__.py	1970-01-01 00:00:00 +0000
+++ sru/management/commands/__init__.py	2012-12-20 01:49:23 +0000
@@ -0,0 +1,14 @@
+# QA Dashboard
+# Copyright 2012 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/>.

=== renamed file 'dashboard/management/commands/jenkins_pull_sru.py' => 'sru/management/commands/jenkins_pull_sru.py'
--- dashboard/management/commands/jenkins_pull_sru.py	2012-12-14 15:36:30 +0000
+++ sru/management/commands/jenkins_pull_sru.py	2012-12-20 01:49:23 +0000
@@ -19,14 +19,14 @@
 from optparse import make_option
 from django.core.management.base import BaseCommand, CommandError
 
-from dashboard.management import (
+from common.helpers import (
         jenkins_get,
         BUILD_COUNT_MAX,
         JOB_COUNT_MAX,
         DEBUG_LIMITS,
         )
-from dashboard.utils import regexes
-from dashboard.models import (
+from common.utils import regexes
+from sru.models import (
         Kernel,
         SRUResult,
         SRUResultLog,

=== added directory 'sru/migrations'
=== added file 'sru/migrations/0001_create_sru_app.py'
--- sru/migrations/0001_create_sru_app.py	1970-01-01 00:00:00 +0000
+++ sru/migrations/0001_create_sru_app.py	2012-12-20 01:49:23 +0000
@@ -0,0 +1,140 @@
+# -*- 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 'Kernel'
+        db.create_table('kernels', (
+            ('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)),
+            ('job_type', self.gf('django.db.models.fields.CharField')(max_length=100)),
+            ('release', self.gf('django.db.models.fields.CharField')(max_length=100)),
+            ('variant', self.gf('django.db.models.fields.CharField')(max_length=100)),
+            ('arch', self.gf('django.db.models.fields.CharField')(max_length=100)),
+            ('gpu', self.gf('django.db.models.fields.CharField')(max_length=100)),
+            ('version', self.gf('django.db.models.fields.CharField')(max_length=100)),
+        ))
+        db.send_create_signal('sru', ['Kernel'])
+
+        # Adding model 'SRUResult'
+        db.create_table('sru_results', (
+            ('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)),
+            ('kernel', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['sru.Kernel'])),
+            ('jenkins_build', self.gf('django.db.models.fields.CharField')(max_length=255)),
+            ('jenkins_url', self.gf('django.db.models.fields.URLField')(max_length=200)),
+            ('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
+            ('pass_count', self.gf('django.db.models.fields.IntegerField')()),
+            ('fail_count', self.gf('django.db.models.fields.IntegerField')()),
+            ('skip_count', self.gf('django.db.models.fields.IntegerField')()),
+            ('total_count', self.gf('django.db.models.fields.IntegerField')()),
+            ('ran_at', self.gf('django.db.models.fields.DateTimeField')()),
+        ))
+        db.send_create_signal('sru', ['SRUResult'])
+
+        # Adding M2M table for field bugs on 'SRUResult'
+        db.create_table('sru_results_bugs', (
+            ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
+            ('sruresult', models.ForeignKey(orm['sru.sruresult'], null=False)),
+            ('bug', models.ForeignKey(orm['dashboard.bug'], null=False))
+        ))
+        db.create_unique('sru_results_bugs', ['sruresult_id', 'bug_id'])
+
+        # Adding model 'SRUResultLog'
+        db.create_table('sru_result_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)),
+            ('display_name', self.gf('django.db.models.fields.CharField')(max_length=255, null=True)),
+            ('path', self.gf('django.db.models.fields.TextField')()),
+            ('sru_result', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['sru.SRUResult'])),
+            ('remote_url', self.gf('django.db.models.fields.URLField')(max_length=200)),
+        ))
+        db.send_create_signal('sru', ['SRUResultLog'])
+
+
+    def backwards(self, orm):
+        # Deleting model 'Kernel'
+        db.delete_table('kernels')
+
+        # Deleting model 'SRUResult'
+        db.delete_table('sru_results')
+
+        # Removing M2M table for field bugs on 'SRUResult'
+        db.delete_table('sru_results_bugs')
+
+        # Deleting model 'SRUResultLog'
+        db.delete_table('sru_result_logs')
+
+
+    models = {
+        'dashboard.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'})
+        },
+        'sru.kernel': {
+            'Meta': {'object_name': 'Kernel', 'db_table': "'kernels'"},
+            'arch': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'gpu': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'job_type': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'release': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
+            'variant': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
+            'version': ('django.db.models.fields.CharField', [], {'max_length': '100'})
+        },
+        'sru.sruresult': {
+            'Meta': {'object_name': 'SRUResult', 'db_table': "'sru_results'"},
+            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['dashboard.Bug']", 'symmetrical': 'False'}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'fail_count': ('django.db.models.fields.IntegerField', [], {}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'jenkins_build': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
+            'jenkins_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
+            'kernel': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['sru.Kernel']"}),
+            'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
+            'pass_count': ('django.db.models.fields.IntegerField', [], {}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
+            'skip_count': ('django.db.models.fields.IntegerField', [], {}),
+            'total_count': ('django.db.models.fields.IntegerField', [], {}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        },
+        'sru.sruresultlog': {
+            'Meta': {'object_name': 'SRUResultLog', 'db_table': "'sru_result_logs'"},
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True'}),
+            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'path': ('django.db.models.fields.TextField', [], {}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'remote_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
+            'sru_result': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['sru.SRUResult']"}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        }
+    }
+
+    complete_apps = ['sru']
\ No newline at end of file

=== added file 'sru/migrations/__init__.py'
=== added file 'sru/models.py'
--- sru/models.py	1970-01-01 00:00:00 +0000
+++ sru/models.py	2012-12-20 01:49:23 +0000
@@ -0,0 +1,144 @@
+# QA Dashboard
+# Copyright 2012 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
+import datetime
+
+from common.models import DashboardBaseModel, Bug
+
+class Kernel(DashboardBaseModel):
+    class Meta:
+        db_table = "kernels"
+
+    job_type = models.CharField(max_length=100)
+    release = models.CharField(max_length=100)
+    variant = models.CharField(max_length=100)
+    arch = models.CharField(max_length=100)
+    gpu = models.CharField(max_length=100)
+    version = models.CharField(max_length=100)
+
+    # Used by MySerializer to add property fields to the JSON representation
+    # of an instance of this class.
+    extra_fields = [
+            'pass_count',
+            'skip_count',
+            'fail_count',
+            'total_count',
+            'pass_rate',
+            'pass_rate_pct',
+            'bug_count',
+            'log_count',
+            ]
+
+    def debug_str(self):
+        return "{}-{}-{}-{}".format(
+                self.release,
+                self.variant,
+                self.arch,
+                self.gpu,
+                )
+
+    @property
+    def name(self):
+        return "{}-{}".format(self.release, self.variant)
+
+    @property
+    def total_count(self):
+        return self.sruresult_set.aggregate(models.Sum('total_count'))['total_count__sum'] or 0
+
+    @property
+    def pass_count(self):
+        return self.sruresult_set.aggregate(models.Sum('pass_count'))['pass_count__sum'] or 0
+
+    @property
+    def fail_count(self):
+        return self.sruresult_set.aggregate(models.Sum('fail_count'))['fail_count__sum'] or 0
+
+    @property
+    def skip_count(self):
+        return self.sruresult_set.aggregate(models.Sum('skip_count'))['skip_count__sum'] or 0
+
+    @property
+    def pass_rate(self):
+        return self.pass_count*1.0 / self.total_count if self.total_count > 0 else 0
+
+    @property
+    def pass_rate_pct(self):
+        return "%d%%" % int(self.pass_rate*100)
+
+    @property
+    def bug_count(self):
+        return self.sruresult_set.annotate(num_bugs=models.Count('bugs')).aggregate(models.Sum('num_bugs'))['num_bugs__sum'] or 0
+
+    @property
+    def log_count(self):
+        return self.sruresultlog_set.count()
+
+    @property
+    def last_run_date(self):
+        return self.sruresult_set.aggregate(models.Max('ran_at'))['ran_at__max'].strftime("%Y-%m-%d %H:%M")
+
+# XXX: refactor this and Result
+class SRUResult(DashboardBaseModel):
+    class Meta:
+        db_table = 'sru_results'
+
+    kernel = models.ForeignKey(Kernel)
+    bugs = models.ManyToManyField(Bug, related_name='sruresult_bugs')
+
+    jenkins_build = models.CharField(max_length=255)
+    jenkins_url = models.URLField()
+    name = models.CharField(max_length=255)
+    pass_count = models.IntegerField()
+    fail_count = models.IntegerField()
+    skip_count = models.IntegerField()
+    total_count = models.IntegerField()
+    ran_at = models.DateTimeField('date run')
+
+    # Used by MySerializer to add property fields to the JSON representation
+    # of an instance of this class.
+    extra_fields = [
+            'pass_rate',
+            'pass_rate_pct',
+            'bug_count',
+            'log_count',
+            ]
+
+    @property
+    def pass_rate(self):
+        return self.pass_count*1.0 / self.total_count if self.total_count > 0 else 0
+
+    @property
+    def pass_rate_pct(self):
+        return "%d%%" % int(self.pass_rate*100)
+
+    @property
+    def bug_count(self):
+        return self.bugs.count()
+
+    @property
+    def log_count(self):
+        return self.resultlog_set.count()
+
+class SRUResultLog(DashboardBaseModel):
+    class Meta:
+        db_table = 'sru_result_logs'
+    display_name = models.CharField(max_length=255, null = True)
+    path = models.TextField() 
+    sru_result = models.ForeignKey('SRUResult')
+    remote_url = models.URLField()
+
+    def __unicode__(self):
+        return self.path

=== added file 'sru/tests.py'
--- sru/tests.py	1970-01-01 00:00:00 +0000
+++ sru/tests.py	2012-12-20 01:49:23 +0000
@@ -0,0 +1,14 @@
+# QA Dashboard
+# Copyright 2012 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 'sru/views.py'
--- sru/views.py	1970-01-01 00:00:00 +0000
+++ sru/views.py	2012-12-20 01:49:23 +0000
@@ -0,0 +1,142 @@
+# QA Dashboard
+# Copyright 2012 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.shortcuts import render_to_response
+from django.views.decorators.http import require_GET
+from django.db.models import Sum, F
+from django.template import RequestContext
+
+from sru.models import Kernel
+from common.utils import (
+        JSONResponse,
+        MySerializer,
+        get_verbose,
+        )
+
+def _get_kernel_names():
+    kernels = []
+    for kernel in Kernel.objects.values('variant').distinct().exclude(publish=False).order_by('variant'):
+        kernels.append(kernel['variant'])
+
+    return kernels
+
+def _get_kernel_releases():
+    releases = []
+    for kernel in Kernel.objects.values('release').distinct().exclude(publish=False).order_by('-release'):
+        releases.append(kernel['release'])
+
+    return releases
+
+@require_GET
+def api_overview(request, release='', version=''):
+    kernels = Kernel.objects.all()
+
+    if release != '':
+        kernels = kernels.filter(release=release)
+
+    if version != '':
+        kernels = kernels.filter(version=version)
+
+    serializer = MySerializer(use_extra_fields=get_verbose(request, True))
+    data = serializer.serialize(kernels)
+
+    return JSONResponse(data)
+
+@require_GET
+def overview(request, release=''):
+    data = {}
+    data['kernel_names'] = _get_kernel_names()
+    data['releases'] = _get_kernel_releases()
+    data['kernels'] = []
+    data['show_unknown'] = True
+
+    show_unknown = request.GET.get('show_unknown')
+
+    kernels = Kernel.objects.all()
+
+    if show_unknown is None or show_unknown != "1":
+        data['show_unknown'] = False
+        kernels = kernels.exclude(version__startswith="Unknown")
+
+    if release != '':
+        kernels = kernels.filter(release=release)
+
+    kernel_data = {}
+    for kernel in kernels:
+        version = kernel.version
+        if version not in kernel_data:
+            kernel_data[version] = {
+                    'version': version,
+                    'pass_count': 0,
+                    'fail_count': 0,
+                    'skip_count': 0,
+                    'total_count': 0,
+                    'bug_count': 0,
+                    }
+
+        kernel_data[version]['pass_count'] += kernel.pass_count
+        kernel_data[version]['skip_count'] += kernel.skip_count
+        kernel_data[version]['fail_count'] += kernel.fail_count
+        kernel_data[version]['total_count'] += kernel.total_count
+        kernel_data[version]['bug_count'] += kernel.bug_count
+        kernel_data[version]['release'] = kernel.release
+        kernel_data[version]['last_run_date'] = kernel.last_run_date
+
+
+    for k,v in kernel_data.iteritems():
+        if v['total_count'] == 0:
+            v['pass_rate'] = 0
+        else:
+            v['pass_rate'] = v['pass_count'] * 1.0 / v['total_count']
+
+        v['pass_rate_pct'] = "{:<.2%}".format(v['pass_rate'])
+
+        data['kernels'].append(v)
+
+    return render_to_response('sru/overview.html', data, RequestContext(request))
+
+@require_GET
+def overview_kernel(request, release=None, kernel_version=None):
+    kernels = Kernel.objects.filter(version=kernel_version).select_related()
+
+    data = {
+        'kernels': kernels,
+        'kernel_version': kernel_version,
+        'release': release
+    }
+
+    totals = {
+            'skip_count': 0,
+            'pass_count': 0,
+            'fail_count': 0,
+            'total_count': 0,
+            'pass_rate': 0.0,
+            }
+
+    for k in kernels:
+        totals['skip_count'] += k.skip_count
+        totals['pass_count'] += k.pass_count
+        totals['fail_count'] += k.fail_count
+        totals['total_count'] += k.total_count
+
+    if totals['total_count'] == 0:
+        totals['pass_rate'] = 0.0
+    else:
+        totals['pass_rate'] = totals['pass_count'] * 1.0 / totals['total_count']
+    totals['pass_rate_pct'] = "{:.2%}".format(totals['pass_rate'])
+
+    data['totals'] = totals
+
+    return render_to_response('sru/overview_kernel.html', data, RequestContext(request))