Mercurial > sci

annotate sql/jobresult-add.sql @ 71:ef8f9c986080

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
scid: fix worker with . in their names
author David Demelier <markand@malikania.fr>
date Tue, 24 Jan 2023 10:04:47 +0100
parents eaebcc612a0d
children 71cd8447e3a4
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
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
62
eaebcc612a0d misc: add header in SQL files
David Demelier <markand@malikania.fr>
parents: 32
diff changeset
19 INSERT INTO `jobresult`(
19
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 16
diff changeset
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
de4bf839b565 misc: revamp SQL
David Demelier <markand@malikania.fr>
parents: 16
diff changeset
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 (?, ?, ?, ?, ?)