From 7b08cb229de7b0c131bc8c7e3405ad548ff5e0eb Mon Sep 17 00:00:00 2001
From: iximeow <me@iximeow.net>
Date: Sat, 24 Jun 2023 18:09:13 -0700
Subject: add a repos index page

---
 src/sql.rs | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'src/sql.rs')

diff --git a/src/sql.rs b/src/sql.rs
index 7bd33fd..b262e9a 100644
--- a/src/sql.rs
+++ b/src/sql.rs
@@ -106,3 +106,10 @@ pub const COMMIT_TO_ID: &'static str = "\
 
 pub const REMOTES_FOR_REPO: &'static str = "\
     select * from remotes where repo_id=?1;";
+
+pub const ALL_REPOS: &'static str = "\
+    select * from repos;";
+
+pub const LAST_JOB_FROM_REMOTE: &'static str = "\
+    select * from jobs where remote_id=?1 order by created_time desc limit 1;";
+
-- 
cgit v1.1