1 UP_SQL = """ 2 ALTER VIEW tko_test_view_2 AS 3 SELECT tko_tests.test_idx, 4 tko_tests.job_idx, 5 tko_tests.test AS test_name, 6 tko_tests.subdir, 7 tko_tests.kernel_idx, 8 tko_tests.status AS status_idx, 9 tko_tests.reason, 10 tko_tests.machine_idx, 11 tko_tests.invalid, 12 tko_tests.invalidates_test_idx, 13 tko_tests.started_time AS test_started_time, 14 tko_tests.finished_time AS test_finished_time, 15 tko_jobs.tag AS job_tag, 16 tko_jobs.label AS job_name, 17 tko_jobs.username AS job_owner, 18 tko_jobs.queued_time AS job_queued_time, 19 tko_jobs.started_time AS job_started_time, 20 tko_jobs.finished_time AS job_finished_time, 21 tko_jobs.afe_job_id AS afe_job_id, 22 tko_machines.hostname AS hostname, 23 tko_machines.machine_group AS platform, 24 tko_machines.owner AS machine_owner, 25 tko_kernels.kernel_hash, 26 tko_kernels.base AS kernel_base, 27 tko_kernels.printable AS kernel, 28 tko_status.word AS status 29 FROM tko_tests 30 INNER JOIN tko_jobs ON tko_jobs.job_idx = tko_tests.job_idx 31 INNER JOIN tko_machines ON tko_machines.machine_idx = tko_jobs.machine_idx 32 INNER JOIN tko_kernels ON tko_kernels.kernel_idx = tko_tests.kernel_idx 33 INNER JOIN tko_status ON tko_status.status_idx = tko_tests.status; 34 """ 35 36 37 DOWN_SQL = """ 38 ALTER VIEW tko_test_view_2 AS 39 SELECT tko_tests.test_idx, 40 tko_tests.job_idx, 41 tko_tests.test AS test_name, 42 tko_tests.subdir, 43 tko_tests.kernel_idx, 44 tko_tests.status AS status_idx, 45 tko_tests.reason, 46 tko_tests.machine_idx, 47 tko_tests.started_time AS test_started_time, 48 tko_tests.finished_time AS test_finished_time, 49 tko_jobs.tag AS job_tag, 50 tko_jobs.label AS job_name, 51 tko_jobs.username AS job_owner, 52 tko_jobs.queued_time AS job_queued_time, 53 tko_jobs.started_time AS job_started_time, 54 tko_jobs.finished_time AS job_finished_time, 55 tko_jobs.afe_job_id AS afe_job_id, 56 tko_machines.hostname AS hostname, 57 tko_machines.machine_group AS platform, 58 tko_machines.owner AS machine_owner, 59 tko_kernels.kernel_hash, 60 tko_kernels.base AS kernel_base, 61 tko_kernels.printable AS kernel, 62 tko_status.word AS status 63 FROM tko_tests 64 INNER JOIN tko_jobs ON tko_jobs.job_idx = tko_tests.job_idx 65 INNER JOIN tko_machines ON tko_machines.machine_idx = tko_jobs.machine_idx 66 INNER JOIN tko_kernels ON tko_kernels.kernel_idx = tko_tests.kernel_idx 67 INNER JOIN tko_status ON tko_status.status_idx = tko_tests.status; 68 """ 69