sokwedb
20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

20 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.

20 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

20 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

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

20 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

20 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

20 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

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

20 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.

20 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

20 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

20 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

20 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

20 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

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

20 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

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

20 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

20 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

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

20 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

20 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

20 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

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

20 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

20 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`.

20 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

20 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

20 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

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

20 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

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

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

20 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

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

20 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

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

20 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

20 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

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

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

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

20 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

20 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

20 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

20 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

20 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

20 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

20 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

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

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

20 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

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

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

20 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

20 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

20 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

20 months 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

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

20 months 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

20 months 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

21 months 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

21 months 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

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

21 months 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.

21 months 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.

21 months 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

21 months 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

21 months 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

21 months 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

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

21 months 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

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

21 months 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

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

21 months 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

21 months 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

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

21 months 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

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

21 months 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

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

21 months 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`

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

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

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

22 months 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

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

2 years agoMore docs on using help.mk
Karl O. Pinc [Sun, 4 Jun 2023 20:50:07 +0000 (15:50 -0500)]
More docs on using help.mk

2 years agoMore docs on the build process
Karl O. Pinc [Sat, 3 Jun 2023 23:57:26 +0000 (18:57 -0500)]
More docs on the build process

2 years agoTypo in comment
Karl O. Pinc [Sat, 3 Jun 2023 23:32:50 +0000 (18:32 -0500)]
Typo in comment