diff options
author | iximeow <me@iximeow.net> | 2023-06-29 01:43:12 -0700 |
---|---|---|
committer | iximeow <me@iximeow.net> | 2023-06-29 01:43:12 -0700 |
commit | 69d2943e8c97c266ebcbb3e850f0a2493f6b04b4 (patch) | |
tree | 1f85480c786a582cdbbf0eff68a296301f4e6d07 /src/sql.rs | |
parent | 053ff13eb080e5ad73d782e897472e40145ba4df (diff) |
show job time in commit summary page
Diffstat (limited to 'src/sql.rs')
-rw-r--r-- | src/sql.rs | 3 |
1 files changed, 3 insertions, 0 deletions
@@ -100,6 +100,9 @@ pub const PENDING_JOBS: &'static str = "\ 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;"; +pub const JOB_BY_COMMIT_ID: &'static str = "\ + select * from jobs where commit_id=?1;"; + pub const ARTIFACT_BY_ID: &'static str = "\ select * from artifacts where id=?1 and job_id=?2;"; |