diff options
Diffstat (limited to 'src/sql.rs')
-rw-r--r-- | src/sql.rs | 3 |
1 files changed, 3 insertions, 0 deletions
@@ -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;"; |