From 954a65107b59b9a547ca5ce0f1fa2dd41e013cd6 Mon Sep 17 00:00:00 2001 From: iximeow Date: Thu, 29 Jun 2023 02:17:11 -0700 Subject: more gross hacks to get a list of active jobs --- src/sql.rs | 3 +++ 1 file changed, 3 insertions(+) (limited to 'src/sql.rs') diff --git a/src/sql.rs b/src/sql.rs index 2620a58..96d2ef8 100644 --- a/src/sql.rs +++ b/src/sql.rs @@ -97,6 +97,9 @@ pub const CREATE_REPO_NAME_INDEX: &'static str = "\ pub const PENDING_JOBS: &'static str = "\ select id, artifacts_path, state, run_host, remote_id, commit_id, created_time, source from jobs where state=0;"; +pub const STARTED_JOBS: &'static str = "\ + select * from jobs where state=1;"; + pub const LAST_ARTIFACTS_FOR_JOB: &'static str = "\ select * from artifacts where job_id=?1 and (name like \"%(stderr)%\" or name like \"%(stdout)%\") order by id desc limit ?2;"; -- cgit v1.1