sokwedb
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

2 years agoDocument how to use help.mk
Karl O. Pinc [Sat, 3 Jun 2023 23:14:59 +0000 (18:14 -0500)]
Document how to use help.mk

2 years agoReorganize makefiles to distinguish doc from db building
Karl O. Pinc [Sat, 3 Jun 2023 23:14:43 +0000 (18:14 -0500)]
Reorganize makefiles to distinguish doc from db building

2 years agoBegin to document tables
Karl O. Pinc [Thu, 1 Jun 2023 23:04:00 +0000 (18:04 -0500)]
Begin to document tables

Improve the introduction sub-sections and special values.  Introduce
some code tables.  Document BIOGRAPHY, COMM_MEMBS, and COMM_MEMBS_LOG.

2 years agoThe key column of each support table is unique
Karl O. Pinc [Thu, 1 Jun 2023 18:26:39 +0000 (13:26 -0500)]
The key column of each support table is unique

2 years agoMore conventions used when writing docs
Karl O. Pinc [Thu, 1 Jun 2023 18:22:41 +0000 (13:22 -0500)]
More conventions used when writing docs

2 years agoStandardize on an RST section "underline" scheme
Karl O. Pinc [Wed, 31 May 2023 19:49:11 +0000 (14:49 -0500)]
Standardize on an RST section "underline" scheme

2 years agoMore documentation on the system's design and correct use
Karl O. Pinc [Tue, 30 May 2023 22:49:57 +0000 (17:49 -0500)]
More documentation on the system's design and correct use

2 years agoDatabase files use shared constants
Karl O. Pinc [Tue, 30 May 2023 22:19:32 +0000 (17:19 -0500)]
Database files use shared constants

2 years agoAdd to docs on introduction, architecture, and an appendix
Karl O. Pinc [Sun, 28 May 2023 22:21:39 +0000 (17:21 -0500)]
Add to docs on introduction, architecture, and an appendix

2 years agoHelper program for footnote numbering
Karl O. Pinc [Sun, 28 May 2023 19:21:40 +0000 (14:21 -0500)]
Helper program for footnote numbering

2 years agoRemove statement about unknown GPS coordinate system
Karl O. Pinc [Sun, 28 May 2023 18:08:43 +0000 (13:08 -0500)]
Remove statement about unknown GPS coordinate system

2 years agoAdd images to generated documentation
Karl O. Pinc [Sun, 21 May 2023 16:17:32 +0000 (11:17 -0500)]
Add images to generated documentation

Convert from dia to inkscape.  Drop a symlink to the image dir into
each of the sphinx source directories since sphinx urls are rooted
at the sphinx source directory.

2 years agoFiles used to develop the images on the wiki
Karl O. Pinc [Sun, 14 May 2023 19:40:11 +0000 (14:40 -0500)]
Files used to develop the images on the wiki

2 years agoAdd single-page html output
Karl O. Pinc [Wed, 10 May 2023 21:23:31 +0000 (16:23 -0500)]
Add single-page html output

2 years agoAdd README file
Karl O. Pinc [Wed, 10 May 2023 06:44:37 +0000 (01:44 -0500)]
Add README file

2 years agoAdd license file
Karl O. Pinc [Wed, 10 May 2023 06:42:51 +0000 (01:42 -0500)]
Add license file

2 years agoCreate the document root directory if necessary
Karl O. Pinc [Wed, 10 May 2023 06:04:06 +0000 (01:04 -0500)]
Create the document root directory if necessary

2 years agoUse a workable requirements.txt
Karl O. Pinc [Wed, 10 May 2023 05:50:54 +0000 (00:50 -0500)]
Use a workable requirements.txt

2 years agoWork-around a venv bug that breaks the generated requirements.txt
Karl O. Pinc [Wed, 10 May 2023 05:50:15 +0000 (00:50 -0500)]
Work-around a venv bug that breaks the generated requirements.txt

2 years agoChange URL paths for docs
Karl O. Pinc [Wed, 10 May 2023 03:34:25 +0000 (22:34 -0500)]
Change URL paths for docs

Have a separate dir for html within docs, as is required by the
process that copies the generated html because anything not generated
is removed.  And put the pdf documents in the doc directory.

2 years agoProduce both A4 and US-Letter pdfs
Karl O. Pinc [Wed, 10 May 2023 03:09:55 +0000 (22:09 -0500)]
Produce both A4 and US-Letter pdfs

2 years agoAdd support for different pdf paper size output
Karl O. Pinc [Wed, 10 May 2023 02:27:15 +0000 (21:27 -0500)]
Add support for different pdf paper size output

2 years agoMake pdf generation work
Karl O. Pinc [Wed, 10 May 2023 01:17:15 +0000 (20:17 -0500)]
Make pdf generation work

2 years agoKeep sphinx venv under revision control
Karl O. Pinc [Wed, 10 May 2023 00:55:27 +0000 (19:55 -0500)]
Keep sphinx venv under revision control

2 years agoImprove comments
Karl O. Pinc [Tue, 9 May 2023 23:57:19 +0000 (18:57 -0500)]
Improve comments

2 years agoDisplay page generation time in UTC
Karl O. Pinc [Tue, 9 May 2023 23:39:20 +0000 (18:39 -0500)]
Display page generation time in UTC

2 years agoSeparate target dirs for local and non-local html
Karl O. Pinc [Tue, 9 May 2023 22:11:20 +0000 (17:11 -0500)]
Separate target dirs for local and non-local html

Since local html now uses a html builder but non-local html uses
dirhtml, sharing a target directory results is "extra stuff"
leftover from the other kind of build.  We don't want that.

2 years agoBetter comment
Karl O. Pinc [Tue, 9 May 2023 21:58:04 +0000 (16:58 -0500)]
Better comment

2 years agoNo need for recursive expansion as source files are not dynamic
Karl O. Pinc [Tue, 9 May 2023 21:57:47 +0000 (16:57 -0500)]
No need for recursive expansion as source files are not dynamic

2 years agoBetter comment
Karl O. Pinc [Tue, 9 May 2023 21:54:11 +0000 (16:54 -0500)]
Better comment

2 years agoBetter variable names and comments
Karl O. Pinc [Tue, 9 May 2023 21:44:57 +0000 (16:44 -0500)]
Better variable names and comments

2 years agoGet rid of extra variable
Karl O. Pinc [Tue, 9 May 2023 21:43:36 +0000 (16:43 -0500)]
Get rid of extra variable

2 years agoBetter comments
Karl O. Pinc [Tue, 9 May 2023 21:31:42 +0000 (16:31 -0500)]
Better comments

2 years agoMove generated RST epilog files into doc/sphinx-doc/.
Karl O. Pinc [Tue, 9 May 2023 20:56:23 +0000 (15:56 -0500)]
Move generated RST epilog files into doc/sphinx-doc/.

2 years agoBuild system for text docs -- images not yet supported
Karl O. Pinc [Tue, 9 May 2023 16:49:33 +0000 (11:49 -0500)]
Build system for text docs -- images not yet supported