view sql/jobresult-add.sql @ 61:8be8188d61a5

scictl: resurrect project-update command
author David Demelier <markand@malikania.fr>
date Thu, 18 Aug 2022 10:42:42 +0200
parents 081e1c258e64
children eaebcc612a0d
line wrap: on
line source

--
-- jobresult-add.sql -- register a new job result
--
-- Copyright (c) 2021-2022 David Demelier <markand@malikania.fr>
--
-- Permission to use, copy, modify, and/or distribute this software for any
-- purpose with or without fee is hereby granted, provided that the above
-- copyright notice and this permission notice appear in all copies.
--
-- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
-- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
-- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
-- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
-- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
-- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
-- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
--

INSERT INTO jobresult(
	`job_id`,
	`worker_name`,
	`console`,
	`exitcode`,
	`sigcode`
) VALUES (?, ?, ?, ?, ?)