summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoriximeow <me@iximeow.net>2023-07-04 09:45:32 -0700
committeriximeow <me@iximeow.net>2023-07-04 09:45:32 -0700
commita87fba7a82185fd3590cbaa211f78f96c6693472 (patch)
tree1e4cf9bf1f1a4e42340ce0ead4330531e156f2d5
parentb0e0df89c09751cee601bd443aa4b8d46728ac99 (diff)
more sql query typo fixes
-rw-r--r--src/sql.rs6
1 files changed, 3 insertions, 3 deletions
diff --git a/src/sql.rs b/src/sql.rs
index cbd5c2a..89dc381 100644
--- a/src/sql.rs
+++ b/src/sql.rs
@@ -142,9 +142,9 @@ pub const PENDING_RUNS: &'static str = "\
select id, job_id, created_time, host_preference from runs where state=0 and (host_preference=?1 or host_preference is null) order by created_time desc;";
pub const JOBS_NEEDING_HOST_RUN: &'static str = "\
- select jobs.id, jobs.source, jobs.created_time, jobs.remote_id, jobs.commit_id, jobs.run_preferences from jobs\
- where jobs.run_prefererences=\"all\"
- and not exists\
+ select jobs.id, jobs.source, jobs.created_time, jobs.remote_id, jobs.commit_id, jobs.run_preferences from jobs \
+ where jobs.run_preferences=\"all\" \
+ and not exists \
(select 1 from runs r2 where r2.job_id = jobs.id and r2.host_id = ?1);";
pub const ACTIVE_RUNS: &'static str = "\