Mercurial > sci
annotate sql/job-todo.sql @ 3:215c0c3b3609
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 |
rev | line source |
---|---|
2
5fa3d2f479b2
sci: initial upload support
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
1 SELECT job.id |
5fa3d2f479b2
sci: initial upload support
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
2 , job.tag |
3
215c0c3b3609
misc: use JSON everywhere (scictl/sciwebd)
David Demelier <markand@malikania.fr>
parents:
2
diff
changeset
|
3 , job.project_id |
215c0c3b3609
misc: use JSON everywhere (scictl/sciwebd)
David Demelier <markand@malikania.fr>
parents:
2
diff
changeset
|
4 FROM job |
215c0c3b3609
misc: use JSON everywhere (scictl/sciwebd)
David Demelier <markand@malikania.fr>
parents:
2
diff
changeset
|
5 WHERE job.id |
2
5fa3d2f479b2
sci: initial upload support
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
6 NOT IN ( |
5fa3d2f479b2
sci: initial upload support
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
7 SELECT job_result.job_id |
5fa3d2f479b2
sci: initial upload support
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
8 FROM job_result |
5fa3d2f479b2
sci: initial upload support
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
9 WHERE job_result.worker_id = ? |
5fa3d2f479b2
sci: initial upload support
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
10 ) |
5fa3d2f479b2
sci: initial upload support
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
11 LIMIT ? |