Mercurial > sci

comparison sql/job-todo.sql @ 22:dd078aea5d02

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 ?