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 ?