Karl O. Pinc [Mon, 21 Oct 2024 21:10:26 +0000 (16:10 -0500)]
Bump version number to 0.28.0
Karl O. Pinc [Mon, 21 Oct 2024 14:48:39 +0000 (09:48 -0500)]
Bump version number to 0.27.0
Karl O. Pinc [Thu, 10 Oct 2024 18:29:05 +0000 (13:29 -0500)]
Bump version number to 0.26.0
Karl O. Pinc [Thu, 10 Oct 2024 18:25:14 +0000 (13:25 -0500)]
Add feature to upload missing column values as NULL
Karl O. Pinc [Tue, 8 Oct 2024 18:11:57 +0000 (13:11 -0500)]
Bump version number to 0.25.0
Karl O. Pinc [Tue, 8 Oct 2024 17:28:47 +0000 (12:28 -0500)]
Bump version number to 0.24.0
Karl O. Pinc [Tue, 8 Oct 2024 16:57:49 +0000 (11:57 -0500)]
Make the "locals" dict always available for local template variables
Karl O. Pinc [Sat, 5 Oct 2024 03:57:56 +0000 (22:57 -0500)]
Bump version number to 0.23.0
Karl O. Pinc [Sat, 5 Oct 2024 01:13:02 +0000 (20:13 -0500)]
Bump version number to 0.22.0
Karl O. Pinc [Fri, 4 Oct 2024 20:55:23 +0000 (15:55 -0500)]
Bump version number to 0.21.0
Karl O. Pinc [Fri, 4 Oct 2024 20:50:27 +0000 (15:50 -0500)]
Bump version number to 0.20.0
Karl O. Pinc [Fri, 4 Oct 2024 20:41:22 +0000 (15:41 -0500)]
Install the extra testing dependencies when testing
Karl O. Pinc [Tue, 24 Sep 2024 22:43:26 +0000 (17:43 -0500)]
HTML does not require the "checked" attribute have a value
Karl O. Pinc [Sat, 14 Sep 2024 23:04:33 +0000 (18:04 -0500)]
Support executing SQL that returns rows
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
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
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.
Karl O. Pinc [Tue, 20 Aug 2024 19:55:38 +0000 (14:55 -0500)]
Bump version number to 0.19.0
Karl O. Pinc [Mon, 19 Aug 2024 19:48:11 +0000 (14:48 -0500)]
Bump version number to 0.18.0
Karl O. Pinc [Tue, 13 Aug 2024 17:06:24 +0000 (12:06 -0500)]
Have a separate module for forms
Karl O. Pinc [Mon, 5 Aug 2024 17:50:14 +0000 (12:50 -0500)]
Bump version number to 0.17.0
Karl O. Pinc [Mon, 5 Aug 2024 17:04:50 +0000 (12:04 -0500)]
Bump version number to 0.16.0
Karl O. Pinc [Mon, 5 Aug 2024 16:59:54 +0000 (11:59 -0500)]
Fix double-upload test by handling boolean post values
Karl O. Pinc [Tue, 16 Jul 2024 22:08:36 +0000 (17:08 -0500)]
Move core utility functions into a separate module
Karl O. Pinc [Tue, 16 Jul 2024 22:07:05 +0000 (17:07 -0500)]
Consistently use full path to refer to psycopg error classes
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.
Karl O. Pinc [Tue, 16 Jul 2024 18:48:48 +0000 (13:48 -0500)]
Refactor to support state kept in both POST and session
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
Karl O. Pinc [Sun, 14 Jul 2024 03:08:47 +0000 (22:08 -0500)]
Improved internal docs
Karl O. Pinc [Sun, 14 Jul 2024 03:07:59 +0000 (22:07 -0500)]
Improved python
Karl O. Pinc [Sun, 23 Jun 2024 02:06:59 +0000 (21:06 -0500)]
Bump version number to 0.15.0
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
Karl O. Pinc [Sat, 22 Jun 2024 03:38:33 +0000 (22:38 -0500)]
psycopg2 -> psycopg3 API change
Karl O. Pinc [Sat, 22 Jun 2024 03:21:04 +0000 (22:21 -0500)]
Use immediate assignments
Karl O. Pinc [Sat, 22 Jun 2024 03:05:14 +0000 (22:05 -0500)]
Adjust for YAML config booleans being actual booleans
Karl O. Pinc [Fri, 21 Jun 2024 23:10:57 +0000 (18:10 -0500)]
Fix conditional yamllint execution
Karl O. Pinc [Fri, 21 Jun 2024 23:10:00 +0000 (18:10 -0500)]
Avoid rebuilding packages when running check targets
Karl O. Pinc [Fri, 21 Jun 2024 19:28:14 +0000 (14:28 -0500)]
Run yamllint when checking
Karl O. Pinc [Wed, 19 Jun 2024 22:43:14 +0000 (17:43 -0500)]
Better class docs
Karl O. Pinc [Thu, 28 Mar 2024 21:40:49 +0000 (16:40 -0500)]
Bump version number to 0.14.0
Karl O. Pinc [Thu, 28 Mar 2024 03:34:08 +0000 (22:34 -0500)]
Use "build" to build packages; add a pyproject.toml file
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
Karl O. Pinc [Fri, 22 Mar 2024 20:31:20 +0000 (15:31 -0500)]
Bump version number to 0.13.0
Karl O. Pinc [Thu, 21 Mar 2024 23:51:12 +0000 (18:51 -0500)]
Use new attrs syntax
Karl O. Pinc [Mon, 18 Mar 2024 22:23:34 +0000 (17:23 -0500)]
Remove unneeded __future__ imports
Karl O. Pinc [Mon, 18 Mar 2024 21:50:00 +0000 (16:50 -0500)]
Change super() calls from python2 style to python3
Karl O. Pinc [Tue, 5 Mar 2024 22:11:53 +0000 (16:11 -0600)]
Drop Python 3.6 support; psycopg3 does not support it
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
Karl O. Pinc [Tue, 5 Mar 2024 21:07:22 +0000 (15:07 -0600)]
Document restrictions on ParameterExecutor() use
Karl O. Pinc [Tue, 5 Mar 2024 21:06:29 +0000 (15:06 -0600)]
Fix typo in UntranslatableCharacter exception name
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
Karl O. Pinc [Sat, 2 Mar 2024 22:53:37 +0000 (16:53 -0600)]
Use the new attrs API on SQLCommand classes
Karl O. Pinc [Sat, 24 Feb 2024 02:14:02 +0000 (20:14 -0600)]
Refactor encoding errors when using parameterized sql
Karl O. Pinc [Fri, 23 Feb 2024 20:29:53 +0000 (14:29 -0600)]
Set client-side connection encoding
Karl O. Pinc [Fri, 23 Feb 2024 16:42:54 +0000 (10:42 -0600)]
Better code formatting
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
Karl O. Pinc [Fri, 23 Feb 2024 15:59:13 +0000 (09:59 -0600)]
Switch from the depreciated cgi module to the html module
Karl O. Pinc [Thu, 3 Jun 2021 16:44:10 +0000 (11:44 -0500)]
Bump version number to 0.12.0
Karl O. Pinc [Thu, 3 Jun 2021 16:42:40 +0000 (11:42 -0500)]
Continue processing file after an encoding error is found
Karl O. Pinc [Thu, 3 Jun 2021 16:13:36 +0000 (11:13 -0500)]
Consolidate exception handling
Karl O. Pinc [Sun, 30 May 2021 06:20:11 +0000 (01:20 -0500)]
Bump version number to 0.11.0
Karl O. Pinc [Sun, 30 May 2021 06:18:10 +0000 (01:18 -0500)]
Trap errors when translating into the db's encoding
Karl O. Pinc [Sun, 9 May 2021 21:50:00 +0000 (16:50 -0500)]
Bump version number to 0.10.0
Karl O. Pinc [Sun, 9 May 2021 21:49:17 +0000 (16:49 -0500)]
Use session to track whether login credentials are good
Karl O. Pinc [Fri, 30 Apr 2021 04:04:05 +0000 (23:04 -0500)]
Better code
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
Karl O. Pinc [Wed, 28 Apr 2021 23:54:25 +0000 (18:54 -0500)]
Name exception SetupError instead of Error
Karl O. Pinc [Fri, 23 Apr 2021 21:40:40 +0000 (16:40 -0500)]
Spelling
Karl O. Pinc [Fri, 23 Apr 2021 21:10:52 +0000 (16:10 -0500)]
Catch all errors (!)
Karl O. Pinc [Tue, 26 Jan 2021 03:30:16 +0000 (21:30 -0600)]
Change component name from pgwui_testing to pgwui_develop
Karl O. Pinc [Sun, 24 Jan 2021 05:52:13 +0000 (23:52 -0600)]
Bump version number to 0.9.0
Karl O. Pinc [Sun, 24 Jan 2021 05:49:55 +0000 (23:49 -0600)]
Add the table as a mixin to the initial post
Karl O. Pinc [Sun, 24 Jan 2021 02:40:31 +0000 (20:40 -0600)]
Bump version number to 0.8.0
Karl O. Pinc [Sat, 23 Jan 2021 22:27:39 +0000 (16:27 -0600)]
Update copyright statements
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
Karl O. Pinc [Sat, 23 Jan 2021 02:49:41 +0000 (20:49 -0600)]
Use attrs and modernize form classes
Karl O. Pinc [Fri, 22 Jan 2021 19:28:04 +0000 (13:28 -0600)]
Modernize initial form value classes with attrs module
Karl O. Pinc [Fri, 22 Jan 2021 19:14:16 +0000 (13:14 -0600)]
Instantiate initial form values when form is instantiated (at startup)
Karl O. Pinc [Fri, 22 Jan 2021 19:01:22 +0000 (13:01 -0600)]
Use instances for initial values
Karl O. Pinc [Fri, 22 Jan 2021 19:00:25 +0000 (13:00 -0600)]
Fix so initial form values are used
Karl O. Pinc [Tue, 19 Jan 2021 18:49:21 +0000 (12:49 -0600)]
Allow for "chaining"
Karl O. Pinc [Mon, 18 Jan 2021 21:30:35 +0000 (15:30 -0600)]
Bump version number to 0.7.0
Karl O. Pinc [Mon, 18 Jan 2021 20:51:20 +0000 (14:51 -0600)]
Class to test for too few columns in param substition
Karl O. Pinc [Wed, 13 Jan 2021 22:50:32 +0000 (16:50 -0600)]
Close file after uploading
Karl O. Pinc [Wed, 13 Jan 2021 22:50:15 +0000 (16:50 -0600)]
Add hooks for opening and closing the uploaded file
Karl O. Pinc [Tue, 5 Jan 2021 19:31:39 +0000 (13:31 -0600)]
Detect binary file uploads
Karl O. Pinc [Thu, 31 Dec 2020 22:03:44 +0000 (16:03 -0600)]
Make the DBHandler class hierarchy testable; separate init() function
Karl O. Pinc [Tue, 29 Dec 2020 18:51:09 +0000 (12:51 -0600)]
Do iteration with standard coding idioms
Karl O. Pinc [Fri, 25 Dec 2020 21:01:47 +0000 (15:01 -0600)]
Allow exception error descriptions to be extended
Karl O. Pinc [Thu, 24 Dec 2020 22:34:16 +0000 (16:34 -0600)]
Break initialization into smaller functions
Karl O. Pinc [Wed, 23 Dec 2020 17:25:21 +0000 (11:25 -0600)]
Change some of the form classes from inheritence to mixins
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
Karl O. Pinc [Thu, 10 Dec 2020 00:39:42 +0000 (18:39 -0600)]
meme.com -> karlpinc.com
Karl O. Pinc [Wed, 9 Dec 2020 23:01:47 +0000 (17:01 -0600)]
Support tox against multiple Python versions using pyenv
Karl O. Pinc [Wed, 9 Dec 2020 20:25:38 +0000 (14:25 -0600)]
Component name includes pgwui_ prefix
Karl O. Pinc [Wed, 9 Dec 2020 20:11:05 +0000 (14:11 -0600)]
Update email address
Karl O. Pinc [Tue, 8 Dec 2020 23:32:14 +0000 (17:32 -0600)]
Bump version number to 0.6.0
Karl O. Pinc [Tue, 24 Nov 2020 17:56:26 +0000 (11:56 -0600)]
Mark unit and integration tests
Karl O. Pinc [Tue, 24 Nov 2020 17:01:35 +0000 (11:01 -0600)]
Adjust for unit test marking
Karl O. Pinc [Tue, 24 Nov 2020 17:01:12 +0000 (11:01 -0600)]
Add check-debug target