From d0e845d3ac4530cf281e90d8a3634355d153c8be Mon Sep 17 00:00:00 2001 From: iximeow Date: Tue, 4 Jul 2023 14:21:58 -0700 Subject: adjust metrics to show multi-host summaries? --- src/sql.rs | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) (limited to 'src/sql.rs') diff --git a/src/sql.rs b/src/sql.rs index 89dc381..34bc8aa 100644 --- a/src/sql.rs +++ b/src/sql.rs @@ -176,6 +176,12 @@ pub const JOB_BY_ID: &'static str = "\ pub const METRICS_FOR_RUN: &'static str = "\ select * from metrics where run_id=?1 order by id asc;"; +pub const METRICS_FOR_JOB: &'static str = "\ + select metrics.id, metrics.run_id, metrics.name, metrics.value from metrics \ + join runs on runs.id=metrics.run_id \ + where runs.job_id=?1 \ + order by metrics.run_id desc, metrics.id desc;"; + pub const COMMIT_TO_ID: &'static str = "\ select id from commits where sha=?1;"; @@ -202,6 +208,20 @@ pub const LAST_RUN_FOR_JOB: &'static str = "\ build_result, final_status from runs where job_id=?1 order by started_time desc limit 1;"; +pub const RUNS_FOR_JOB: &'static str = "\ + select id, + job_id, + artifacts_path, + state, + host_id, + build_token, + created_time, + started_time, + complete_time, + run_timeout, + build_result, + final_status from runs where job_id=?1 group by host_id order by started_time desc, state asc;"; + pub const SELECT_ALL_RUNS_WITH_JOB_INFO: &'static str = "\ select jobs.id as job_id, runs.id as run_id, runs.state, runs.created_time, jobs.commit_id, jobs.run_preferences from jobs join runs on jobs.id=runs.job_id -- cgit v1.1