pgwui_core
7 months agoBump version number to 0.28.0 master
Karl O. Pinc [Mon, 21 Oct 2024 21:10:26 +0000 (16:10 -0500)]
Bump version number to 0.28.0

7 months agoBump version number to 0.27.0
Karl O. Pinc [Mon, 21 Oct 2024 14:48:39 +0000 (09:48 -0500)]
Bump version number to 0.27.0

7 months agoBump version number to 0.26.0
Karl O. Pinc [Thu, 10 Oct 2024 18:29:05 +0000 (13:29 -0500)]
Bump version number to 0.26.0

7 months agoAdd feature to upload missing column values as NULL
Karl O. Pinc [Thu, 10 Oct 2024 18:25:14 +0000 (13:25 -0500)]
Add feature to upload missing column values as NULL

7 months agoBump version number to 0.25.0
Karl O. Pinc [Tue, 8 Oct 2024 18:11:57 +0000 (13:11 -0500)]
Bump version number to 0.25.0

7 months agoBump version number to 0.24.0
Karl O. Pinc [Tue, 8 Oct 2024 17:28:47 +0000 (12:28 -0500)]
Bump version number to 0.24.0

7 months agoMake the "locals" dict always available for local template variables
Karl O. Pinc [Tue, 8 Oct 2024 16:57:49 +0000 (11:57 -0500)]
Make the "locals" dict always available for local template variables

8 months agoBump version number to 0.23.0
Karl O. Pinc [Sat, 5 Oct 2024 03:57:56 +0000 (22:57 -0500)]
Bump version number to 0.23.0

8 months agoBump version number to 0.22.0
Karl O. Pinc [Sat, 5 Oct 2024 01:13:02 +0000 (20:13 -0500)]
Bump version number to 0.22.0

8 months agoBump version number to 0.21.0
Karl O. Pinc [Fri, 4 Oct 2024 20:55:23 +0000 (15:55 -0500)]
Bump version number to 0.21.0

8 months agoBump version number to 0.20.0
Karl O. Pinc [Fri, 4 Oct 2024 20:50:27 +0000 (15:50 -0500)]
Bump version number to 0.20.0

8 months agoInstall the extra testing dependencies when testing
Karl O. Pinc [Fri, 4 Oct 2024 20:41:22 +0000 (15:41 -0500)]
Install the extra testing dependencies when testing

8 months agoHTML does not require the "checked" attribute have a value
Karl O. Pinc [Tue, 24 Sep 2024 22:43:26 +0000 (17:43 -0500)]
HTML does not require the "checked" attribute have a value

8 months agoSupport executing SQL that returns rows
Karl O. Pinc [Sat, 14 Sep 2024 23:04:33 +0000 (18:04 -0500)]
Support executing SQL that returns rows

8 months agoMove pgwui_core SQL related code into it's own module
Karl O. Pinc [Sat, 14 Sep 2024 03:22:37 +0000 (22:22 -0500)]
Move pgwui_core SQL related code into it's own module

8 months agopg_host and pg_port are always added by pgwui_server
Karl O. Pinc [Sat, 14 Sep 2024 03:19:44 +0000 (22:19 -0500)]
pg_host and pg_port are always added by pgwui_server

9 months agoGenerate new CRSF token once per session instead of per request
Karl O. Pinc [Tue, 27 Aug 2024 23:44:39 +0000 (18:44 -0500)]
Generate new CRSF token once per session instead of per request

It is tempting to generate the token once per request and have
multiple windows in the browser share the token via javascript's
session local storage.  But there are a number of race conditions,
including not being able to submit a new request in the interval
between the server sending a response and the browser receiving
the response.  Per-request CSRF tokens are just too much bother
for what you get.

9 months agoBump version number to 0.19.0
Karl O. Pinc [Tue, 20 Aug 2024 19:55:38 +0000 (14:55 -0500)]
Bump version number to 0.19.0

9 months agoBump version number to 0.18.0
Karl O. Pinc [Mon, 19 Aug 2024 19:48:11 +0000 (14:48 -0500)]
Bump version number to 0.18.0

9 months agoHave a separate module for forms
Karl O. Pinc [Tue, 13 Aug 2024 17:06:24 +0000 (12:06 -0500)]
Have a separate module for forms

10 months agoBump version number to 0.17.0
Karl O. Pinc [Mon, 5 Aug 2024 17:50:14 +0000 (12:50 -0500)]
Bump version number to 0.17.0

10 months agoBump version number to 0.16.0
Karl O. Pinc [Mon, 5 Aug 2024 17:04:50 +0000 (12:04 -0500)]
Bump version number to 0.16.0

10 months agoFix double-upload test by handling boolean post values
Karl O. Pinc [Mon, 5 Aug 2024 16:59:54 +0000 (11:59 -0500)]
Fix double-upload test by handling boolean post values

10 months agoMove core utility functions into a separate module
Karl O. Pinc [Tue, 16 Jul 2024 22:08:36 +0000 (17:08 -0500)]
Move core utility functions into a separate module

10 months agoConsistently use full path to refer to psycopg error classes
Karl O. Pinc [Tue, 16 Jul 2024 22:07:05 +0000 (17:07 -0500)]
Consistently use full path to refer to psycopg error classes

10 months agoImprove double-upload detection
Karl O. Pinc [Tue, 16 Jul 2024 18:50:34 +0000 (13:50 -0500)]
Improve double-upload detection

Fix false positive after loss of session (CSRF failure, etc.)
Detect after reload of form by pressing "enter" in the URL bar.
Detect after navigating to another PGWUI menu item and back.

10 months agoRefactor to support state kept in both POST and session
Karl O. Pinc [Tue, 16 Jul 2024 18:48:48 +0000 (13:48 -0500)]
Refactor to support state kept in both POST and session

10 months agoThe reload button can also be used to re-submit an old form
Karl O. Pinc [Sun, 14 Jul 2024 23:56:11 +0000 (18:56 -0500)]
The reload button can also be used to re-submit an old form

10 months agoImproved internal docs
Karl O. Pinc [Sun, 14 Jul 2024 03:08:47 +0000 (22:08 -0500)]
Improved internal docs

10 months agoImproved python
Karl O. Pinc [Sun, 14 Jul 2024 03:07:59 +0000 (22:07 -0500)]
Improved python

11 months agoBump version number to 0.15.0
Karl O. Pinc [Sun, 23 Jun 2024 02:06:59 +0000 (21:06 -0500)]
Bump version number to 0.15.0

11 months agoAvoid crash when a psycopg DatabaseError has no info from the db
Karl O. Pinc [Sat, 22 Jun 2024 04:21:32 +0000 (23:21 -0500)]
Avoid crash when a psycopg DatabaseError has no info from the db

11 months agopsycopg2 -> psycopg3 API change
Karl O. Pinc [Sat, 22 Jun 2024 03:38:33 +0000 (22:38 -0500)]
psycopg2 -> psycopg3 API change

11 months agoUse immediate assignments
Karl O. Pinc [Sat, 22 Jun 2024 03:21:04 +0000 (22:21 -0500)]
Use immediate assignments

11 months agoAdjust for YAML config booleans being actual booleans
Karl O. Pinc [Sat, 22 Jun 2024 03:05:14 +0000 (22:05 -0500)]
Adjust for YAML config booleans being actual booleans

11 months agoFix conditional yamllint execution
Karl O. Pinc [Fri, 21 Jun 2024 23:10:57 +0000 (18:10 -0500)]
Fix conditional yamllint execution

11 months agoAvoid rebuilding packages when running check targets
Karl O. Pinc [Fri, 21 Jun 2024 23:10:00 +0000 (18:10 -0500)]
Avoid rebuilding packages when running check targets

11 months agoRun yamllint when checking
Karl O. Pinc [Fri, 21 Jun 2024 19:28:14 +0000 (14:28 -0500)]
Run yamllint when checking

11 months agoBetter class docs
Karl O. Pinc [Wed, 19 Jun 2024 22:43:14 +0000 (17:43 -0500)]
Better class docs

14 months agoBump version number to 0.14.0
Karl O. Pinc [Thu, 28 Mar 2024 21:40:49 +0000 (16:40 -0500)]
Bump version number to 0.14.0

14 months agoUse "build" to build packages; add a pyproject.toml file
Karl O. Pinc [Thu, 28 Mar 2024 03:34:08 +0000 (22:34 -0500)]
Use "build" to build packages; add a pyproject.toml file

14 months agoDrop "register" targets; no longer supported at pypi
Karl O. Pinc [Sun, 24 Mar 2024 22:37:59 +0000 (17:37 -0500)]
Drop "register" targets; no longer supported at pypi

See: https://github.com/pypi/warehouse/issues/1627

14 months agoBump version number to 0.13.0
Karl O. Pinc [Fri, 22 Mar 2024 20:31:20 +0000 (15:31 -0500)]
Bump version number to 0.13.0

14 months agoUse new attrs syntax
Karl O. Pinc [Thu, 21 Mar 2024 23:51:12 +0000 (18:51 -0500)]
Use new attrs syntax

14 months agoRemove unneeded __future__ imports
Karl O. Pinc [Mon, 18 Mar 2024 22:23:34 +0000 (17:23 -0500)]
Remove unneeded __future__ imports

14 months agoChange super() calls from python2 style to python3
Karl O. Pinc [Mon, 18 Mar 2024 21:50:00 +0000 (16:50 -0500)]
Change super() calls from python2 style to python3

15 months agoDrop Python 3.6 support; psycopg3 does not support it
Karl O. Pinc [Tue, 5 Mar 2024 22:11:53 +0000 (16:11 -0600)]
Drop Python 3.6 support; psycopg3 does not support it

15 months agoTrap and do basic reporting on encoding exceptions, both client and server-side
Karl O. Pinc [Tue, 5 Mar 2024 21:07:35 +0000 (15:07 -0600)]
Trap and do basic reporting on encoding exceptions, both client and server-side

15 months agoDocument restrictions on ParameterExecutor() use
Karl O. Pinc [Tue, 5 Mar 2024 21:07:22 +0000 (15:07 -0600)]
Document restrictions on ParameterExecutor() use

15 months agoFix typo in UntranslatableCharacter exception name
Karl O. Pinc [Tue, 5 Mar 2024 21:06:29 +0000 (15:06 -0600)]
Fix typo in UntranslatableCharacter exception name

15 months agocall_alter_db() -> _call_alter_db(): name as internal-use only function
Karl O. Pinc [Sun, 3 Mar 2024 20:11:44 +0000 (14:11 -0600)]
call_alter_db() -> _call_alter_db(): name as internal-use only function

15 months agoUse the new attrs API on SQLCommand classes
Karl O. Pinc [Sat, 2 Mar 2024 22:53:37 +0000 (16:53 -0600)]
Use the new attrs API on SQLCommand classes

15 months agoRefactor encoding errors when using parameterized sql
Karl O. Pinc [Sat, 24 Feb 2024 02:14:02 +0000 (20:14 -0600)]
Refactor encoding errors when using parameterized sql

15 months agoSet client-side connection encoding
Karl O. Pinc [Fri, 23 Feb 2024 20:29:53 +0000 (14:29 -0600)]
Set client-side connection encoding

15 months agoBetter code formatting
Karl O. Pinc [Fri, 23 Feb 2024 16:42:54 +0000 (10:42 -0600)]
Better code formatting

15 months agoUpgrade from psycopg2 to psycopg3; drop python <= v3.5, add v3.8-v3.11
Karl O. Pinc [Fri, 23 Feb 2024 16:42:34 +0000 (10:42 -0600)]
Upgrade from psycopg2 to psycopg3; drop python <= v3.5, add v3.8-v3.11

15 months agoSwitch from the depreciated cgi module to the html module
Karl O. Pinc [Fri, 23 Feb 2024 15:59:13 +0000 (09:59 -0600)]
Switch from the depreciated cgi module to the html module

4 years agoBump version number to 0.12.0
Karl O. Pinc [Thu, 3 Jun 2021 16:44:10 +0000 (11:44 -0500)]
Bump version number to 0.12.0

4 years agoContinue processing file after an encoding error is found
Karl O. Pinc [Thu, 3 Jun 2021 16:42:40 +0000 (11:42 -0500)]
Continue processing file after an encoding error is found

4 years agoConsolidate exception handling
Karl O. Pinc [Thu, 3 Jun 2021 16:13:36 +0000 (11:13 -0500)]
Consolidate exception handling

4 years agoBump version number to 0.11.0
Karl O. Pinc [Sun, 30 May 2021 06:20:11 +0000 (01:20 -0500)]
Bump version number to 0.11.0

4 years agoTrap errors when translating into the db's encoding
Karl O. Pinc [Sun, 30 May 2021 06:18:10 +0000 (01:18 -0500)]
Trap errors when translating into the db's encoding

4 years agoBump version number to 0.10.0
Karl O. Pinc [Sun, 9 May 2021 21:50:00 +0000 (16:50 -0500)]
Bump version number to 0.10.0

4 years agoUse session to track whether login credentials are good
Karl O. Pinc [Sun, 9 May 2021 21:49:17 +0000 (16:49 -0500)]
Use session to track whether login credentials are good

4 years agoBetter code
Karl O. Pinc [Fri, 30 Apr 2021 04:04:05 +0000 (23:04 -0500)]
Better code

4 years agoTrap and report db errors during setup, i.e., factory creation
Karl O. Pinc [Thu, 29 Apr 2021 22:53:35 +0000 (17:53 -0500)]
Trap and report db errors during setup, i.e., factory creation

4 years agoName exception SetupError instead of Error
Karl O. Pinc [Wed, 28 Apr 2021 23:54:25 +0000 (18:54 -0500)]
Name exception SetupError instead of Error

4 years agoSpelling
Karl O. Pinc [Fri, 23 Apr 2021 21:40:40 +0000 (16:40 -0500)]
Spelling

4 years agoCatch all errors (!)
Karl O. Pinc [Fri, 23 Apr 2021 21:10:52 +0000 (16:10 -0500)]
Catch all errors (!)

4 years agoChange component name from pgwui_testing to pgwui_develop
Karl O. Pinc [Tue, 26 Jan 2021 03:30:16 +0000 (21:30 -0600)]
Change component name from pgwui_testing to pgwui_develop

4 years agoBump version number to 0.9.0
Karl O. Pinc [Sun, 24 Jan 2021 05:52:13 +0000 (23:52 -0600)]
Bump version number to 0.9.0

4 years agoAdd the table as a mixin to the initial post
Karl O. Pinc [Sun, 24 Jan 2021 05:49:55 +0000 (23:49 -0600)]
Add the table as a mixin to the initial post

4 years agoBump version number to 0.8.0
Karl O. Pinc [Sun, 24 Jan 2021 02:40:31 +0000 (20:40 -0600)]
Bump version number to 0.8.0

4 years agoUpdate copyright statements
Karl O. Pinc [Sat, 23 Jan 2021 22:27:39 +0000 (16:27 -0600)]
Update copyright statements

4 years agoAttach the initial post to my form class, not WTForms' class
Karl O. Pinc [Sat, 23 Jan 2021 04:48:30 +0000 (22:48 -0600)]
Attach the initial post to my form class, not WTForms' class

4 years agoUse attrs and modernize form classes
Karl O. Pinc [Sat, 23 Jan 2021 02:49:41 +0000 (20:49 -0600)]
Use attrs and modernize form classes

4 years agoModernize initial form value classes with attrs module
Karl O. Pinc [Fri, 22 Jan 2021 19:28:04 +0000 (13:28 -0600)]
Modernize initial form value classes with attrs module

4 years agoInstantiate initial form values when form is instantiated (at startup)
Karl O. Pinc [Fri, 22 Jan 2021 19:14:16 +0000 (13:14 -0600)]
Instantiate initial form values when form is instantiated (at startup)

4 years agoUse instances for initial values
Karl O. Pinc [Fri, 22 Jan 2021 19:01:22 +0000 (13:01 -0600)]
Use instances for initial values

4 years agoFix so initial form values are used
Karl O. Pinc [Fri, 22 Jan 2021 19:00:25 +0000 (13:00 -0600)]
Fix so initial form values are used

4 years agoAllow for "chaining"
Karl O. Pinc [Tue, 19 Jan 2021 18:49:21 +0000 (12:49 -0600)]
Allow for "chaining"

4 years agoBump version number to 0.7.0
Karl O. Pinc [Mon, 18 Jan 2021 21:30:35 +0000 (15:30 -0600)]
Bump version number to 0.7.0

4 years agoClass to test for too few columns in param substition
Karl O. Pinc [Mon, 18 Jan 2021 20:51:20 +0000 (14:51 -0600)]
Class to test for too few columns in param substition

4 years agoClose file after uploading
Karl O. Pinc [Wed, 13 Jan 2021 22:50:32 +0000 (16:50 -0600)]
Close file after uploading

4 years agoAdd hooks for opening and closing the uploaded file
Karl O. Pinc [Wed, 13 Jan 2021 22:50:15 +0000 (16:50 -0600)]
Add hooks for opening and closing the uploaded file

4 years agoDetect binary file uploads
Karl O. Pinc [Tue, 5 Jan 2021 19:31:39 +0000 (13:31 -0600)]
Detect binary file uploads

4 years agoMake the DBHandler class hierarchy testable; separate init() function
Karl O. Pinc [Thu, 31 Dec 2020 22:03:44 +0000 (16:03 -0600)]
Make the DBHandler class hierarchy testable; separate init() function

4 years agoDo iteration with standard coding idioms
Karl O. Pinc [Tue, 29 Dec 2020 18:51:09 +0000 (12:51 -0600)]
Do iteration with standard coding idioms

4 years agoAllow exception error descriptions to be extended
Karl O. Pinc [Fri, 25 Dec 2020 21:01:47 +0000 (15:01 -0600)]
Allow exception error descriptions to be extended

4 years agoBreak initialization into smaller functions
Karl O. Pinc [Thu, 24 Dec 2020 22:34:16 +0000 (16:34 -0600)]
Break initialization into smaller functions

4 years agoChange some of the form classes from inheritence to mixins
Karl O. Pinc [Wed, 23 Dec 2020 17:25:21 +0000 (11:25 -0600)]
Change some of the form classes from inheritence to mixins

4 years agoHandle multiple errors from a get_data or factory or cleanup
Karl O. Pinc [Wed, 23 Dec 2020 17:24:07 +0000 (11:24 -0600)]
Handle multiple errors from a get_data or factory or cleanup

4 years agomeme.com -> karlpinc.com
Karl O. Pinc [Thu, 10 Dec 2020 00:39:42 +0000 (18:39 -0600)]
meme.com -> karlpinc.com

4 years agoSupport tox against multiple Python versions using pyenv
Karl O. Pinc [Wed, 9 Dec 2020 23:01:47 +0000 (17:01 -0600)]
Support tox against multiple Python versions using pyenv

4 years agoComponent name includes pgwui_ prefix
Karl O. Pinc [Wed, 9 Dec 2020 20:25:38 +0000 (14:25 -0600)]
Component name includes pgwui_ prefix

4 years agoUpdate email address
Karl O. Pinc [Wed, 9 Dec 2020 20:11:05 +0000 (14:11 -0600)]
Update email address

4 years agoBump version number to 0.6.0
Karl O. Pinc [Tue, 8 Dec 2020 23:32:14 +0000 (17:32 -0600)]
Bump version number to 0.6.0

4 years agoMark unit and integration tests
Karl O. Pinc [Tue, 24 Nov 2020 17:56:26 +0000 (11:56 -0600)]
Mark unit and integration tests

4 years agoAdjust for unit test marking
Karl O. Pinc [Tue, 24 Nov 2020 17:01:35 +0000 (11:01 -0600)]
Adjust for unit test marking

4 years agoAdd check-debug target
Karl O. Pinc [Tue, 24 Nov 2020 17:01:12 +0000 (11:01 -0600)]
Add check-debug target