Mercurial > sci
diff 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 |
line wrap: on
line diff
--- a/sql/job-todo.sql Tue Jul 19 22:45:44 2022 +0200 +++ b/sql/job-todo.sql Thu Jul 21 20:23:22 2022 +0200 @@ -23,17 +23,17 @@ -- SELECT `job`.`rowid` , `job`.`tag` - , `job`.`project_id` + , `job`.`project_name` FROM `job` WHERE `job`.`rowid` NOT IN ( SELECT `jobresult`.`job_id` FROM `jobresult` - WHERE `jobresult`.`worker_id` = ? + WHERE `jobresult`.`worker_name` = ? ) AND `job`.`date` >= ( SELECT `worker`.`date` FROM `worker` - WHERE `worker`.`rowid` = ? + WHERE `worker`.`name` = ? ) LIMIT ?