Mercurial > sci
changeset 62:eaebcc612a0d
misc: add header in SQL files
| author | David Demelier <markand@malikania.fr> |
|---|---|
| date | Thu, 18 Aug 2022 12:18:12 +0200 |
| parents | 8be8188d61a5 |
| children | 67470b67e460 |
| files | sql/init.sql sql/job-list.sql sql/job-todo.sql sql/jobresult-add.sql sql/jobresult-list-by-job-group.sql sql/jobresult-list-by-job.sql sql/jobresult-list-by-worker.sql sql/property-get.sql sql/property-set.sql |
| diffstat | 9 files changed, 118 insertions(+), 10 deletions(-) [+] |
line wrap: on
line diff
--- a/sql/init.sql Thu Aug 18 10:42:42 2022 +0200 +++ b/sql/init.sql Thu Aug 18 12:18:12 2022 +0200 @@ -16,7 +16,7 @@ -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. -- -CREATE TABLE IF NOT EXISTS project( +CREATE TABLE IF NOT EXISTS `project`( `name` TEXT NOT NULL PRIMARY KEY, `desc` TEXT NOT NULL, `url` TEXT NOT NULL, @@ -24,28 +24,28 @@ `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) ); -CREATE TABLE IF NOT EXISTS worker( +CREATE TABLE IF NOT EXISTS `worker`( `name` TEXT NOT NULL PRIMARY KEY, `desc` TEXT NOT NULL, `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) ); -CREATE TABLE IF NOT EXISTS job( +CREATE TABLE IF NOT EXISTS `job`( `tag` TEXT NOT NULL, - `project_name` INTEGER NOT NULL REFERENCES project (name), + `project_name` INTEGER NOT NULL REFERENCES `project` (name), `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) ); -CREATE TABLE IF NOT EXISTS jobresult( - `job_id` INTEGER NOT NULL REFERENCES job (rowid), - `worker_name` INTEGER NOT NULL REFERENCES worker (name), +CREATE TABLE IF NOT EXISTS `jobresult`( + `job_id` INTEGER NOT NULL REFERENCES `job` (rowid), + `worker_name` INTEGER NOT NULL REFERENCES `worker` (name), `console` TEXT DEFAULT NULL, `exitcode` INTEGER DEFAULT 0, `sigcode` INTEGER DEFAULT 0, `date` INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) ); -CREATE TABLE IF NOT EXISTS property( +CREATE TABLE IF NOT EXISTS `property`( `key` TEXT PRIMARY KEY NOT NULL, `value` TEXT );
--- a/sql/job-list.sql Thu Aug 18 10:42:42 2022 +0200 +++ b/sql/job-list.sql Thu Aug 18 12:18:12 2022 +0200 @@ -1,3 +1,21 @@ +-- +-- job-list.sql -- list all jobs for a project +-- +-- 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. +-- + SELECT rowid , * FROM `job`
--- a/sql/job-todo.sql Thu Aug 18 10:42:42 2022 +0200 +++ b/sql/job-todo.sql Thu Aug 18 12:18:12 2022 +0200 @@ -35,4 +35,4 @@ SELECT `worker`.`date` FROM `worker` WHERE `worker`.`name` = ? - ) + )
--- a/sql/jobresult-add.sql Thu Aug 18 10:42:42 2022 +0200 +++ b/sql/jobresult-add.sql Thu Aug 18 12:18:12 2022 +0200 @@ -16,7 +16,7 @@ -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. -- -INSERT INTO jobresult( +INSERT INTO `jobresult`( `job_id`, `worker_name`, `console`,
--- a/sql/jobresult-list-by-job-group.sql Thu Aug 18 10:42:42 2022 +0200 +++ b/sql/jobresult-list-by-job-group.sql Thu Aug 18 12:18:12 2022 +0200 @@ -1,3 +1,21 @@ +-- +-- jobresult-list-by-job-group.sql -- list most recent jobresults +-- +-- 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. +-- + SELECT rowid , * , MAX(`date`)
--- a/sql/jobresult-list-by-job.sql Thu Aug 18 10:42:42 2022 +0200 +++ b/sql/jobresult-list-by-job.sql Thu Aug 18 12:18:12 2022 +0200 @@ -1,3 +1,21 @@ +-- +-- jobresult-list-by-job.sql -- list most recent jobresults from a job +-- +-- 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. +-- + SELECT rowid , * FROM `jobresult`
--- a/sql/jobresult-list-by-worker.sql Thu Aug 18 10:42:42 2022 +0200 +++ b/sql/jobresult-list-by-worker.sql Thu Aug 18 12:18:12 2022 +0200 @@ -1,3 +1,21 @@ +-- +-- jobresult-list-by-worker.sql -- list all jobresults by a worker +-- +-- 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. +-- + SELECT rowid , * FROM `jobresult`
--- a/sql/property-get.sql Thu Aug 18 10:42:42 2022 +0200 +++ b/sql/property-get.sql Thu Aug 18 12:18:12 2022 +0200 @@ -1,3 +1,21 @@ +-- +-- property-get.sql -- retrieve a property value +-- +-- 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. +-- + SELECT `value` FROM `property` WHERE `key` = ?
--- a/sql/property-set.sql Thu Aug 18 10:42:42 2022 +0200 +++ b/sql/property-set.sql Thu Aug 18 12:18:12 2022 +0200 @@ -1,3 +1,21 @@ +-- +-- property-set.sql -- set (or replace) a property +-- +-- 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. +-- + REPLACE INTO `property` (