From 1fe3acc1422b09db27d179db05331a763b1db8a6 Mon Sep 17 00:00:00 2001 From: iximeow Date: Mon, 26 Dec 2022 00:21:32 +0000 Subject: let build runners indicate restricted interest --- src/sql.rs | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'src/sql.rs') diff --git a/src/sql.rs b/src/sql.rs index 81c58de..3476643 100644 --- a/src/sql.rs +++ b/src/sql.rs @@ -39,7 +39,8 @@ pub const CREATE_JOBS_TABLE: &'static str = "\ created_time INTEGER, started_time INTEGER, complete_time INTEGER, - job_timeout INTEGER);"; + job_timeout INTEGER, + source TEXT);"; pub const CREATE_COMMITS_TABLE: &'static str = "\ CREATE TABLE IF NOT EXISTS commits (id INTEGER PRIMARY KEY AUTOINCREMENT, sha TEXT UNIQUE);"; @@ -76,7 +77,7 @@ pub const CREATE_REPO_NAME_INDEX: &'static str = "\ CREATE UNIQUE INDEX IF NOT EXISTS 'repo_names' ON repos(repo_name);"; pub const PENDING_JOBS: &'static str = "\ - select * from jobs where state=0;"; + select id, artifacts_path, state, run_host, remote_id, commit_id, created_time, source from jobs where state=0;"; pub const COMMIT_TO_ID: &'static str = "\ select id from commits where sha=?1;"; -- cgit v1.1