# HG changeset patch # User David Demelier # Date 1660817892 -7200 # Node ID eaebcc612a0dae419b05dcc54176101ecc605f93 # Parent 8be8188d61a5467dcf9b771910c7ded1dfbc56cc misc: add header in SQL files diff -r 8be8188d61a5 -r eaebcc612a0d sql/init.sql --- 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 ); diff -r 8be8188d61a5 -r eaebcc612a0d sql/job-list.sql --- 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 +-- +-- 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` diff -r 8be8188d61a5 -r eaebcc612a0d sql/job-todo.sql --- 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` = ? - ) + ) diff -r 8be8188d61a5 -r eaebcc612a0d sql/jobresult-add.sql --- 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`, diff -r 8be8188d61a5 -r eaebcc612a0d sql/jobresult-list-by-job-group.sql --- 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 +-- +-- 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`) diff -r 8be8188d61a5 -r eaebcc612a0d sql/jobresult-list-by-job.sql --- 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 +-- +-- 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` diff -r 8be8188d61a5 -r eaebcc612a0d sql/jobresult-list-by-worker.sql --- 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 +-- +-- 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` diff -r 8be8188d61a5 -r eaebcc612a0d sql/property-get.sql --- 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 +-- +-- 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` = ? diff -r 8be8188d61a5 -r eaebcc612a0d sql/property-set.sql --- 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 +-- +-- 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` (