diff options
| author | iximeow <me@iximeow.net> | 2023-07-04 09:45:32 -0700 | 
|---|---|---|
| committer | iximeow <me@iximeow.net> | 2023-07-04 09:45:32 -0700 | 
| commit | a87fba7a82185fd3590cbaa211f78f96c6693472 (patch) | |
| tree | 1e4cf9bf1f1a4e42340ce0ead4330531e156f2d5 /src | |
| parent | b0e0df89c09751cee601bd443aa4b8d46728ac99 (diff) | |
more sql query typo fixes
Diffstat (limited to 'src')
| -rw-r--r-- | src/sql.rs | 6 | 
1 files changed, 3 insertions, 3 deletions
| @@ -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 = "\ | 
