Mercurial > sci

annotate sql/job-todo.sql @ 57:bc617784ec97

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
scid: many fixes in pages
author David Demelier <markand@malikania.fr>
date Wed, 17 Aug 2022 18:26:27 +0200
parents 081e1c258e64
children eaebcc612a0d
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
6
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
1 --
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
2 -- job-todo.sql -- list jobs to perform for a worker
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
3 --
32
081e1c258e64 misc: update copyright years
David Demelier <markand@malikania.fr>
parents: 27
diff changeset
4 -- Copyright (c) 2021-2022 David Demelier <markand@malikania.fr>
6
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
5 --
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
6 -- Permission to use, copy, modify, and/or distribute this software for any
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
7 -- purpose with or without fee is hereby granted, provided that the above
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
8 -- copyright notice and this permission notice appear in all copies.
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
9 --
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
10 -- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
11 -- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
12 -- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
13 -- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
14 -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
15 -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
17 --
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
18
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
19 --
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
20 -- This request won't list jobs that were created before the worker itself
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
21 -- otherwise when adding a new worker it would need to run potentially a very
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
22 -- high number of jobs
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
23 --
19
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 6
diff changeset
24 SELECT `job`.`rowid`
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 6
diff changeset
25 , `job`.`tag`
22
dd078aea5d02 misc: use project/worker name as primary key
David Demelier <markand@malikania.fr>
parents: 19
diff changeset
26 , `job`.`project_name`
19
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 6
diff changeset
27 FROM `job`
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 6
diff changeset
28 WHERE `job`.`rowid`
6
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
29 NOT IN (
19
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 6
diff changeset
30 SELECT `jobresult`.`job_id`
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 6
diff changeset
31 FROM `jobresult`
22
dd078aea5d02 misc: use project/worker name as primary key
David Demelier <markand@malikania.fr>
parents: 19
diff changeset
32 WHERE `jobresult`.`worker_name` = ?
6
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
33 )
19
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 6
diff changeset
34 AND `job`.`date` >= (
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 6
diff changeset
35 SELECT `worker`.`date`
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 6
diff changeset
36 FROM `worker`
22
dd078aea5d02 misc: use project/worker name as primary key
David Demelier <markand@malikania.fr>
parents: 19
diff changeset
37 WHERE `worker`.`name` = ?
6
8c408176d2b1 scid: past jobs are not listed for new workers
David Demelier <markand@malikania.fr>
parents: 4
diff changeset
38 )