add a repos index page

1 files changed, 7 insertions, 0 deletions

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;";
+