| mbligh | 651e2d0 | 2008-07-17 21:26:00 +0000 | [diff] [blame] | 1 | def migrate_up(manager): |
| 2 | manager.execute(ALTER_VIEWS_UP_SQL) |
| 3 | |
| 4 | |
| 5 | def migrate_down(manager): |
| 6 | manager.execute(ALTER_VIEWS_DOWN_SQL) |
| 7 | |
| 8 | |
| 9 | ALTER_VIEWS_UP_SQL = """\ |
| 10 | ALTER VIEW perf_view AS |
| 11 | SELECT tests.test_idx, |
| 12 | tests.job_idx, |
| 13 | tests.test, |
| 14 | tests.subdir, |
| 15 | tests.kernel_idx, |
| 16 | tests.status, |
| 17 | tests.reason, |
| 18 | tests.machine_idx, |
| 19 | tests.started_time AS test_started_time, |
| 20 | tests.finished_time AS test_finished_time, |
| 21 | jobs.tag AS job_tag, |
| 22 | jobs.label AS job_label, |
| 23 | jobs.username AS job_username, |
| 24 | jobs.queued_time AS job_queued_time, |
| 25 | jobs.started_time AS job_started_time, |
| 26 | jobs.finished_time AS job_finished_time, |
| 27 | machines.hostname AS machine_hostname, |
| 28 | machines.machine_group, |
| 29 | machines.owner AS machine_owner, |
| 30 | kernels.kernel_hash, |
| 31 | kernels.base AS kernel_base, |
| 32 | kernels.printable AS kernel_printable, |
| 33 | status.word AS status_word, |
| 34 | iteration_result.iteration, |
| 35 | iteration_result.attribute AS iteration_key, |
| 36 | iteration_result.value AS iteration_value |
| 37 | FROM tests |
| 38 | INNER JOIN jobs ON jobs.job_idx = tests.job_idx |
| 39 | INNER JOIN machines ON machines.machine_idx = jobs.machine_idx |
| 40 | INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx |
| 41 | INNER JOIN status ON status.status_idx = tests.status |
| 42 | INNER JOIN iteration_result ON iteration_result.test_idx = tests.test_idx; |
| 43 | """ |
| 44 | |
| 45 | ALTER_VIEWS_DOWN_SQL = """\ |
| 46 | ALTER VIEW perf_view AS |
| 47 | SELECT tests.test_idx, |
| 48 | tests.job_idx, |
| 49 | tests.test, |
| 50 | tests.subdir, |
| 51 | tests.kernel_idx, |
| 52 | tests.status, |
| 53 | tests.reason, |
| 54 | tests.machine_idx, |
| 55 | tests.started_time AS test_started_time, |
| 56 | tests.finished_time AS test_finished_time, |
| 57 | jobs.tag AS job_tag, |
| 58 | jobs.label AS job_label, |
| 59 | jobs.username AS job_username, |
| 60 | jobs.queued_time AS job_queued_time, |
| 61 | jobs.started_time AS job_started_time, |
| 62 | jobs.finished_time AS job_finished_time, |
| 63 | machines.hostname AS machine_hostname, |
| 64 | machines.machine_group, |
| 65 | machines.owner AS machine_owner, |
| 66 | kernels.kernel_hash, |
| 67 | kernels.base AS kernel_base, |
| 68 | kernels.printable AS kernel_printable, |
| 69 | status.word AS status_word, |
| 70 | iteration_result.iteration, |
| 71 | iteration_result.attribute AS iteration_key, |
| 72 | iteration_result.value AS iteration_value |
| 73 | FROM tests |
| 74 | INNER JOIN jobs ON jobs.job_idx = tests.job_idx |
| 75 | INNER JOIN machines ON machines.machine_idx = jobs.machine_idx |
| 76 | INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx |
| 77 | INNER JOIN status ON status.status_idx = tests.status |
| 78 | INNER JOIN iteration_result ON iteration_result.test_idx = tests.kernel_idx; |
| 79 | """ |