Mercurial > sci

diff sql/job-todo.sql @ 3:215c0c3b3609

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
misc: use JSON everywhere (scictl/sciwebd)
author David Demelier <markand@malikania.fr>
date Mon, 14 Jun 2021 22:08:24 +0200
parents sql/job-result-todo.sql@5fa3d2f479b2
children 9c4fea43803c
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/sql/job-todo.sql	Mon Jun 14 22:08:24 2021 +0200
@@ -0,0 +1,11 @@
+     SELECT job.id
+          , job.tag
+          , job.project_id
+       FROM job
+      WHERE job.id
+     NOT IN (
+            SELECT job_result.job_id
+              FROM job_result
+             WHERE job_result.worker_id = ?
+     )
+      LIMIT ?