46 lines
1.6 KiB
Python
46 lines
1.6 KiB
Python
prev_migration = __import__('015_support_graphing_interface')
|
|
|
|
def migrate_up(manager):
|
|
manager.execute(prev_migration.DROP_PERF_VIEW_2)
|
|
manager.execute(CREATE_NEW_PERF_VIEW_2)
|
|
|
|
def migrate_down(manager):
|
|
manager.execute(prev_migration.DROP_PERF_VIEW_2)
|
|
manager.execute(prev_migration.CREATE_PERF_VIEW_2)
|
|
|
|
CREATE_NEW_PERF_VIEW_2 = """\
|
|
CREATE VIEW perf_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,
|
|
iteration_result.iteration,
|
|
iteration_result.attribute AS iteration_key,
|
|
iteration_result.value AS iteration_value
|
|
FROM tests
|
|
LEFT OUTER JOIN jobs ON jobs.job_idx = tests.job_idx
|
|
LEFT OUTER JOIN machines ON machines.machine_idx = jobs.machine_idx
|
|
LEFT OUTER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
|
|
LEFT OUTER JOIN status ON status.status_idx = tests.status
|
|
LEFT OUTER JOIN iteration_result ON iteration_result.test_idx = tests.test_idx;
|
|
"""
|