summaryrefslogtreecommitdiff
path: root/isotests/models.py
blob: d9cfc78c4d6214bfd82f4a9f7483040d57168205 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
from django.db import models
from django.db.models import Max
from datetime import datetime

# Create your models here.
class Iso(models.Model):
    date = models.DateField()

    def __unicode__(self):
        return str(self.date)

class Architecture(models.Model):
    name = models.CharField(max_length=200)

    def __unicode__(self):
        return self.name

    def get_success_test(self):
        return self.test_set.filter(success=True).aggregate(Max('iso__date'))['iso__date__max']
    def get_failed_test(self):
        return self.test_set.filter(success=False).aggregate(Max('iso__date'))['iso__date__max']

class Isotype(models.Model):
    name = models.CharField(max_length=200)

    def __unicode__(self):
        return self.name
    def get_success_test(self):
        return self.test_set.filter(success=True).aggregate(Max('iso__date'))['iso__date__max']
    def get_failed_test(self):
        return self.test_set.filter(success=False).aggregate(Max('iso__date'))['iso__date__max']

class Boottype(models.Model):
    name = models.CharField(max_length=200)

    def __unicode__(self):
        return self.name
    def get_success_test(self):
        return self.test_set.filter(success=True).aggregate(Max('iso__date'))['iso__date__max']
    def get_failed_test(self):
        return self.test_set.filter(success=False).aggregate(Max('iso__date'))['iso__date__max']

class Hardware(models.Model):
    name = models.CharField(max_length=200)

    def __unicode__(self):
        return self.name
    def get_success_test(self):
        return self.test_set.filter(success=True).aggregate(Max('iso__date'))['iso__date__max']
    def get_failed_test(self):
        return self.test_set.filter(success=False).aggregate(Max('iso__date'))['iso__date__max']

class InstallType(models.Model):
    name = models.CharField(max_length=200)

    def __unicode__(self):
        return self.name
    def get_success_test(self):
        return self.test_set.filter(success=True).aggregate(Max('iso__date'))['iso__date__max']
    def get_failed_test(self):
        return self.test_set.filter(success=False).aggregate(Max('iso__date'))['iso__date__max']

class Source(models.Model):
    name = models.CharField(max_length=200)

    def __unicode__(self):
        return self.name
    def get_success_test(self):
        return self.test_set.filter(success=True).aggregate(Max('iso__date'))['iso__date__max']
    def get_failed_test(self):
        return self.test_set.filter(success=False).aggregate(Max('iso__date'))['iso__date__max']

class Clockchoice(models.Model):
    name = models.CharField(max_length=200)

    def __unicode__(self):
        return self.name
    def get_success_test(self):
        return self.test_set.filter(success=True).aggregate(Max('iso__date'))['iso__date__max']
    def get_failed_test(self):
        return self.test_set.filter(success=False).aggregate(Max('iso__date'))['iso__date__max']

class Filesystem(models.Model):
    name = models.CharField(max_length=200)

    def __unicode__(self):
        return self.name
    def get_success_test(self):
        return self.test_set.filter(success=True).aggregate(Max('iso__date'))['iso__date__max']
    def get_failed_test(self):
        return self.test_set.filter(success=False).aggregate(Max('iso__date'))['iso__date__max']

class Module(models.Model):
    name = models.CharField(max_length=200)

    def __unicode__(self):
        return self.name
    def get_success_test(self):
        return self.test_set.filter(success=True).aggregate(Max('iso__date'))['iso__date__max']
    def get_failed_test(self):
        return self.test_set.filter(success=False).aggregate(Max('iso__date'))['iso__date__max']

class Bootloader(models.Model):
    name = models.CharField(max_length=200)

    def __unicode__(self):
        return self.name
    def get_success_test(self):
        return self.test_set.filter(success=True).aggregate(Max('iso__date'))['iso__date__max']
    def get_failed_test(self):
        return self.test_set.filter(success=False).aggregate(Max('iso__date'))['iso__date__max']

class Test(models.Model):
    user_name = models.CharField(max_length=500)
    user_email = models.EmailField()
    iso = models.ForeignKey(Iso)
    arch = models.ForeignKey(Architecture)
    isotype = models.ForeignKey(Isotype)
    boottype = models.ForeignKey(Boottype)
    hardwaretype = models.ForeignKey(Hardware)
    installtype = models.ForeignKey(InstallType)
    source = models.ForeignKey(Source)
    clock = models.ForeignKey(Clockchoice)
    filesystem = models.ForeignKey(Filesystem)
    ms = models.ManyToManyField(Module, null=True, blank=True)
    rollback = models.BooleanField()
    rollback_filesystem = models.ForeignKey(Filesystem,
            related_name="rollback_test", null=True, blank=True)
    rollback_modules = models.ManyToManyField(Module,
            related_name="rollback_test", null=True, blank=True)
    bootloader = models.ForeignKey(Bootloader)
    success = models.BooleanField()
    comments = models.TextField(null=True, blank=True)