summaryrefslogtreecommitdiff
path: root/src/sql.rs
diff options
context:
space:
mode:
authoriximeow <me@iximeow.net>2023-06-29 01:30:22 -0700
committeriximeow <me@iximeow.net>2023-06-29 01:30:22 -0700
commit053ff13eb080e5ad73d782e897472e40145ba4df (patch)
treed0a6af0daa84e8e1495c891f3b8743906c409e40 /src/sql.rs
parent72567a7932b800e6eb851cafb385486b9817092b (diff)
more info on job summary page
Diffstat (limited to 'src/sql.rs')
-rw-r--r--src/sql.rs2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/sql.rs b/src/sql.rs
index f5ae731..2096e9d 100644
--- a/src/sql.rs
+++ b/src/sql.rs
@@ -98,7 +98,7 @@ 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 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;";
+ select * from artifacts where job_id=?1 and (name like \"%(stderr)%\" or name like \"%(stdout)%\") order by id desc limit ?2;";
pub const ARTIFACT_BY_ID: &'static str = "\
select * from artifacts where id=?1 and job_id=?2;";