This file is in a location similar to the fixtures files, that is, Django will automatically load its content (in this case run this SQL) at database sync time.
Signed-off-by: Cleber Rosa <[email protected]> --- frontend/tko/sql/test.sql | 31 +++++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 frontend/tko/sql/test.sql diff --git a/frontend/tko/sql/test.sql b/frontend/tko/sql/test.sql new file mode 100644 index 0000000..bdf3183 --- /dev/null +++ b/frontend/tko/sql/test.sql @@ -0,0 +1,31 @@ +CREATE VIEW tko_test_view_2 AS + SELECT + tko_tests.test_idx AS test_idx, + tko_tests.job_idx AS job_idx, + tko_tests.test AS test_name, + tko_tests.subdir AS subdir, + tko_tests.kernel_idx AS kernel_idx, + tko_tests.status AS status_idx, + tko_tests.reason AS reason, + tko_tests.machine_idx AS machine_idx, + tko_tests.started_time AS test_started_time, + tko_tests.finished_time AS test_finished_time, + tko_jobs.tag AS job_tag, + tko_jobs.label AS job_name, + tko_jobs.username AS job_owner, + tko_jobs.queued_time AS job_queued_time, + tko_jobs.started_time AS job_started_time, + tko_jobs.finished_time AS job_finished_time, + tko_jobs.afe_job_id AS afe_job_id, + tko_machines.hostname AS hostname, + tko_machines.machine_group AS platform, + tko_machines.owner AS machine_owner, + tko_kernels.kernel_hash AS kernel_hash, + tko_kernels.base AS kernel_base, + tko_kernels.printable AS kernel, + tko_status.word AS status + FROM + tko_tests JOIN tko_jobs ON tko_jobs.job_idx=tko_tests.job_idx + JOIN tko_machines ON tko_machines.machine_idx=tko_jobs.machine_idx + JOIN tko_kernels ON tko_kernels.kernel_idx=tko_tests.kernel_idx + JOIN tko_status ON tko_status.status_idx = tko_tests.status; -- 1.7.11.7 _______________________________________________ Autotest-kernel mailing list [email protected] https://www.redhat.com/mailman/listinfo/autotest-kernel
