Mercurial > sci
comparison sql/job-todo.sql @ 22:dd078aea5d02
misc: use project/worker name as primary key
author | David Demelier <markand@malikania.fr> |
---|---|
date | Thu, 21 Jul 2022 20:23:22 +0200 |
parents | de4bf839b565 |
children | dae2de19ca5d |
comparison
equal
deleted
inserted
replaced
21:ec30e1b078a9 | 22:dd078aea5d02 |
---|---|
21 -- otherwise when adding a new worker it would need to run potentially a very | 21 -- otherwise when adding a new worker it would need to run potentially a very |
22 -- high number of jobs | 22 -- high number of jobs |
23 -- | 23 -- |
24 SELECT `job`.`rowid` | 24 SELECT `job`.`rowid` |
25 , `job`.`tag` | 25 , `job`.`tag` |
26 , `job`.`project_id` | 26 , `job`.`project_name` |
27 FROM `job` | 27 FROM `job` |
28 WHERE `job`.`rowid` | 28 WHERE `job`.`rowid` |
29 NOT IN ( | 29 NOT IN ( |
30 SELECT `jobresult`.`job_id` | 30 SELECT `jobresult`.`job_id` |
31 FROM `jobresult` | 31 FROM `jobresult` |
32 WHERE `jobresult`.`worker_id` = ? | 32 WHERE `jobresult`.`worker_name` = ? |
33 ) | 33 ) |
34 AND `job`.`date` >= ( | 34 AND `job`.`date` >= ( |
35 SELECT `worker`.`date` | 35 SELECT `worker`.`date` |
36 FROM `worker` | 36 FROM `worker` |
37 WHERE `worker`.`rowid` = ? | 37 WHERE `worker`.`name` = ? |
38 ) | 38 ) |
39 LIMIT ? | 39 LIMIT ? |