Merge lp:~cjohnston/ubuntu-ci-services-itself/ts-ticket-models into lp:ubuntu-ci-services-itself

[Chris Johnston]

Add ticket related models to the ticket system

[Andy Doan (doanac)]

On 12/10/2013 01:23 PM, Chris Johnston wrote:
> Chris Johnston has proposed merging lp:~cjohnston/ubuntu-ci-services-itself/ts-ticket-models into lp:ubuntu-ci-services-itself.

> === added file 'ticket_system/ticket/models.py'

> +class Ticket(models.Model):
> + class Meta:
> + db_table = 'ticket'
> +
> + WORKFLOW_STEPS = (
> + ("PACKAGE_BUILDING", "Package building"),
> + ("IMAGE_BUILDING", "Image building"),
> + ("IMAGE_TESTING", "Image testing"),
> + ("PACKAGE_PUBLISHING", "Package publishing"),
> + )
> + WORKFLOW_STEP_STATUSES = (
> + ("PKG_BUILD_WAITING", "Not started"),
> + ("PKG_BUILD_INPROGRESS", "In progress"),
> + ("PKG_BUILD_DONE", "Completed"),
> + ("PKG_BUILD_FAILED", "Failed"),
> + ("IMAGE_BUILD_WAITING", "Not started"),
> + ("IMAGE_BUILD_INPROGRESS", "In progress"),
> + ("IMAGE_BUILD_DONE", "Completed"),
> + ("IMAGE_BUILD_FAILED", "Failed"),
> + ("IMAGE_TESTS_WAITING", "Not started"),
> + ("IMAGE_TESTS_INPROGRESS", "In progress"),
> + ("IMAGE_TESTS_PASSED", "Passed"),
> + ("IMAGE_TESTS_FAILED", "Failed"),
> + ("PKG_PUBLISHING_DONE", "Completed"),
> + ("PKG_PUBLISHING_FAILED", "Failed"),
> + )

> + current_workflow_step = models.CharField(choices=WORKFLOW_STEPS,
> + max_length=4096)
> + status = models.CharField(choices=WORKFLOW_STEP_STATUSES,
> + max_length=4096)

Would it make sense to use models.IntegerField and change these values
from strings to integers. I think that would then allow you do
eventually have logic like:

  if ticket.status < Ticket.IMAGE_BUILD_DONE:
      print("No image available for ticket")

I'd define these status as multiples of 10 like:
   PKG_BUILD_WAITING = 0
   PKG_BUILD_INPROGRESS = 10

because I could forsee a day when we might need new steps in the process.

> +class SourcePackageUpload(models.Model):
> + class Meta:
> + db_table = 'sourcepackageupload'
> +
> + sourcepackage = models.ForeignKey(SourcePackage)
> + version = models.CharField(max_length=4096)
> +
> + def __unicode__(self):
> + return "{} {}".format(self.sourcepackage, self.version)
> +
> +
> +class SubTicket(models.Model):
> + class Meta:
> + db_table = 'subticket'
> +
> + WORKFLOW_STEPS = (
> + ("WAITING", "Not started"),
> + ("PACKAGE_BUILDING", "Package building"),
> + ("COMPLETE", "Completed"),
> + )
> + WORKFLOW_STEP_STATUSES = (
> + ("PKG_BUILD_WAITING", "Not started"),
> + ("PKG_BUILD_INPROGRESS", "In progress"),
> + ("PKG_BUILD_DONE", "Completed"),
> + ("PKG_BUILD_FAILED", "Failed"),
> + )

same point about integer field here.

> + assignee = models.ForeignKey(Person)

I assume we want subtickets to be able to have different owners than the
main ticket?

> + sourcepackageupload = models.ForeignKey(SourcePackageUpload)

> +class Artifact(models.Model):

> + ticket_component = models.ForeignKey(SubTicket, blank=True, null=True)
> + sourcepackageupload = models.ForeignKey(
> + SourcePacka...

[Chris Johnston (cjohnston)]

On Tue, Dec 10, 2013 at 4:09 PM, Andy Doan <email address hidden>wrote:

> > + assignee = models.ForeignKey(Person)
>
> I assume we want subtickets to be able to have different owners than the
> main ticket?
>
>
Yes. If there are multiple people working on different parts of a ticket.
This is probably more for the future, but no sense in not adding it now.

> + sourcepackageupload = models.ForeignKey(SourcePackageUpload)
>
> > +class Artifact(models.Model):
>
> > + ticket_component = models.ForeignKey(SubTicket, blank=True,
> null=True)
> > + sourcepackageupload = models.ForeignKey(
> > + SourcePackageUpload, null=True, blank=True,
> > + verbose_name='Source Package Upload')
>
> This feels like we might not have a relation defined properly. It seems
> like an Artifact shouldn't need the "ticket_component" attribute. I
> think a SubTicket has a SourcePackageUpload which has artifacts. So
> adding this ticket_component here feels like something isn't properly
> normalized. I'm not sure the intent but it seems like it should be one
> of these options:
>
> = 1 ======
> You add to SourcePackageUpload:
> subticket = models.ForeignKey(SubTicket)
>
> Remove the the "ticket_component" attribute from Artifact.
>
> The drawback here, is that a SubTicket could have more than
> SourcePackageUploads. Maybe a OneToOneField is needed instead?
>
> = 2 =====
>
> You don't need a SourcePackage upload class. You just make
> "source_package" and "source_package_version" as attributes to
> SubTicket. Then Arfifact just has a foreign key to SubTicket.
>
> = 3 =====
>
> This is already correct, and I'm missing something.
>

An artifact can be two different things. When you upload a source package
at the initial time of creating a ticket, it is an artifact (it needs to be
stored somewhere, and we need to be able to tell other parts of the CI
engine where to look for the source package). As the system goes through
and does things, there (I assume) will be output files (logs and such,
maybe videos when using autopilot, etc). These things don't belong to a
package upload, they belong to a ticket. So, your artifact can either be
the source package or an output artifact from the CI engine.

[Andy Doan (doanac)]

On 12/10/2013 03:18 PM, Chris Johnston wrote:
> An artifact can be two different things. When you upload a source package
> at the initial time of creating a ticket, it is an artifact (it needs to be
> stored somewhere, and we need to be able to tell other parts of the CI
> engine where to look for the source package). As the system goes through
> and does things, there (I assume) will be output files (logs and such,
> maybe videos when using autopilot, etc). These things don't belong to a
> package upload, they belong to a ticket. So, your artifact can either be
> the source package or an output artifact from the CI engine.

So I think this means you don't want/need the
Artifact.soucepackageupload attribute.

If you wanted to know the source package uploads for a subticket you
could still get them with:

  subticket = <something>
  uploads = Artifact.objects.filter(
      ticket_component=subticket, type=Artfifact.SPU)

[Chris Johnston (cjohnston)]

review: Needs Resubmitting

[Chris Johnston (cjohnston)]

Made changes to the choices fields and made them Integers

review: Needs Resubmitting

[Andy Doan (doanac)]

The "COMPLETE = 001" feels odd. We've got a set of increasing values except for this one value? Seems like COMPLETE in this case would be the biggest value? Also, be careful with padding things with 0's. Thats actual octal 1 which just happens to be 1. But if you did "010" you'd actually have 8 in base 10. Maybe reversing the order of the constants would make the COMPLETE thing nice where COMPLETE = 0 and WAITING = 500.

264 +WAITING = 000
265 +PACKAGE_BUILDING = 100
268 +PACKAGE_PUBLISHING = 400
269 +COMPLETE = 001
270 +PKG_BUILD_WAITING = 110

Last note is just styling - you can take it or leave it. Having all these constants defined outside the Ticket class means modules will have to do an akward import like:

 import ticket_system.models as models
 models.Ticket.objects.filter(status=models.WAITING)

Where if they instead were in the Ticket class you could do:

 from ticket_system.models import Ticket
 Ticket.objects.filter(status=Ticket.WAITING)

[Andy Doan (doanac)]

Now to understand SubTicket.sourcepackageupload.

1) why do we not use underscores here?

2) To confirm our relationships:

 a) a SubTicket _has_ a SourcePackageUpload
 b) a SourcePackageUpload can have many Artifacts

is this correct?

[Francis Ginther (fginther)]

> 2) To confirm our relationships:
>
> a) a SubTicket _has_ a SourcePackageUpload
> b) a SourcePackageUpload can have many Artifacts
>
> is this correct?

That is correct. A ticket corresponds to a build request, which could contain one or more source packages. A subticket would be associated with each source package. A source package contains multiple files to upload (a .dsc, a orig.tar.gz, etc).

[Andy Doan (doanac)]

On 12/10/2013 10:25 PM, Francis Ginther wrote:
>> 2) To confirm our relationships:
>>
>> a) a SubTicket _has_ a SourcePackageUpload
>> b) a SourcePackageUpload can have many Artifacts
>>
>> is this correct?
>
> That is correct. A ticket corresponds to a build request, which could contain one or more source packages. A subticket would be associated with each source package. A source package contains multiple files to upload (a .dsc, a orig.tar.gz, etc).

Awesome. I'm +1 for the model in general now. Still have my concerns
about the status codes.

[lp:~cjohnston/ubuntu-ci-services-itself/ts-ticket-models]

24. By Chris Johnston on 2013-12-11

change constants per review

25. By Chris Johnston on 2013-12-11

Fix tests

[Chris Johnston (cjohnston)]

review: Needs Resubmitting

[Ursula Junque (ursinha)]

Hey Chris, only a few notes:

322 + (COMPLETED, "COMPLETED"),

I think this label should be "Completed".

456 +def create_ticket(title="This is my ticket",
457 + description="this is my ticket description",
458 + bug_id='12345', owner='Chris Johnston',
459 + current_workflow_step=200,
460 + status=220, base_image='17'):

Can we use the constants here (and other places that refer to it) instead of the integer, like Ticket.PKG_BUILDING, Ticket.PKG_BUILDING_INPROGRESS?

I think it looks good for now. If we detect these workflow steps/statuses aren't precise enough we can easily add more of them.

[lp:~cjohnston/ubuntu-ci-services-itself/ts-ticket-models]

26. By Chris Johnston on 2013-12-11

Test changes per review

[Andy Doan (doanac)]

review: Approve

=== modified file 'ticket_system/people/__init__.py'
--- ticket_system/people/__init__.py	2013-12-09 17:43:12 +0000
+++ ticket_system/people/__init__.py	2013-12-11 18:03:47 +0000
@@ -1,4 +1,3 @@
-# Houston
 # Ubuntu Continuous Integration Engine
 # Copyright 2013 Canonical Ltd.
 

=== modified file 'ticket_system/people/admin.py'
--- ticket_system/people/admin.py	2013-12-09 17:43:12 +0000
+++ ticket_system/people/admin.py	2013-12-11 18:03:47 +0000
@@ -1,4 +1,3 @@
-# Houston
 # Ubuntu Continuous Integration Engine
 # Copyright 2013 Canonical Ltd.
 

=== modified file 'ticket_system/people/api.py'
--- ticket_system/people/api.py	2013-12-09 17:43:12 +0000
+++ ticket_system/people/api.py	2013-12-11 18:03:47 +0000
@@ -1,4 +1,3 @@
-# Houston
 # Ubuntu Continuous Integration Engine
 # Copyright 2013 Canonical Ltd.
 

=== modified file 'ticket_system/people/models.py'
--- ticket_system/people/models.py	2013-12-09 18:57:54 +0000
+++ ticket_system/people/models.py	2013-12-11 18:03:47 +0000
@@ -1,4 +1,3 @@
-# Houston
 # Ubuntu Continuous Integration Engine
 # Copyright 2013 Canonical Ltd.
 

=== modified file 'ticket_system/people/tests.py'
--- ticket_system/people/tests.py	2013-12-10 18:34:08 +0000
+++ ticket_system/people/tests.py	2013-12-11 18:03:47 +0000
@@ -1,4 +1,3 @@
-# Houston
 # Ubuntu Continuous Integration Engine
 # Copyright 2013 Canonical Ltd.
 

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

=== added file 'ticket_system/ticket/admin.py'
--- ticket_system/ticket/admin.py	1970-01-01 00:00:00 +0000
+++ ticket_system/ticket/admin.py	2013-12-11 18:03:47 +0000
@@ -0,0 +1,45 @@
+# Ubuntu Continuous Integration Engine
+# Copyright 2013 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
+from django.contrib import admin
+from ticket.models import Ticket, SubTicket, SourcePackageUpload, Artifact
+
+
+class TicketAdmin(admin.ModelAdmin):
+    list_filter = ['current_workflow_step', 'status']
+    search_fields = ['title', 'bug_id']
+    list_display = ('title', 'current_workflow_step', 'status', 'base_image')
+
+
+class SubTicketAdmin(admin.ModelAdmin):
+    list_filter = ['status']
+    search_fields = ['ticket', 'sourcepackageupload']
+    list_display = ('ticket', 'status', 'assignee', 'sourcepackageupload')
+
+
+class SourcePackageUploadAdmin(admin.ModelAdmin):
+    search_fields = ['sourcepackage']
+    list_display = ('sourcepackage', 'version')
+
+
+class ArtifactAdmin(admin.ModelAdmin):
+    list_filter = ['type']
+    search_fields = ['name']
+    list_display = ('name', 'ticket_component', 'type')
+
+admin.site.register(Ticket, TicketAdmin)
+admin.site.register(SubTicket, SubTicketAdmin)
+admin.site.register(SourcePackageUpload, SourcePackageUploadAdmin)
+admin.site.register(Artifact, ArtifactAdmin)

=== added directory 'ticket_system/ticket/migrations'
=== added file 'ticket_system/ticket/migrations/0001_initial.py'
--- ticket_system/ticket/migrations/0001_initial.py	1970-01-01 00:00:00 +0000
+++ ticket_system/ticket/migrations/0001_initial.py	2013-12-11 18:03:47 +0000
@@ -0,0 +1,117 @@
+# -*- 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 'Ticket'
+        db.create_table('ticket', (
+            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('owner', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['people.Person'])),
+            ('title', self.gf('django.db.models.fields.CharField')(max_length=4096)),
+            ('description', self.gf('django.db.models.fields.TextField')()),
+            ('bug_id', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),
+            ('current_workflow_step', self.gf('django.db.models.fields.IntegerField')(default=0, max_length=4096)),
+            ('status', self.gf('django.db.models.fields.IntegerField')(default=0, max_length=4096)),
+            ('base_image', self.gf('django.db.models.fields.CharField')(max_length=4096)),
+        ))
+        db.send_create_signal(u'ticket', ['Ticket'])
+
+        # Adding model 'SourcePackageUpload'
+        db.create_table('sourcepackageupload', (
+            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('sourcepackage', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['project.SourcePackage'])),
+            ('version', self.gf('django.db.models.fields.CharField')(max_length=4096)),
+        ))
+        db.send_create_signal(u'ticket', ['SourcePackageUpload'])
+
+        # Adding model 'SubTicket'
+        db.create_table('subticket', (
+            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('current_workflow_step', self.gf('django.db.models.fields.IntegerField')(default=0, max_length=4096)),
+            ('status', self.gf('django.db.models.fields.IntegerField')(default=0, max_length=4096)),
+            ('ticket', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['ticket.Ticket'])),
+            ('assignee', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['people.Person'])),
+            ('source_package_upload', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['ticket.SourcePackageUpload'])),
+        ))
+        db.send_create_signal(u'ticket', ['SubTicket'])
+
+        # Adding model 'Artifact'
+        db.create_table('artifact', (
+            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('type', self.gf('django.db.models.fields.CharField')(max_length=4096)),
+            ('ticket_component', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['ticket.SubTicket'], null=True, blank=True)),
+            ('reference', self.gf('django.db.models.fields.CharField')(max_length=4096)),
+            ('name', self.gf('django.db.models.fields.CharField')(max_length=4096)),
+        ))
+        db.send_create_signal(u'ticket', ['Artifact'])
+
+
+    def backwards(self, orm):
+        # Deleting model 'Ticket'
+        db.delete_table('ticket')
+
+        # Deleting model 'SourcePackageUpload'
+        db.delete_table('sourcepackageupload')
+
+        # Deleting model 'SubTicket'
+        db.delete_table('subticket')
+
+        # Deleting model 'Artifact'
+        db.delete_table('artifact')
+
+
+    models = {
+        u'people.person': {
+            'Meta': {'object_name': 'Person', 'db_table': "'person'"},
+            'email': ('django.db.models.fields.EmailField', [], {'max_length': '4096'}),
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'is_team': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
+            'name': ('django.db.models.fields.CharField', [], {'max_length': '4096'})
+        },
+        u'project.sourcepackage': {
+            'Meta': {'object_name': 'SourcePackage', 'db_table': "'sourcepackage'"},
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'name': ('django.db.models.fields.CharField', [], {'max_length': '4096'})
+        },
+        u'ticket.artifact': {
+            'Meta': {'object_name': 'Artifact', 'db_table': "'artifact'"},
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'name': ('django.db.models.fields.CharField', [], {'max_length': '4096'}),
+            'reference': ('django.db.models.fields.CharField', [], {'max_length': '4096'}),
+            'ticket_component': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['ticket.SubTicket']", 'null': 'True', 'blank': 'True'}),
+            'type': ('django.db.models.fields.CharField', [], {'max_length': '4096'})
+        },
+        u'ticket.sourcepackageupload': {
+            'Meta': {'object_name': 'SourcePackageUpload', 'db_table': "'sourcepackageupload'"},
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'sourcepackage': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['project.SourcePackage']"}),
+            'version': ('django.db.models.fields.CharField', [], {'max_length': '4096'})
+        },
+        u'ticket.subticket': {
+            'Meta': {'object_name': 'SubTicket', 'db_table': "'subticket'"},
+            'assignee': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['people.Person']"}),
+            'current_workflow_step': ('django.db.models.fields.IntegerField', [], {'default': '0', 'max_length': '4096'}),
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'source_package_upload': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['ticket.SourcePackageUpload']"}),
+            'status': ('django.db.models.fields.IntegerField', [], {'default': '0', 'max_length': '4096'}),
+            'ticket': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['ticket.Ticket']"})
+        },
+        u'ticket.ticket': {
+            'Meta': {'object_name': 'Ticket', 'db_table': "'ticket'"},
+            'base_image': ('django.db.models.fields.CharField', [], {'max_length': '4096'}),
+            'bug_id': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
+            'current_workflow_step': ('django.db.models.fields.IntegerField', [], {'default': '0', 'max_length': '4096'}),
+            'description': ('django.db.models.fields.TextField', [], {}),
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['people.Person']"}),
+            'status': ('django.db.models.fields.IntegerField', [], {'default': '0', 'max_length': '4096'}),
+            'title': ('django.db.models.fields.CharField', [], {'max_length': '4096'})
+        }
+    }
+
+    complete_apps = ['ticket']
\ No newline at end of file

=== added file 'ticket_system/ticket/migrations/__init__.py'
=== added file 'ticket_system/ticket/models.py'
--- ticket_system/ticket/models.py	1970-01-01 00:00:00 +0000
+++ ticket_system/ticket/models.py	2013-12-11 18:03:47 +0000
@@ -0,0 +1,162 @@
+# Ubuntu Continuous Integration Engine
+# Copyright 2013 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
+from django.db import models
+from people.models import Person
+from project.models import SourcePackage
+
+
+class Ticket(models.Model):
+    class Meta:
+        db_table = 'ticket'
+
+    NEW = 000
+    QUEUED = 100
+    PENDING = 110
+    COMPLETED = 1000
+
+    PKG_BUILDING = 200
+    PKG_BUILDING_WAITING = 210
+    PKG_BUILDING_INPROGRESS = 220
+    PKG_BUILDING_COMPLETED = 230
+    PKG_BUILDING_FAILED = 240
+
+    IMAGE_BUILDING = 300
+    IMAGE_BUILDING_WAITING = 310
+    IMAGE_BUILDING_INPROGRESS = 320
+    IMAGE_BUILDING_COMPLETED = 330
+    IMAGE_BUILDING_FAILED = 340
+
+    IMAGE_TESTING = 400
+    IMAGE_TESTING_WAITING = 410
+    IMAGE_TESTING_INPROGRESS = 420
+    IMAGE_TESTING_PASSED = 430
+    IMAGE_TESTING_FAILED = 440
+
+    PKG_PUBLISHING = 500
+    PKG_PUBLISHING_COMPLETED = 510
+    PKG_PUBLISHING_FAILED = 520
+
+    WORKFLOW_STEPS = (
+        (NEW, "New"),
+        (QUEUED, "Queued"),
+        (PKG_BUILDING, "Package building"),
+        (IMAGE_BUILDING, "Image building"),
+        (IMAGE_TESTING, "Image testing"),
+        (PKG_PUBLISHING, "Package publishing"),
+        (COMPLETED, "Completed"),
+    )
+    WORKFLOW_STEP_STATUSES = (
+        (NEW, "New"),
+        (PENDING, "Not started"),
+        (PKG_BUILDING_WAITING, "Not started"),
+        (PKG_BUILDING_INPROGRESS, "In progress"),
+        (PKG_BUILDING_COMPLETED, "Completed"),
+        (PKG_BUILDING_FAILED, "Failed"),
+        (IMAGE_BUILDING_WAITING, "Not started"),
+        (IMAGE_BUILDING_INPROGRESS, "In progress"),
+        (IMAGE_BUILDING_COMPLETED, "Completed"),
+        (IMAGE_BUILDING_FAILED, "Failed"),
+        (IMAGE_TESTING_WAITING, "Not started"),
+        (IMAGE_TESTING_INPROGRESS, "In progress"),
+        (IMAGE_TESTING_PASSED, "Passed"),
+        (IMAGE_TESTING_FAILED, "Failed"),
+        (PKG_PUBLISHING_COMPLETED, "Completed"),
+        (PKG_PUBLISHING_FAILED, "Failed"),
+        (COMPLETED, "Completed"),
+    )
+    owner = models.ForeignKey(Person)
+    title = models.CharField(max_length=4096)
+    description = models.TextField()
+    bug_id = models.IntegerField(null=True, blank=True)
+    current_workflow_step = models.IntegerField(choices=WORKFLOW_STEPS,
+                                                max_length=4096, default=000)
+    status = models.IntegerField(choices=WORKFLOW_STEP_STATUSES,
+                                 max_length=4096, default=000)
+    base_image = models.CharField(max_length=4096)
+
+    def __unicode__(self):
+        return self.title
+
+
+class SourcePackageUpload(models.Model):
+    class Meta:
+        db_table = 'sourcepackageupload'
+
+    sourcepackage = models.ForeignKey(SourcePackage)
+    version = models.CharField(max_length=4096)
+
+    def __unicode__(self):
+        return "{} {}".format(self.sourcepackage, self.version)
+
+
+class SubTicket(models.Model):
+    class Meta:
+        db_table = 'subticket'
+
+    NEW = 000
+    QUEUED = 100
+    PENDING = 110
+    COMPLETED = 1000
+
+    PKG_BUILDING = 200
+    PKG_BUILDING_WAITING = 210
+    PKG_BUILDING_INPROGRESS = 220
+    PKG_BUILDING_COMPLETED = 230
+    PKG_BUILDING_FAILED = 240
+
+    WORKFLOW_STEPS = (
+        (NEW, "New"),
+        (QUEUED, "Queued"),
+        (PKG_BUILDING, "Package building"),
+        (COMPLETED, "Completed"),
+    )
+    WORKFLOW_STEP_STATUSES = (
+        (NEW, "New"),
+        (QUEUED, "Queued"),
+        (PKG_BUILDING_WAITING, "Not started"),
+        (PKG_BUILDING_INPROGRESS, "In progress"),
+        (PKG_BUILDING_COMPLETED, "Completed"),
+        (PKG_BUILDING_FAILED, "Failed"),
+    )
+    current_workflow_step = models.IntegerField(choices=WORKFLOW_STEPS,
+                                                max_length=4096, default=000)
+    status = models.IntegerField(choices=WORKFLOW_STEP_STATUSES,
+                                 max_length=4096, default=000)
+    ticket = models.ForeignKey(Ticket)
+    assignee = models.ForeignKey(Person)
+    source_package_upload = models.ForeignKey(SourcePackageUpload)
+
+    def __unicode__(self):
+        return "{} {}".format(self.ticket, self.sourcepackageupload)
+
+
+class Artifact(models.Model):
+    class Meta:
+        db_table = 'artifact'
+
+    ARTIFACT_TYPE = (
+        ('RESULTS', 'Test Results'),
+        ('SPU', 'Source Package Upload'),
+        ('LOGS', 'Logs'),
+    )
+    type = models.CharField(choices=ARTIFACT_TYPE, max_length=4096)
+    ticket_component = models.ForeignKey(SubTicket, blank=True, null=True)
+    # 'reference' provided by the artifact manager
+    reference = models.CharField(max_length=4096)
+    name = models.CharField(max_length=4096)
+
+    def __unicode__(self):
+        return "{} {}".format(self.name, self.type)

=== added file 'ticket_system/ticket/tests.py'
--- ticket_system/ticket/tests.py	1970-01-01 00:00:00 +0000
+++ ticket_system/ticket/tests.py	2013-12-11 18:03:47 +0000
@@ -0,0 +1,131 @@
+# Ubuntu Continuous Integration Engine
+# Copyright 2013 Canonical Ltd.
+
+# This program is free software: you can redistribute it and/or modify it
+# under the terms of the GNU Affero General Public License version 3, as
+# published by the Free Software Foundation.
+
+# This program is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranties of
+# MERCHANTABILITY, SATISFACTORY QUALITY, or FITNESS FOR A PARTICULAR
+# PURPOSE.  See the GNU Affero General Public License for more details.
+
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+
+from django.test import TestCase
+from people.models import Person
+from project.models import SourcePackage
+from ticket.models import Ticket, SubTicket, SourcePackageUpload, Artifact
+
+
+def create_person(name='Chris Johnston', email='[e-mail]'):
+    person = Person()
+    person.name = name
+    person.email = email
+    person.save()
+    return person
+
+
+def create_sourcepackage(name='my-package'):
+    sourcepackage = SourcePackage()
+    sourcepackage.name = name
+    sourcepackage.save()
+    return sourcepackage
+
+
+def create_sourcepackageupload(sourcepackage='my-package', version='1.1'):
+    spu = SourcePackageUpload()
+    spu.sourcepackage = sourcepackage
+    spu.version = version
+    spu.save()
+    return spu
+
+
+def create_ticket(title="This is my ticket",
+                  description="this is my ticket description",
+                  bug_id='12345', owner='Chris Johnston',
+                  current_workflow_step=Ticket.PKG_BUILDING,
+                  status=Ticket.PKG_BUILDING_INPROGRESS, base_image='17'):
+    ticket = Ticket()
+    ticket.owner = owner
+    ticket.title = title
+    ticket.description = description
+    ticket.bug_id = bug_id
+    ticket.current_workflow_step = current_workflow_step
+    ticket.status = status
+    ticket.base_image = base_image
+    ticket.save()
+    return ticket
+
+
+def create_subticket(current_workflow_step=SubTicket.PKG_BUILDING, ticket=None,
+                     status=SubTicket.PKG_BUILDING_INPROGRESS,
+                     assignee='Chris Johnston',
+                     source_package_upload=None):
+    subticket = SubTicket()
+    subticket.current_workflow_step = current_workflow_step
+    subticket.status = status
+    subticket.ticket = ticket
+    subticket.assignee = assignee
+    subticket.source_package_upload = source_package_upload
+    subticket.save()
+    return subticket
+
+
+def create_artifact(name="test.log", ticket_component=None,
+                    reference='123abc'):
+    artifact = Artifact()
+    artifact.name = name
+    artifact.ticket_component = ticket_component
+    artifact.reference = reference
+    artifact.save()
+    return artifact
+
+
+class TicketModelsTestCase(TestCase):
+    def setUp(self):
+        self.person = create_person()
+        self.sourcepackage = create_sourcepackage()
+        self.spu = create_sourcepackageupload(
+            sourcepackage=self.sourcepackage)
+        self.ticket = create_ticket(owner=self.person)
+        self.subticket = create_subticket(ticket=self.ticket,
+                                          assignee=self.person,
+                                          source_package_upload=self.spu)
+        self.artifact_1 = create_artifact(ticket_component=self.subticket)
+
+    def test_creating_an_artifact(self):
+        artifact_in_database = Artifact.objects.exclude(
+            ticket_component=None)
+        self.assertEquals(len(artifact_in_database), 1)
+        only_artifact_in_database = artifact_in_database[0]
+        self.assertEquals(only_artifact_in_database, self.artifact_1)
+
+        self.assertEquals(only_artifact_in_database.name, "test.log")
+
+    def test_creating_a_ticket(self):
+        ticket_in_database = Ticket.objects.all()
+        self.assertEquals(len(ticket_in_database), 1)
+        only_ticket_in_database = ticket_in_database[0]
+        self.assertEquals(only_ticket_in_database, self.ticket)
+
+        self.assertEquals(only_ticket_in_database.title, "This is my ticket")
+
+    def test_creating_a_subticket(self):
+        subticket_in_database = SubTicket.objects.all()
+        self.assertEquals(len(subticket_in_database), 1)
+        only_subticket_in_database = subticket_in_database[0]
+        self.assertEquals(only_subticket_in_database, self.subticket)
+
+        self.assertEquals(only_subticket_in_database.assignee.name,
+                          "Chris Johnston")
+
+    def test_creating_a_sourcepackageupload(self):
+        spu_in_database = SourcePackageUpload.objects.all()
+        self.assertEquals(len(spu_in_database), 1)
+        only_spu_in_database = spu_in_database[0]
+        self.assertEquals(only_spu_in_database, self.spu)
+
+        self.assertEquals(only_spu_in_database.sourcepackage.name,
+                          "my-package")

=== modified file 'ticket_system/ticket_system/local_tests.py'
--- ticket_system/ticket_system/local_tests.py	2013-12-09 17:29:57 +0000
+++ ticket_system/ticket_system/local_tests.py	2013-12-11 18:03:47 +0000
@@ -1,4 +1,3 @@
-# Houston
 # Ubuntu Continuous Integration Engine
 # Copyright 2013 Canonical Ltd.
 

=== modified file 'ticket_system/ticket_system/settings.py'
--- ticket_system/ticket_system/settings.py	2013-12-09 19:35:22 +0000
+++ ticket_system/ticket_system/settings.py	2013-12-11 18:03:47 +0000
@@ -141,6 +141,7 @@
 LOCAL_APPS = (
     'people',
     'project',
+    'ticket',
 )
 
 INSTALLED_APPS = LOCAL_APPS + INSTALLED_APPS