From 69d2943e8c97c266ebcbb3e850f0a2493f6b04b4 Mon Sep 17 00:00:00 2001
From: iximeow <me@iximeow.net>
Date: Thu, 29 Jun 2023 01:43:12 -0700
Subject: show job time in commit summary page

---
 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 2096e9d..2620a58 100644
--- a/src/sql.rs
+++ b/src/sql.rs
@@ -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;";
 
-- 
cgit v1.1