mbligh | 9bb92fe | 2007-09-12 15:54:23 +0000 | [diff] [blame] | 1 | #!/usr/bin/python |
mbligh | 2aaeb67 | 2007-10-01 14:54:18 +0000 | [diff] [blame] | 2 | import os, re, db, sys |
mbligh | 9bb92fe | 2007-09-12 15:54:23 +0000 | [diff] [blame] | 3 | |
mbligh | 2aaeb67 | 2007-10-01 14:54:18 +0000 | [diff] [blame] | 4 | tko = os.path.dirname(os.path.realpath(os.path.abspath(sys.argv[0]))) |
| 5 | root_url_file = os.path.join(tko, '.root_url') |
| 6 | if os.path.exists(root_url_file): |
| 7 | html_root = open(root_url_file, 'r').readline().rstrip() |
| 8 | else: |
mbligh | c959f4f | 2007-10-25 14:47:17 +0000 | [diff] [blame] | 9 | html_root = '/results/' |
mbligh | 2aaeb67 | 2007-10-01 14:54:18 +0000 | [diff] [blame] | 10 | |
| 11 | |
mbligh | cff2d21 | 2007-10-07 00:11:10 +0000 | [diff] [blame] | 12 | class group: |
| 13 | @classmethod |
| 14 | def select(klass, db): |
| 15 | """Return all possible machine groups""" |
| 16 | rows = db.select('distinct machine_group', 'machines', |
| 17 | 'machine_group is not null') |
| 18 | groupnames = sorted([row[0] for row in rows]) |
| 19 | return [klass(db, groupname) for groupname in groupnames] |
| 20 | |
| 21 | |
| 22 | def __init__(self, db, name): |
| 23 | self.name = name |
| 24 | self.db = db |
| 25 | |
| 26 | |
| 27 | def machines(self): |
| 28 | return machine.select(self.db, { 'machine_group' : self.name }) |
| 29 | |
| 30 | |
| 31 | def tests(self, where = {}): |
| 32 | values = [self.name] |
| 33 | sql = 't inner join machines m on m.machine_idx=t.machine_idx where m.machine_group=%s' |
| 34 | for key in where.keys(): |
| 35 | sql += ' and %s=%%s' % key |
| 36 | values.append(where[key]) |
| 37 | return test.select_sql(self.db, sql, values) |
| 38 | |
| 39 | |
mbligh | 2aaeb67 | 2007-10-01 14:54:18 +0000 | [diff] [blame] | 40 | class machine: |
| 41 | @classmethod |
| 42 | def select(klass, db, where = {}): |
| 43 | fields = ['machine_idx', 'hostname', 'machine_group', 'owner'] |
| 44 | machines = [] |
| 45 | for row in db.select(','.join(fields), 'machines', where): |
| 46 | machines.append(klass(db, *row)) |
| 47 | return machines |
| 48 | |
| 49 | |
| 50 | def __init__(self, db, idx, hostname, group, owner): |
| 51 | self.db = db |
| 52 | self.idx = idx |
| 53 | self.hostname = hostname |
| 54 | self.group = group |
| 55 | self.owner = owner |
| 56 | |
mbligh | 250300e | 2007-09-18 00:50:57 +0000 | [diff] [blame] | 57 | |
mbligh | 9bb92fe | 2007-09-12 15:54:23 +0000 | [diff] [blame] | 58 | class kernel: |
mbligh | 8e1ab17 | 2007-09-13 17:29:56 +0000 | [diff] [blame] | 59 | @classmethod |
| 60 | def select(klass, db, where = {}): |
| 61 | fields = ['kernel_idx', 'kernel_hash', 'base', 'printable'] |
| 62 | kernels = [] |
| 63 | for row in db.select(','.join(fields), 'kernels', where): |
| 64 | kernels.append(klass(db, *row)) |
| 65 | return kernels |
mbligh | 9bb92fe | 2007-09-12 15:54:23 +0000 | [diff] [blame] | 66 | |
mbligh | 8e1ab17 | 2007-09-13 17:29:56 +0000 | [diff] [blame] | 67 | |
| 68 | def __init__(self, db, idx, hash, base, printable): |
mbligh | 9bb92fe | 2007-09-12 15:54:23 +0000 | [diff] [blame] | 69 | self.db = db |
mbligh | 8e1ab17 | 2007-09-13 17:29:56 +0000 | [diff] [blame] | 70 | self.idx = idx |
mbligh | 9bb92fe | 2007-09-12 15:54:23 +0000 | [diff] [blame] | 71 | self.hash = hash |
mbligh | 8e1ab17 | 2007-09-13 17:29:56 +0000 | [diff] [blame] | 72 | self.base = base |
| 73 | self.printable = printable |
| 74 | self.patches = [] # THIS SHOULD PULL IN PATCHES! |
mbligh | 9bb92fe | 2007-09-12 15:54:23 +0000 | [diff] [blame] | 75 | |
| 76 | |
| 77 | class test: |
mbligh | 8e1ab17 | 2007-09-13 17:29:56 +0000 | [diff] [blame] | 78 | @classmethod |
mbligh | 31d29c4 | 2007-09-27 00:51:33 +0000 | [diff] [blame] | 79 | def select(klass, db, where = {}, distinct = False): |
mbligh | 8e1ab17 | 2007-09-13 17:29:56 +0000 | [diff] [blame] | 80 | fields = ['test_idx', 'job_idx', 'test', 'subdir', |
mbligh | 2aaeb67 | 2007-10-01 14:54:18 +0000 | [diff] [blame] | 81 | 'kernel_idx', 'status', 'reason', 'machine_idx'] |
mbligh | 8e1ab17 | 2007-09-13 17:29:56 +0000 | [diff] [blame] | 82 | tests = [] |
mbligh | 31d29c4 | 2007-09-27 00:51:33 +0000 | [diff] [blame] | 83 | for row in db.select(','.join(fields), 'tests', where, distinct): |
mbligh | 8e1ab17 | 2007-09-13 17:29:56 +0000 | [diff] [blame] | 84 | tests.append(klass(db, *row)) |
| 85 | return tests |
| 86 | |
| 87 | |
mbligh | 414c69e | 2007-10-05 15:13:06 +0000 | [diff] [blame] | 88 | @classmethod |
| 89 | def select_sql(klass, db, sql, values): |
| 90 | fields = ['test_idx', 'job_idx', 'test', 'subdir', |
| 91 | 'kernel_idx', 'status', 'reason', 'machine_idx'] |
| 92 | fields = ['t.'+field for field in fields] |
| 93 | rows = db.select_sql(','.join(fields), 'tests', sql, values) |
| 94 | return [klass(db, *row) for row in rows] |
| 95 | |
| 96 | |
mbligh | 2aaeb67 | 2007-10-01 14:54:18 +0000 | [diff] [blame] | 97 | def __init__(self, db, test_idx, job_idx, testname, subdir, kernel_idx, status_num, reason, machine_idx): |
mbligh | 8e1ab17 | 2007-09-13 17:29:56 +0000 | [diff] [blame] | 98 | self.idx = test_idx |
mbligh | 250300e | 2007-09-18 00:50:57 +0000 | [diff] [blame] | 99 | self.job = job(db, job_idx) |
mbligh | de7335d | 2007-09-26 16:53:20 +0000 | [diff] [blame] | 100 | self.testname = testname |
mbligh | 8e1ab17 | 2007-09-13 17:29:56 +0000 | [diff] [blame] | 101 | self.subdir = subdir |
mbligh | 50a2525 | 2007-09-27 15:26:17 +0000 | [diff] [blame] | 102 | self.kernel_idx = kernel_idx |
| 103 | self.__kernel = None |
| 104 | self.__iterations = None |
mbligh | 2aaeb67 | 2007-10-01 14:54:18 +0000 | [diff] [blame] | 105 | self.machine_idx = machine_idx |
| 106 | self.__machine = None |
mbligh | 8e1ab17 | 2007-09-13 17:29:56 +0000 | [diff] [blame] | 107 | self.status_num = status_num |
| 108 | self.status_word = db.status_word[status_num] |
mbligh | 9bb92fe | 2007-09-12 15:54:23 +0000 | [diff] [blame] | 109 | self.reason = reason |
mbligh | 50a2525 | 2007-09-27 15:26:17 +0000 | [diff] [blame] | 110 | self.db = db |
mbligh | de7335d | 2007-09-26 16:53:20 +0000 | [diff] [blame] | 111 | if self.subdir: |
| 112 | self.url = html_root + self.job.tag + '/' + self.subdir |
| 113 | else: |
mbligh | 676510c | 2007-09-28 01:28:12 +0000 | [diff] [blame] | 114 | self.url = None |
mbligh | 16ae926 | 2007-09-21 00:53:08 +0000 | [diff] [blame] | 115 | |
mbligh | 50a2525 | 2007-09-27 15:26:17 +0000 | [diff] [blame] | 116 | |
| 117 | |
| 118 | def iterations(self): |
| 119 | """ |
| 120 | Caching function for iterations |
| 121 | """ |
| 122 | if not self.__iterations: |
| 123 | self.__iterations = {} |
| 124 | # A dictionary - dict{key} = [value1, value2, ....] |
| 125 | where = {'test_idx' : self.idx} |
| 126 | for i in iteration.select(self.db, where): |
| 127 | if self.__iterations.has_key(i.key): |
| 128 | self.__iterations[i.key].append(i.value) |
| 129 | else: |
| 130 | self.__iterations[i.key] = [i.value] |
| 131 | return self.__iterations |
| 132 | |
| 133 | |
| 134 | def kernel(self): |
| 135 | """ |
| 136 | Caching function for kernels |
| 137 | """ |
| 138 | if not self.__kernel: |
| 139 | where = {'kernel_idx' : self.kernel_idx} |
| 140 | self.__kernel = kernel.select(self.db, where)[0] |
| 141 | return self.__kernel |
| 142 | |
mbligh | 250300e | 2007-09-18 00:50:57 +0000 | [diff] [blame] | 143 | |
mbligh | 2aaeb67 | 2007-10-01 14:54:18 +0000 | [diff] [blame] | 144 | def machine(self): |
| 145 | """ |
| 146 | Caching function for kernels |
| 147 | """ |
| 148 | if not self.__machine: |
| 149 | where = {'machine_idx' : self.machine_idx} |
| 150 | self.__machine = machine.select(self.db, where)[0] |
| 151 | return self.__machine |
| 152 | |
| 153 | |
mbligh | 250300e | 2007-09-18 00:50:57 +0000 | [diff] [blame] | 154 | class job: |
| 155 | def __init__(self, db, job_idx): |
| 156 | where = {'job_idx' : job_idx} |
mbligh | 2aaeb67 | 2007-10-01 14:54:18 +0000 | [diff] [blame] | 157 | rows = db.select('tag, machine_idx', 'jobs', where) |
mbligh | 250300e | 2007-09-18 00:50:57 +0000 | [diff] [blame] | 158 | if not rows: |
| 159 | return None |
mbligh | 2aaeb67 | 2007-10-01 14:54:18 +0000 | [diff] [blame] | 160 | (self.tag, self.machine_idx) = rows[0] |
mbligh | 250300e | 2007-09-18 00:50:57 +0000 | [diff] [blame] | 161 | |
mbligh | 8e1ab17 | 2007-09-13 17:29:56 +0000 | [diff] [blame] | 162 | |
mbligh | 16ae926 | 2007-09-21 00:53:08 +0000 | [diff] [blame] | 163 | class iteration: |
| 164 | @classmethod |
| 165 | def select(klass, db, where): |
| 166 | fields = ['iteration', 'attribute', 'value'] |
| 167 | iterations = [] |
| 168 | rows = db.select(','.join(fields), 'iteration_result', where) |
| 169 | for row in rows: |
| 170 | iterations.append(klass(*row)) |
| 171 | return iterations |
| 172 | |
| 173 | |
| 174 | def __init__(self, iteration, key, value): |
| 175 | self.iteration = iteration |
| 176 | self.key = key |
| 177 | self.value = value |
| 178 | |
mbligh | 8e1ab17 | 2007-09-13 17:29:56 +0000 | [diff] [blame] | 179 | # class patch: |
| 180 | # def __init__(self): |
| 181 | # self.spec = None |