Mercurial > sci

view sql/job-todo.sql @ 4:9c4fea43803c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
scid: some refactoring in db
author David Demelier <markand@malikania.fr>
date Tue, 15 Jun 2021 20:42:55 +0200
parents 215c0c3b3609
children 8c408176d2b1
line wrap: on
line source

     SELECT job.id
          , job.tag
          , job.project_id
       FROM job
      WHERE job.id
     NOT IN (
            SELECT jobresult.job_id
              FROM jobresult
             WHERE jobresult.worker_id = ?
     )
      LIMIT ?