diff options
author | iximeow <me@iximeow.net> | 2023-06-29 02:25:11 -0700 |
---|---|---|
committer | iximeow <me@iximeow.net> | 2023-06-29 02:25:11 -0700 |
commit | 1589853ea765f5512ea776a74535d6022812e289 (patch) | |
tree | 9fc06f13bc0b4e8d6615cd90821b00563f1b735f /src/sql.rs | |
parent | 300098949689c2da294476483e8565e8b481e8ac (diff) |
started->active, include pending
Diffstat (limited to 'src/sql.rs')
-rw-r--r-- | src/sql.rs | 4 |
1 files changed, 2 insertions, 2 deletions
@@ -97,8 +97,8 @@ 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 ACTIVE_JOBS: &'static str = "\ + select * from jobs where state=1 or state=0;"; 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;"; |