searl_sokwedb
23 months agoSimplify logic
Karl O. Pinc [Sun, 1 Oct 2023 21:29:51 +0000 (16:29 -0500)]
Simplify logic

23 months agoReformat with black
Karl O. Pinc [Sun, 1 Oct 2023 21:23:39 +0000 (16:23 -0500)]
Reformat with black

23 months agoMove make documentation above make db
Karl O. Pinc [Sun, 1 Oct 2023 21:16:49 +0000 (16:16 -0500)]
Move make documentation above make db

This is necessary or making the db comments won't work, they depend
on $(HTML_RST_FILES) being defined when the comments are collected.

23 months agoDirectories must exist before the RST can
Karl O. Pinc [Sun, 1 Oct 2023 21:16:34 +0000 (16:16 -0500)]
Directories must exist before the RST can

23 months agoPut dependencies in the right order
Karl O. Pinc [Sun, 1 Oct 2023 21:03:11 +0000 (16:03 -0500)]
Put dependencies in the right order

23 months agoMove secondexpansion make code into it's own file
Karl O. Pinc [Sun, 1 Oct 2023 20:48:06 +0000 (15:48 -0500)]
Move secondexpansion make code into it's own file

23 months agoPut cluster creation stuff in it's own file
Karl O. Pinc [Sun, 1 Oct 2023 20:44:12 +0000 (15:44 -0500)]
Put cluster creation stuff in it's own file

23 months agoGive the database connection variables their own doc heading
Karl O. Pinc [Sun, 1 Oct 2023 20:37:59 +0000 (15:37 -0500)]
Give the database connection variables their own doc heading

23 months agoAdd dependencies everywhere psql is called
Karl O. Pinc [Sun, 1 Oct 2023 20:22:58 +0000 (15:22 -0500)]
Add dependencies everywhere psql is called

23 months agoAdd db comments for columns
Karl O. Pinc [Sun, 1 Oct 2023 19:59:29 +0000 (14:59 -0500)]
Add db comments for columns

23 months agoColumn names should not contain underscores
Karl O. Pinc [Sun, 1 Oct 2023 19:57:19 +0000 (14:57 -0500)]
Column names should not contain underscores

23 months agoBasics of putting comments into the db
Karl O. Pinc [Sun, 1 Oct 2023 19:13:43 +0000 (14:13 -0500)]
Basics of putting comments into the db

23 months agoPut julian_to() into it's own file
Karl O. Pinc [Sun, 1 Oct 2023 19:06:43 +0000 (14:06 -0500)]
Put julian_to() into it's own file

The db commenting build system requires a file per function name.

23 months agoUse make function instead of shell function
Karl O. Pinc [Thu, 28 Sep 2023 13:01:10 +0000 (08:01 -0500)]
Use make function instead of shell function

23 months agoFix removal of leading empty lines
Karl O. Pinc [Thu, 28 Sep 2023 04:10:23 +0000 (23:10 -0500)]
Fix removal of leading empty lines

23 months agoBetter function documentation
Karl O. Pinc [Thu, 28 Sep 2023 04:09:46 +0000 (23:09 -0500)]
Better function documentation

23 months agoProvide overview of how to use the make system
Karl O. Pinc [Thu, 28 Sep 2023 02:55:35 +0000 (21:55 -0500)]
Provide overview of how to use the make system

23 months agoAdd table of contents to the doc's readme
Karl O. Pinc [Thu, 28 Sep 2023 02:28:07 +0000 (21:28 -0500)]
Add table of contents to the doc's readme

23 months agoThere is no master shell script to make and configure databases
Karl O. Pinc [Wed, 27 Sep 2023 22:37:56 +0000 (17:37 -0500)]
There is no master shell script to make and configure databases

23 months agoReformat with black
Karl O. Pinc [Wed, 20 Sep 2023 16:16:42 +0000 (11:16 -0500)]
Reformat with black

23 months agoBuild triggers after views
Karl O. Pinc [Wed, 20 Sep 2023 15:59:14 +0000 (10:59 -0500)]
Build triggers after views

That way we can put triggers on views in the triggers directory.
We could have a separate "catagory" just for triggers on views,
but that introduces complication for no real benefit.

23 months agoMove generated doc files into sphinx-doc directory
Karl O. Pinc [Mon, 18 Sep 2023 22:08:08 +0000 (17:08 -0500)]
Move generated doc files into sphinx-doc directory

23 months agoSupport including view definitions into the documentation
Karl O. Pinc [Mon, 18 Sep 2023 21:37:29 +0000 (16:37 -0500)]
Support including view definitions into the documentation

23 months agoCombine 2 targets into one line
Karl O. Pinc [Mon, 18 Sep 2023 21:35:53 +0000 (16:35 -0500)]
Combine 2 targets into one line

23 months agoVariable for latex (pdf) prerequeistes
Karl O. Pinc [Mon, 18 Sep 2023 19:48:13 +0000 (14:48 -0500)]
Variable for latex (pdf) prerequeistes

23 months agoImprove cluster creation docs after review with Stevan
Karl O. Pinc [Sun, 17 Sep 2023 13:33:11 +0000 (08:33 -0500)]
Improve cluster creation docs after review with Stevan

23 months agoMake doc indentation consistant
Karl O. Pinc [Sat, 16 Sep 2023 22:36:00 +0000 (17:36 -0500)]
Make doc indentation consistant

23 months agofix: ensure consistent db config file sorting
Stevan Earl [Sat, 16 Sep 2023 19:51:43 +0000 (12:51 -0700)]
fix: ensure consistent db config file sorting

23 months agofix: spacing
Stevan Earl [Sat, 16 Sep 2023 19:42:09 +0000 (12:42 -0700)]
fix: spacing

23 months agofix: configuration name default_transaction_isolation
Stevan Earl [Sat, 16 Sep 2023 19:17:00 +0000 (12:17 -0700)]
fix: configuration name default_transaction_isolation

23 months agoAdd comments to explain what's generated
Karl O. Pinc [Sat, 16 Sep 2023 18:00:45 +0000 (13:00 -0500)]
Add comments to explain what's generated

23 months agoFix line length
Karl O. Pinc [Sat, 16 Sep 2023 17:51:17 +0000 (12:51 -0500)]
Fix line length

23 months agoDo not alter the stored configurations on error
Karl O. Pinc [Fri, 15 Sep 2023 23:49:53 +0000 (18:49 -0500)]
Do not alter the stored configurations on error

23 months agoCommit the expected Azure server configs to revision control
Ubuntu [Fri, 15 Sep 2023 23:23:29 +0000 (23:23 +0000)]
Commit the expected Azure server configs to revision control

23 months agoNew targets for comparing Azure PG server configuration
Ubuntu [Fri, 15 Sep 2023 23:22:51 +0000 (23:22 +0000)]
New targets for comparing Azure PG server configuration

23 months agoImprove config diff docs
Ubuntu [Fri, 15 Sep 2023 21:55:48 +0000 (21:55 +0000)]
Improve config diff docs

23 months agoCommit expected PG Azure db settings to revision control
Ubuntu [Fri, 15 Sep 2023 21:17:23 +0000 (21:17 +0000)]
Commit expected PG Azure db settings to revision control

23 months agoFix compare-db-settings to work with Azure
Ubuntu [Fri, 15 Sep 2023 21:08:51 +0000 (21:08 +0000)]
Fix compare-db-settings to work with Azure

For some reason on Azure's Postgres flexible-server PGv15 the
SQL

SELECT name, setting, unit, pending_restart \
                     FROM pg_settings \
                     ORDER BY name;

Does not return a consistent ordering when run on different databases
on the same PG server.  So run the output through `sort`.

23 months agoAdd pending_restart column to compare-db-settings
Ubuntu [Fri, 15 Sep 2023 21:05:18 +0000 (21:05 +0000)]
Add pending_restart column to compare-db-settings

23 months agoFix use of psql_setup.sh
Ubuntu [Fri, 15 Sep 2023 20:31:44 +0000 (20:31 +0000)]
Fix use of psql_setup.sh

23 months agoNew targets for comparing db configurations
Karl O. Pinc [Fri, 15 Sep 2023 20:03:24 +0000 (15:03 -0500)]
New targets for comparing db configurations

23 months agoDocumentation formatting
Karl O. Pinc [Thu, 14 Sep 2023 19:29:31 +0000 (14:29 -0500)]
Documentation formatting

23 months agoAdd targets for building cluster hosts on Azure
Ubuntu [Thu, 14 Sep 2023 19:08:12 +0000 (19:08 +0000)]
Add targets for building cluster hosts on Azure

23 months agoFix footnote numbering
Karl O. Pinc [Thu, 14 Sep 2023 15:09:13 +0000 (10:09 -0500)]
Fix footnote numbering

23 months agoFix punctuation
Karl O. Pinc [Thu, 14 Sep 2023 15:04:42 +0000 (10:04 -0500)]
Fix punctuation

23 months agoSet the default transaction isolation to serializable
Karl O. Pinc [Thu, 14 Sep 2023 14:54:11 +0000 (09:54 -0500)]
Set the default transaction isolation to serializable

23 months agoAvoid hardcoding in Makefiles
Karl O. Pinc [Thu, 14 Sep 2023 13:32:11 +0000 (08:32 -0500)]
Avoid hardcoding in Makefiles

23 months agoSet default time zone in cluster setup
Karl O. Pinc [Wed, 13 Sep 2023 22:18:07 +0000 (17:18 -0500)]
Set default time zone in cluster setup

23 months agoBetter comment
Karl O. Pinc [Wed, 13 Sep 2023 20:35:24 +0000 (15:35 -0500)]
Better comment

23 months agoDrop the PUBLIC schema with a cluster initialization target
Karl O. Pinc [Wed, 13 Sep 2023 20:15:50 +0000 (15:15 -0500)]
Drop the PUBLIC schema with a cluster initialization target

23 months agoAdd comments to SokweDB group roles
Karl O. Pinc [Wed, 13 Sep 2023 15:11:01 +0000 (10:11 -0500)]
Add comments to SokweDB group roles

23 months agoBetter superuser docs
Karl O. Pinc [Wed, 13 Sep 2023 14:53:37 +0000 (09:53 -0500)]
Better superuser docs

23 months agoImprove docs
Karl O. Pinc [Wed, 13 Sep 2023 14:42:29 +0000 (09:42 -0500)]
Improve docs

23 months agoBetter docs for macro
Karl O. Pinc [Tue, 12 Sep 2023 23:44:43 +0000 (18:44 -0500)]
Better docs for macro

23 months agoAvoid spurious newlines in generated RST
Karl O. Pinc [Tue, 12 Sep 2023 23:43:41 +0000 (18:43 -0500)]
Avoid spurious newlines in generated RST

23 months agoRemove files used in attempt to match input lines with lines reported in pl/pgsql...
Karl O. Pinc [Tue, 12 Sep 2023 20:38:13 +0000 (15:38 -0500)]
Remove files used in attempt to match input lines with lines reported in pl/pgsql errors

23 months agoRequire new databases have a commnt
Karl O. Pinc [Tue, 12 Sep 2023 18:03:14 +0000 (13:03 -0500)]
Require new databases have a commnt

23 months agoMake all the group-ish roles during cluster setup
Karl O. Pinc [Tue, 12 Sep 2023 17:34:55 +0000 (12:34 -0500)]
Make all the group-ish roles during cluster setup

23 months agoAdjust permission system for Azure's lack of the SUPERUSER role property
Karl O. Pinc [Tue, 12 Sep 2023 17:16:38 +0000 (12:16 -0500)]
Adjust permission system for Azure's lack of the SUPERUSER role property

23 months agoKludge to work-around lack of SUPERUSER role properties when vacuuming
Karl O. Pinc [Mon, 11 Sep 2023 23:22:31 +0000 (18:22 -0500)]
Kludge to work-around lack of SUPERUSER role properties when vacuuming

23 months agoDocument date input and output formats
Karl O. Pinc [Mon, 11 Sep 2023 21:44:18 +0000 (16:44 -0500)]
Document date input and output formats

23 months agoGrant permissions to sequences
Karl O. Pinc [Mon, 11 Sep 2023 00:18:04 +0000 (19:18 -0500)]
Grant permissions to sequences

23 months agoRemove unused (macro) types
Karl O. Pinc [Mon, 11 Sep 2023 00:12:17 +0000 (19:12 -0500)]
Remove unused (macro) types

23 months agoThe unknown individual can't be deleted or altered by regular users
Karl O. Pinc [Mon, 11 Sep 2023 00:10:46 +0000 (19:10 -0500)]
The unknown individual can't be deleted or altered by regular users

23 months agoImprove description
Karl O. Pinc [Mon, 11 Sep 2023 00:09:08 +0000 (19:09 -0500)]
Improve description

23 months agoFix link anchors
Karl O. Pinc [Mon, 11 Sep 2023 00:08:39 +0000 (19:08 -0500)]
Fix link anchors

23 months agoGive macros dealing with speical values better names
Karl O. Pinc [Sun, 10 Sep 2023 19:32:26 +0000 (14:32 -0500)]
Give macros dealing with speical values better names

23 months agoFix connection db in hint
Karl O. Pinc [Sun, 10 Sep 2023 19:31:49 +0000 (14:31 -0500)]
Fix connection db in hint

23 months agoFix column name in error message
Karl O. Pinc [Sun, 10 Sep 2023 19:24:08 +0000 (14:24 -0500)]
Fix column name in error message

2 years agoAdd create-adminuser-root target to build system
Karl O. Pinc [Fri, 8 Sep 2023 22:06:52 +0000 (17:06 -0500)]
Add create-adminuser-root target to build system

2 years agoAdd set-password build target
Karl O. Pinc [Fri, 8 Sep 2023 21:46:50 +0000 (16:46 -0500)]
Add set-password build target

2 years agoBeginnings of a cluster initialization build setup
Karl O. Pinc [Fri, 8 Sep 2023 21:35:28 +0000 (16:35 -0500)]
Beginnings of a cluster initialization build setup

2 years agoChange variable name from SOKWEDB_DB to TARGET_DB
Karl O. Pinc [Fri, 8 Sep 2023 19:15:41 +0000 (14:15 -0500)]
Change variable name from SOKWEDB_DB to TARGET_DB

2 years agoQualify the login with a (short) hostname for azure
Ubuntu [Thu, 7 Sep 2023 22:24:31 +0000 (22:24 +0000)]
Qualify the login with a (short) hostname for azure

2 years agoNo reason to expand PSQL_ARGS_MINIMAL dynamically
Ubuntu [Thu, 7 Sep 2023 21:55:00 +0000 (21:55 +0000)]
No reason to expand PSQL_ARGS_MINIMAL dynamically

2 years agoFix spelling of azure pg host
Ubuntu [Thu, 7 Sep 2023 21:50:57 +0000 (21:50 +0000)]
Fix spelling of azure pg host

2 years agoTake $(ORDER) out of the dependencies
Ubuntu [Thu, 7 Sep 2023 21:42:06 +0000 (21:42 +0000)]
Take $(ORDER) out of the dependencies

No point.  Plus some schemas don't yet exist under revision control.

2 years agoInitial database construction
Karl O. Pinc [Thu, 7 Sep 2023 21:28:46 +0000 (16:28 -0500)]
Initial database construction

This includes creation of a build system as well as tables, triggers, etc.
that create some initial demographic database objects.  Also included
are some changes to the documentation which include additional database
validation rules.

2 years agoFiddle with m4 include path resolution
Karl O. Pinc [Tue, 5 Sep 2023 20:09:33 +0000 (15:09 -0500)]
Fiddle with m4 include path resolution

2 years agoUse $CMD_TARGETS instead of $TARGETS for uniqueness among include files
Karl O. Pinc [Mon, 4 Sep 2023 18:06:44 +0000 (13:06 -0500)]
Use $CMD_TARGETS instead of $TARGETS for uniqueness among include files

2 years agoExplain the use of PEOPLE.Active
Karl O. Pinc [Mon, 4 Sep 2023 18:03:49 +0000 (13:03 -0500)]
Explain the use of PEOPLE.Active

2 years agoAdd command installation to build system
Karl O. Pinc [Sun, 3 Sep 2023 20:58:22 +0000 (15:58 -0500)]
Add command installation to build system

2 years agoSupport creations and deletions
Karl O. Pinc [Sun, 3 Sep 2023 19:50:01 +0000 (14:50 -0500)]
Support creations and deletions

2 years agoScript to send email notifications of git push-s
Karl O. Pinc [Sun, 3 Sep 2023 16:49:55 +0000 (11:49 -0500)]
Script to send email notifications of git push-s

2 years agoDocument the PEOPLE.Active column
Karl O. Pinc [Fri, 1 Sep 2023 17:13:42 +0000 (12:13 -0500)]
Document the PEOPLE.Active column

2 years agoAdd replacement for the boolean data type
Karl O. Pinc [Fri, 1 Sep 2023 17:13:03 +0000 (12:13 -0500)]
Add replacement for the boolean data type

2 years agoProvide function descriptions
Karl O. Pinc [Fri, 1 Sep 2023 16:21:53 +0000 (11:21 -0500)]
Provide function descriptions

2 years agoUse the Sphinx replace directive for function link references
Karl O. Pinc [Thu, 31 Aug 2023 22:18:19 +0000 (17:18 -0500)]
Use the Sphinx replace directive for function link references

2 years agoWe're not using underscores before ID in column names
Karl O. Pinc [Thu, 31 Aug 2023 22:18:13 +0000 (17:18 -0500)]
We're not using underscores before ID in column names

2 years agoFix link text for DEPARTTYPES
Karl O. Pinc [Thu, 31 Aug 2023 14:04:03 +0000 (09:04 -0500)]
Fix link text for DEPARTTYPES

2 years agoAdd doc section for functions; julian() and julian_to() functions
Karl O. Pinc [Wed, 30 Aug 2023 17:54:17 +0000 (12:54 -0500)]
Add doc section for functions; julian() and julian_to() functions

2 years agoFix link anchor
Karl O. Pinc [Wed, 30 Aug 2023 17:52:16 +0000 (12:52 -0500)]
Fix link anchor

2 years agoFix so setting $LOCALHTML supports change of image format
Karl O. Pinc [Tue, 22 Aug 2023 07:47:23 +0000 (02:47 -0500)]
Fix so setting $LOCALHTML supports change of image format

2 years agoBreak overlong line
Karl O. Pinc [Tue, 22 Aug 2023 07:42:06 +0000 (02:42 -0500)]
Break overlong line

2 years agoFix so images build after `make clean`
Karl O. Pinc [Tue, 22 Aug 2023 07:17:26 +0000 (02:17 -0500)]
Fix so images build after `make clean`

2 years agoTypeo in comment
Karl O. Pinc [Tue, 22 Aug 2023 07:16:29 +0000 (02:16 -0500)]
Typeo in comment

2 years agoFix full copyright statement
Karl O. Pinc [Fri, 28 Jul 2023 21:59:34 +0000 (16:59 -0500)]
Fix full copyright statement

2 years agoChange macro prefix to sdb_
Karl O. Pinc [Fri, 28 Jul 2023 21:40:24 +0000 (16:40 -0500)]
Change macro prefix to sdb_

2 years agoMerge branch 'master' of ssh://sokwe.janegoodall.org/srv/repos/sokwedb
Karl O. Pinc [Thu, 27 Jul 2023 22:18:46 +0000 (17:18 -0500)]
Merge branch 'master' of ssh://sokwe.janegoodall.org/srv/repos/sokwedb

Merge Stephan's update of the sphinx requirements

2 years agofeat: update requirements
Stevan [Wed, 26 Jul 2023 22:29:40 +0000 (22:29 +0000)]
feat: update requirements