1UP_SQL = """ 2CREATE VIEW test_view_2 AS 3SELECT tests.test_idx, 4 tests.job_idx, 5 tests.test AS test_name, 6 tests.subdir, 7 tests.kernel_idx, 8 tests.status AS status_idx, 9 tests.reason, 10 tests.machine_idx, 11 tests.started_time AS test_started_time, 12 tests.finished_time AS test_finished_time, 13 jobs.tag AS job_tag, 14 jobs.label AS job_name, 15 jobs.username AS job_owner, 16 jobs.queued_time AS job_queued_time, 17 jobs.started_time AS job_started_time, 18 jobs.finished_time AS job_finished_time, 19 machines.hostname AS hostname, 20 machines.machine_group AS platform, 21 machines.owner AS machine_owner, 22 kernels.kernel_hash, 23 kernels.base AS kernel_base, 24 kernels.printable AS kernel, 25 status.word AS status 26FROM tests 27INNER JOIN jobs ON jobs.job_idx = tests.job_idx 28INNER JOIN machines ON machines.machine_idx = jobs.machine_idx 29INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx 30INNER JOIN status ON status.status_idx = tests.status; 31""" 32 33def migrate_up(manager): 34 manager.execute(UP_SQL) 35 36 37def migrate_down(manager): 38 manager.execute('DROP VIEW IF EXISTS test_view_2') 39