summaryrefslogtreecommitdiff
path: root/src/sql.rs
diff options
context:
space:
mode:
authoriximeow <git@iximeow.net>2022-12-26 00:21:32 +0000
committeriximeow <git@iximeow.net>2022-12-26 00:21:32 +0000
commit1fe3acc1422b09db27d179db05331a763b1db8a6 (patch)
tree0587e39f80b7fedce16cf7327a3aedf7951984ed /src/sql.rs
parentb3dbd762d9bc21cf48357fa50901e125b42becc0 (diff)
let build runners indicate restricted interest
Diffstat (limited to 'src/sql.rs')
-rw-r--r--src/sql.rs5
1 files changed, 3 insertions, 2 deletions
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;";