Mercurial > sci
annotate sql/jobresult-list-by-worker.sql @ 62:eaebcc612a0d
misc: add header in SQL files
author | David Demelier <markand@malikania.fr> |
---|---|
date | Thu, 18 Aug 2022 12:18:12 +0200 |
parents | 3cf148705724 |
children | 71cd8447e3a4 |
rev | line source |
---|---|
62
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
1 -- |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
2 -- jobresult-list-by-worker.sql -- list all jobresults by a worker |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
3 -- |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
4 -- Copyright (c) 2021-2022 David Demelier <markand@malikania.fr> |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
5 -- |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
6 -- Permission to use, copy, modify, and/or distribute this software for any |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
7 -- purpose with or without fee is hereby granted, provided that the above |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
8 -- copyright notice and this permission notice appear in all copies. |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
9 -- |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
10 -- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
11 -- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
12 -- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
13 -- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
14 -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
15 -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
17 -- |
eaebcc612a0d
misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents:
48
diff
changeset
|
18 |
48
3cf148705724
scid: refactor status classes in bulma
David Demelier <markand@malikania.fr>
parents:
27
diff
changeset
|
19 SELECT rowid |
3cf148705724
scid: refactor status classes in bulma
David Demelier <markand@malikania.fr>
parents:
27
diff
changeset
|
20 , * |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
21 FROM `jobresult` |
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
22 WHERE `worker_name` = ? |
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff
changeset
|
23 ORDER BY `job_id` ASC |