Mercurial > sci
annotate sql/jobresult-add.sql @ 57:bc617784ec97
scid: many fixes in pages
author | David Demelier <markand@malikania.fr> |
---|---|
date | Wed, 17 Aug 2022 18:26:27 +0200 |
parents | 081e1c258e64 |
children | eaebcc612a0d |
rev | line source |
---|---|
16
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
1 -- |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
2 -- jobresult-add.sql -- register a new job result |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
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> |
16
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
5 -- |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
6 -- Permission to use, copy, modify, and/or distribute this software for any |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
7 -- purpose with or without fee is hereby granted, provided that the above |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
8 -- copyright notice and this permission notice appear in all copies. |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
9 -- |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
10 -- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
11 -- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
12 -- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
13 -- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
14 -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
15 -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
17 -- |
3051ef92173a
misc: add license headers
David Demelier <markand@malikania.fr>
parents:
12
diff
changeset
|
18 |
4
9c4fea43803c
scid: some refactoring in db
David Demelier <markand@malikania.fr>
parents:
3
diff
changeset
|
19 INSERT INTO jobresult( |
19 | 20 `job_id`, |
22
dd078aea5d02
misc: use project/worker name as primary key
David Demelier <markand@malikania.fr>
parents:
19
diff
changeset
|
21 `worker_name`, |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
22
diff
changeset
|
22 `console`, |
19 | 23 `exitcode`, |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
22
diff
changeset
|
24 `sigcode` |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
22
diff
changeset
|
25 ) VALUES (?, ?, ?, ?, ?) |