Merge lp:~cjohnston/qa-dashboard/bootspeed-max-length into lp:qa-dashboard

[Chris Johnston]

Increase the max_length of bootspeed model fields

[PS Jenkins bot (ps-jenkins)]

PASSED: Continuous integration, rev:645
http://10.97.0.26:8080/job/dashboard-ci/204/
Executed test runs:

Click here to trigger a rebuild:
http://10.97.0.26:8080/job/dashboard-ci/204/rebuild

review: Approve (continuous-integration)

[lp:~cjohnston/qa-dashboard/bootspeed-max-length]

646. By Chris Johnston on 2013-10-22

Fix typo

Unmerged revisions

=== added file 'bootspeed/migrations/0007_increase_max_length.py'
--- bootspeed/migrations/0007_increase_max_length.py	1970-01-01 00:00:00 +0000
+++ bootspeed/migrations/0007_increase_max_length.py	2013-10-21 00:37:55 +0000
@@ -0,0 +1,246 @@
+# -*- 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):
+
+        # Changing field 'Image.build_number'
+        db.alter_column('images', 'build_number', self.gf('django.db.models.fields.CharField')(max_length=4096))
+
+        # Changing field 'Image.image_type'
+        db.alter_column('images', 'image_type', self.gf('django.db.models.fields.CharField')(max_length=4096))
+
+        # Changing field 'Image.variant'
+        db.alter_column('images', 'variant', self.gf('django.db.models.fields.CharField')(max_length=4096))
+
+        # Changing field 'Image.release'
+        db.alter_column('images', 'release', self.gf('django.db.models.fields.CharField')(max_length=4096))
+
+        # Changing field 'Image.arch'
+        db.alter_column('images', 'arch', self.gf('django.db.models.fields.CharField')(max_length=4096))
+
+        # Changing field 'Image.md5'
+        db.alter_column('images', 'md5', self.gf('django.db.models.fields.CharField')(unique=True, max_length=4096))
+
+        # Changing field 'JobImage.build_number'
+        db.alter_column('job_image', 'build_number', self.gf('django.db.models.fields.CharField')(max_length=4096))
+
+        # Changing field 'JobImage.variant'
+        db.alter_column('job_image', 'variant', self.gf('django.db.models.fields.CharField')(max_length=4096))
+
+        # Changing field 'JobImage.release'
+        db.alter_column('job_image', 'release', self.gf('django.db.models.fields.CharField')(max_length=4096))
+
+        # Changing field 'JobImage.arch'
+        db.alter_column('job_image', 'arch', self.gf('django.db.models.fields.CharField')(max_length=4096))
+
+        # Changing field 'ImageResultLog.display_name'
+        db.alter_column('image_result_logs', 'display_name', self.gf('django.db.models.fields.CharField')(max_length=40965, null=True))
+
+        # Changing field 'Machine.name'
+        db.alter_column('machines', 'name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=4096))
+
+        # Changing field 'Machine.mac_address'
+        db.alter_column('machines', 'mac_address', self.gf('django.db.models.fields.CharField')(max_length=4096))
+
+    def backwards(self, orm):
+
+        # Changing field 'Image.build_number'
+        db.alter_column('images', 'build_number', self.gf('django.db.models.fields.CharField')(max_length=50))
+
+        # Changing field 'Image.image_type'
+        db.alter_column('images', 'image_type', self.gf('django.db.models.fields.CharField')(max_length=10))
+
+        # Changing field 'Image.variant'
+        db.alter_column('images', 'variant', self.gf('django.db.models.fields.CharField')(max_length=200))
+
+        # Changing field 'Image.release'
+        db.alter_column('images', 'release', self.gf('django.db.models.fields.CharField')(max_length=200))
+
+        # Changing field 'Image.arch'
+        db.alter_column('images', 'arch', self.gf('django.db.models.fields.CharField')(max_length=200))
+
+        # Changing field 'Image.md5'
+        db.alter_column('images', 'md5', self.gf('django.db.models.fields.CharField')(max_length=200, unique=True))
+
+        # Changing field 'JobImage.build_number'
+        db.alter_column('job_image', 'build_number', self.gf('django.db.models.fields.CharField')(max_length=25))
+
+        # Changing field 'JobImage.variant'
+        db.alter_column('job_image', 'variant', self.gf('django.db.models.fields.CharField')(max_length=100))
+
+        # Changing field 'JobImage.release'
+        db.alter_column('job_image', 'release', self.gf('django.db.models.fields.CharField')(max_length=100))
+
+        # Changing field 'JobImage.arch'
+        db.alter_column('job_image', 'arch', self.gf('django.db.models.fields.CharField')(max_length=25))
+
+        # Changing field 'ImageResultLog.display_name'
+        db.alter_column('image_result_logs', 'display_name', self.gf('django.db.models.fields.CharField')(max_length=255, null=True))
+
+        # Changing field 'Machine.name'
+        db.alter_column('machines', 'name', self.gf('django.db.models.fields.CharField')(max_length=200, unique=True))
+
+        # Changing field 'Machine.mac_address'
+        db.alter_column('machines', 'mac_address', self.gf('django.db.models.fields.CharField')(max_length=200))
+
+    models = {
+        u'bootspeed.image': {
+            'Meta': {'unique_together': "(('release', 'variant', 'arch', 'build_number'),)", 'object_name': 'Image', 'db_table': "'images'"},
+            'arch': ('django.db.models.fields.CharField', [], {'max_length': '4096'}),
+            'build_number': ('django.db.models.fields.CharField', [], {'max_length': '4096'}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'image_type': ('django.db.models.fields.CharField', [], {'default': "u'daily'", 'max_length': '4096'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'md5': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '4096'}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'release': ('django.db.models.fields.CharField', [], {'max_length': '4096'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
+            'variant': ('django.db.models.fields.CharField', [], {'max_length': '4096'})
+        },
+        u'bootspeed.imagebuild': {
+            'Meta': {'object_name': 'ImageBuild', 'db_table': "'image_builds'"},
+            'build': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['common.JenkinsBuild']"}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'job_image': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['bootspeed.JobImage']"}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        },
+        u'bootspeed.imagemachineagg': {
+            'Meta': {'object_name': 'ImageMachineAgg', 'db_table': "'image_machine_agg'"},
+            'boot_avg': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'boot_max': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'boot_min': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'boot_std': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'desktop_avg': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'desktop_max': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'desktop_min': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'desktop_std': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'image': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['bootspeed.Image']"}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'kernel_avg': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'kernel_init_avg': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'kernel_init_max': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'kernel_init_min': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'kernel_init_std': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'kernel_max': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'kernel_min': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'kernel_std': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'machine': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['bootspeed.Machine']"}),
+            'plumbing_avg': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'plumbing_max': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'plumbing_min': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'plumbing_std': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
+            'xorg_avg': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'xorg_max': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'xorg_min': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'xorg_plumbing_avg': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'xorg_plumbing_max': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'xorg_plumbing_min': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'xorg_plumbing_std': ('django.db.models.fields.FloatField', [], {'default': '0'}),
+            'xorg_std': ('django.db.models.fields.FloatField', [], {'default': '0'})
+        },
+        u'bootspeed.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', [], {}),
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'image': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['bootspeed.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': u"orm['bootspeed.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', [], {})
+        },
+        u'bootspeed.imageresultlog': {
+            'Meta': {'object_name': 'ImageResultLog', 'db_table': "'image_result_logs'"},
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'display_name': ('django.db.models.fields.CharField', [], {'max_length': '40965', 'null': 'True'}),
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'image_result': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['bootspeed.ImageResult']"}),
+            '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'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        },
+        u'bootspeed.jobimage': {
+            'Meta': {'object_name': 'JobImage', 'db_table': "'job_image'"},
+            'arch': ('django.db.models.fields.CharField', [], {'max_length': '4096'}),
+            'build_number': ('django.db.models.fields.CharField', [], {'max_length': '4096'}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            u'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': '4096'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
+            'variant': ('django.db.models.fields.CharField', [], {'max_length': '4096'})
+        },
+        u'bootspeed.machine': {
+            'Meta': {'object_name': 'Machine', 'db_table': "'machines'"},
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            u'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': '4096'}),
+            'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '4096'}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        },
+        u'common.bug': {
+            'Meta': {'object_name': 'Bug', 'db_table': "'bugs'"},
+            'assignee': ('django.db.models.fields.CharField', [], {'max_length': '4096', 'null': 'True'}),
+            'bug_no': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'importance': ('django.db.models.fields.CharField', [], {'default': "u'unknown'", 'max_length': '4096'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'project': ('django.db.models.fields.CharField', [], {'max_length': '4096', 'null': 'True'}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'status': ('django.db.models.fields.CharField', [], {'default': "u'unknown'", 'max_length': '4096'}),
+            'title': ('django.db.models.fields.CharField', [], {'max_length': '4096', 'null': 'True'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        },
+        u'common.jenkinsbuild': {
+            'Meta': {'unique_together': "(('job', 'build_number'),)", 'object_name': 'JenkinsBuild', 'db_table': "'jenkins_builds'"},
+            'bugs': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'build_bugs'", 'symmetrical': 'False', 'to': u"orm['common.Bug']"}),
+            'build_description': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '1024'}),
+            'build_number': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            'failed': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'job': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['common.JenkinsJob']"}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'ran_at': ('django.db.models.fields.DateTimeField', [], {}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'})
+        },
+        u'common.jenkinsjob': {
+            'Meta': {'object_name': 'JenkinsJob', 'db_table': "'jenkins_jobs'"},
+            'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'internal': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '200'}),
+            'publish': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
+            'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
+            'url': ('django.db.models.fields.URLField', [], {'max_length': '200'})
+        }
+    }
+
+    complete_apps = ['bootspeed']
\ No newline at end of file

=== modified file 'bootspeed/models.py'
--- bootspeed/models.py	2013-08-09 03:20:35 +0000
+++ bootspeed/models.py	2013-10-21 00:37:55 +0000
@@ -35,13 +35,13 @@
         db_table = 'images'
         unique_together = ('release', 'variant', 'arch', 'build_number')
 
-    release = models.CharField(max_length=200)
-    variant = models.CharField(max_length=200)
-    arch = models.CharField(max_length=200)
-    md5 = models.CharField(max_length=200, unique=True)
-    build_number = models.CharField(max_length=50)
+    release = models.CharField(max_length=4096)
+    variant = models.CharField(max_length=4096)
+    arch = models.CharField(max_length=4096)
+    md5 = models.CharField(max_length=4096, unique=True)
+    build_number = models.CharField(max_length=4096)
     image_type = models.CharField(
-        max_length=10,
+        max_length=4096,
         choices=TYPE_CHOICES,
         default=TYPE_CHOICES[0][0]
     )
@@ -141,8 +141,8 @@
 class Machine(DashboardBaseModel):
     class Meta:
         db_table = 'machines'
-    name = models.CharField(max_length=200, unique=True)
-    mac_address = models.CharField(max_length=200)
+    name = models.CharField(max_length=4096, unique=True)
+    mac_address = models.CharField(max_length=4096)
 
     # Used by MySerializer to add property fields to the JSON representation
     # of an instance of this class.
@@ -436,7 +436,7 @@
     class Meta:
         db_table = "image_result_logs"
 
-    display_name = models.CharField(max_length=255, null=True)
+    display_name = models.CharField(max_length=40965, null=True)
     path = models.TextField()
     image_result = models.ForeignKey(ImageResult)
     remote_url = models.URLField()
@@ -451,10 +451,10 @@
     class Meta:
         db_table = "job_image"
 
-    build_number = models.CharField(max_length=25)
-    arch = models.CharField(max_length=25)
-    release = models.CharField(max_length=100)
-    variant = models.CharField(max_length=100)
+    build_number = models.CharField(max_length=4096)
+    arch = models.CharField(max_length=4096)
+    release = models.CharField(max_length=4096)
+    variant = models.CharField(max_length=4096)
 
     def __unicode__(self):
         return "{}-{}-{}-{}".format(