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
| UP_SQL = """
| CREATE VIEW test_view_2 AS
| SELECT tests.test_idx,
| tests.job_idx,
| tests.test AS test_name,
| tests.subdir,
| tests.kernel_idx,
| tests.status AS status_idx,
| tests.reason,
| tests.machine_idx,
| tests.started_time AS test_started_time,
| tests.finished_time AS test_finished_time,
| jobs.tag AS job_tag,
| jobs.label AS job_name,
| jobs.username AS job_owner,
| jobs.queued_time AS job_queued_time,
| jobs.started_time AS job_started_time,
| jobs.finished_time AS job_finished_time,
| machines.hostname AS hostname,
| machines.machine_group AS platform,
| machines.owner AS machine_owner,
| kernels.kernel_hash,
| kernels.base AS kernel_base,
| kernels.printable AS kernel,
| status.word AS status
| FROM tests
| INNER JOIN jobs ON jobs.job_idx = tests.job_idx
| INNER JOIN machines ON machines.machine_idx = jobs.machine_idx
| INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
| INNER JOIN status ON status.status_idx = tests.status;
| """
|
| def migrate_up(manager):
| manager.execute(UP_SQL)
|
|
| def migrate_down(manager):
| manager.execute('DROP VIEW IF EXISTS test_view_2')
|
|
