pgwui_core
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

4 years agoMove pgwui settings into its own dict
Karl O. Pinc [Sun, 15 Nov 2020 23:11:08 +0000 (17:11 -0600)]
Move pgwui settings into its own dict

4 years agoThere is no autoconfiguration; remove entrypoint until there is
Karl O. Pinc [Wed, 9 Sep 2020 21:57:39 +0000 (16:57 -0500)]
There is no autoconfiguration; remove entrypoint until there is

4 years agoMove exceptions into their own module
Karl O. Pinc [Mon, 31 Aug 2020 20:01:10 +0000 (15:01 -0500)]
Move exceptions into their own module

4 years agoUpdate copyright
Karl O. Pinc [Mon, 31 Aug 2020 19:53:54 +0000 (14:53 -0500)]
Update copyright

4 years agoAdded long_description_content_type
Karl O. Pinc [Sat, 29 Aug 2020 22:04:00 +0000 (17:04 -0500)]
Added long_description_content_type

5 years agoClean .tox when setup.py changes
Karl O. Pinc [Thu, 23 Jan 2020 21:44:40 +0000 (15:44 -0600)]
Clean .tox when setup.py changes

5 years agoAllow marking and running of just unit or just integration tests
Karl O. Pinc [Sun, 5 Jan 2020 08:09:07 +0000 (02:09 -0600)]
Allow marking and running of just unit or just integration tests

5 years agoTest to ensure that this pgwui component is autoconfigured
Karl O. Pinc [Sat, 28 Dec 2019 21:58:20 +0000 (15:58 -0600)]
Test to ensure that this pgwui component is autoconfigured

5 years agoMove form docs from PGWUI_Core to PGWUI_Common
Karl O. Pinc [Sat, 14 Dec 2019 06:09:21 +0000 (00:09 -0600)]
Move form docs from PGWUI_Core to PGWUI_Common

5 years agoStandardize make accross PGWUI with Makefile_pgwui.mk
Karl O. Pinc [Fri, 13 Dec 2019 17:17:50 +0000 (11:17 -0600)]
Standardize make accross PGWUI with Makefile_pgwui.mk

5 years agoSelf-document Makefile
Karl O. Pinc [Fri, 13 Dec 2019 04:27:54 +0000 (22:27 -0600)]
Self-document Makefile

5 years agoBump version number to 0.5.0
Karl O. Pinc [Wed, 11 Dec 2019 17:43:52 +0000 (11:43 -0600)]
Bump version number to 0.5.0

5 years agokeywords are a list
Karl O. Pinc [Wed, 11 Dec 2019 16:08:25 +0000 (10:08 -0600)]
keywords are a list

5 years agoABCs are in collections.abc
Karl O. Pinc [Wed, 11 Dec 2019 15:58:33 +0000 (09:58 -0600)]
ABCs are in collections.abc

5 years agoUse python3 to make
Karl O. Pinc [Wed, 11 Dec 2019 14:25:24 +0000 (08:25 -0600)]
Use python3 to make

5 years agoBetter label for literal checkbox
Karl O. Pinc [Sun, 8 Dec 2019 06:47:03 +0000 (00:47 -0600)]
Better label for literal checkbox

5 years agoBump version number to 0.4.0
Karl O. Pinc [Fri, 6 Dec 2019 03:35:10 +0000 (21:35 -0600)]
Bump version number to 0.4.0

5 years agoAdd a literal_col_headings request parameter for an UploadFileForm
Karl O. Pinc [Fri, 6 Dec 2019 03:18:26 +0000 (21:18 -0600)]
Add a literal_col_headings request parameter for an UploadFileForm

6 years agoSupply sensible defaults for pg connection parameters
Karl O. Pinc [Sat, 17 Nov 2018 08:21:12 +0000 (02:21 -0600)]
Supply sensible defaults for pg connection parameters

6 years agoAdd heading comment
Karl O. Pinc [Sat, 17 Nov 2018 05:25:55 +0000 (23:25 -0600)]
Add heading comment

6 years agoFix docstring
Karl O. Pinc [Sat, 17 Nov 2018 04:52:26 +0000 (22:52 -0600)]
Fix docstring

6 years agoImport only those constants used
Karl O. Pinc [Sat, 17 Nov 2018 04:49:08 +0000 (22:49 -0600)]
Import only those constants used

6 years agoChange form_constants.py to constants.py
Karl O. Pinc [Sat, 17 Nov 2018 04:43:00 +0000 (22:43 -0600)]
Change form_constants.py to constants.py

6 years agoBump version number to 0.3.0
Karl O. Pinc [Thu, 15 Nov 2018 03:20:32 +0000 (21:20 -0600)]
Bump version number to 0.3.0