pgwui_bulk_upload
7 months agoBump version number to 0.28.0 master
Karl O. Pinc [Mon, 21 Oct 2024 21:10:25 +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:04 +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:24:31 +0000 (13:24 -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:46 +0000 (12:28 -0500)]
Bump version number to 0.24.0

8 months agoBump version number to 0.23.0
Karl O. Pinc [Sat, 5 Oct 2024 03:57:55 +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:26 +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:40:04 +0000 (15:40 -0500)]
Install the extra testing dependencies when testing

9 months agoBump version number to 0.19.0
Karl O. Pinc [Tue, 20 Aug 2024 19:55:37 +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:09 +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:07:09 +0000 (12:07 -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:13 +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:49 +0000 (12:04 -0500)]
Bump version number to 0.16.0

10 months agoMove page_heading filter into base.mak
Karl O. Pinc [Fri, 2 Aug 2024 18:11:40 +0000 (13:11 -0500)]
Move page_heading filter into base.mak

10 months agoPut page heading in the base template
Karl O. Pinc [Fri, 2 Aug 2024 16:42:32 +0000 (11:42 -0500)]
Put page heading in the base template

10 months agoAdd newline to end of file
Karl O. Pinc [Fri, 2 Aug 2024 16:30:08 +0000 (11:30 -0500)]
Add newline to end of file

10 months agoMove table rows into their own %def
Karl O. Pinc [Thu, 1 Aug 2024 22:25:09 +0000 (17:25 -0500)]
Move table rows into their own %def

10 months agoInheriting templates call "main_form" and initiate execution
Karl O. Pinc [Tue, 30 Jul 2024 23:27:54 +0000 (18:27 -0500)]
Inheriting templates call "main_form" and initiate execution

10 months agoTest for null input in the null input template code
Karl O. Pinc [Tue, 30 Jul 2024 20:44:54 +0000 (15:44 -0500)]
Test for null input in the null input template code

10 months agoUse inheritance to properly wrap inheriting body
Karl O. Pinc [Tue, 30 Jul 2024 16:46:29 +0000 (11:46 -0500)]
Use inheritance to properly wrap inheriting body

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

10 months agoBetter response variable name db_changed -> report_success
Karl O. Pinc [Tue, 16 Jul 2024 12:55:29 +0000 (07:55 -0500)]
Better response variable name db_changed -> report_success

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

11 months agoThrow invalid column count errors where the insert statement is executed
Karl O. Pinc [Sun, 23 Jun 2024 02:03:57 +0000 (21:03 -0500)]
Throw invalid column count errors where the insert statement is executed

Psycopg 3 throws a generic ProgramimgError, so core.py has trouble
reporting the problem.  Perhaps this can be solved by creating a
generic PreparedStmt class at the core level, but this works for
the moment.

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

11 months agoDocument use of "trim" keyword in contents.yaml
Karl O. Pinc [Sat, 22 Jun 2024 03:17:12 +0000 (22:17 -0500)]
Document use of "trim" keyword in contents.yaml

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:13 +0000 (14:28 -0500)]
Run yamllint when checking

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

14 months agoAdd keywords to the project for pypi
Karl O. Pinc [Thu, 28 Mar 2024 21:17:04 +0000 (16:17 -0500)]
Add keywords to the project for pypi

14 months agoUse "build" to build packages; add a pyproject.toml file
Karl O. Pinc [Thu, 28 Mar 2024 17:17:05 +0000 (12:17 -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 [Fri, 22 Mar 2024 16:38:31 +0000 (11:38 -0500)]
Use new attrs syntax

14 months agoFix entrypoint tests
Karl O. Pinc [Thu, 21 Mar 2024 23:04:25 +0000 (18:04 -0500)]
Fix entrypoint tests

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

14 months agoChange name: instance_method_mock_fixture() -> late_instance_mock_fixture()
Karl O. Pinc [Sat, 16 Mar 2024 21:20:05 +0000 (16:20 -0500)]
Change name: instance_method_mock_fixture() -> late_instance_mock_fixture()

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

15 months agoMake base class BaseTableUploadHandler responsible for state initialization
Karl O. Pinc [Sun, 3 Mar 2024 23:47:50 +0000 (17:47 -0600)]
Make base class BaseTableUploadHandler responsible for state initialization

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

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

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 agoAttach path and relation to MultiErrors
Karl O. Pinc [Sun, 30 May 2021 06:19:09 +0000 (01:19 -0500)]
Attach path and relation to MultiErrors

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 agoNumber of lines in file is unknown when file parsing fails
Karl O. Pinc [Fri, 30 Apr 2021 03:01:39 +0000 (22:01 -0500)]
Number of lines in file is unknown when file parsing fails

4 years agopgwui_core.exceptions.Error is now SetupError
Karl O. Pinc [Tue, 27 Apr 2021 20:33:28 +0000 (15:33 -0500)]
pgwui_core.exceptions.Error is now SetupError

4 years agoChange init_menu() to establish_settings()
Karl O. Pinc [Tue, 26 Jan 2021 04:01:26 +0000 (22:01 -0600)]
Change init_menu() to establish_settings()

4 years agoSpelling
Karl O. Pinc [Tue, 26 Jan 2021 03:41:56 +0000 (21:41 -0600)]
Spelling

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

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 agoAdd a "trim" key to the bulk upload map
Karl O. Pinc [Sat, 23 Jan 2021 23:31:38 +0000 (17:31 -0600)]
Add a "trim" key to the bulk upload map

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

4 years agoAdd a setting for uploaded file format
Karl O. Pinc [Sat, 23 Jan 2021 22:14:04 +0000 (16:14 -0600)]
Add a setting for uploaded file format

4 years agoAdd a "null" setting to control upload of NULL values
Karl O. Pinc [Sat, 23 Jan 2021 21:33:33 +0000 (15:33 -0600)]
Add a "null" setting to control upload of NULL values

4 years agoHave literal_column_headings values be those of boolean_choice
Karl O. Pinc [Sat, 23 Jan 2021 20:25:45 +0000 (14:25 -0600)]
Have literal_column_headings values be those of boolean_choice

4 years agoMove initial post values into pgwui_upload_core
Karl O. Pinc [Sat, 23 Jan 2021 19:02:43 +0000 (13:02 -0600)]
Move initial post values into pgwui_upload_core

4 years agoMove title into pgwui_upload_core
Karl O. Pinc [Sat, 23 Jan 2021 01:47:22 +0000 (19:47 -0600)]
Move title into pgwui_upload_core

4 years agoAdd a "trim" setting to control trim of whitespace in data
Karl O. Pinc [Sat, 23 Jan 2021 01:31:23 +0000 (19:31 -0600)]
Add a "trim" setting to control trim of whitespace in data

4 years ago"map_file" is not a required setting
Karl O. Pinc [Thu, 21 Jan 2021 01:29:35 +0000 (19:29 -0600)]
"map_file" is not a required setting

4 years agoFix import
Karl O. Pinc [Thu, 21 Jan 2021 01:28:51 +0000 (19:28 -0600)]
Fix import

4 years agoDisplay trim checkbox
Karl O. Pinc [Wed, 20 Jan 2021 18:37:29 +0000 (12:37 -0600)]
Display trim checkbox

4 years agoThis module has its own literal_column_headings setting
Karl O. Pinc [Tue, 19 Jan 2021 21:32:26 +0000 (15:32 -0600)]
This module has its own literal_column_headings setting

4 years agoTake advantage of the return of the mutated exception
Karl O. Pinc [Tue, 19 Jan 2021 18:50:00 +0000 (12:50 -0600)]
Take advantage of the return of the mutated exception

4 years agoRecover from db errors while building insert statements
Karl O. Pinc [Tue, 19 Jan 2021 18:42:34 +0000 (12:42 -0600)]
Recover from db errors while building insert statements

4 years agoAlways close the file after getting column headers
Karl O. Pinc [Tue, 19 Jan 2021 17:44:04 +0000 (11:44 -0600)]
Always close the file after getting column headers

4 years agoFix "double hr" display above file errors
Karl O. Pinc [Mon, 18 Jan 2021 22:53:33 +0000 (16:53 -0600)]
Fix "double hr" display above file errors

4 years agoClose paragraph tag
Karl O. Pinc [Mon, 18 Jan 2021 22:38:26 +0000 (16:38 -0600)]
Close paragraph tag

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 agoForce "caution: prior errors" when errors in mutiple files
Karl O. Pinc [Mon, 18 Jan 2021 21:28:46 +0000 (15:28 -0600)]
Force "caution: prior errors" when errors in mutiple files

4 years agoReport error when there's too few data columns
Karl O. Pinc [Mon, 18 Jan 2021 20:53:20 +0000 (14:53 -0600)]
Report error when there's too few data columns

4 years agoValidate zip file only when there is a uploaded file
Karl O. Pinc [Mon, 18 Jan 2021 01:11:14 +0000 (19:11 -0600)]
Validate zip file only when there is a uploaded file

4 years agoAdd separator between each file's errors
Karl O. Pinc [Mon, 18 Jan 2021 00:58:55 +0000 (18:58 -0600)]
Add separator between each file's errors

4 years agoNo point in re-testing for open-ness, due to: yield from ...
Karl O. Pinc [Sun, 17 Jan 2021 01:25:32 +0000 (19:25 -0600)]
No point in re-testing for open-ness, due to: yield from ...

4 years agoFix duplicate display of error messages
Karl O. Pinc [Sun, 17 Jan 2021 01:20:40 +0000 (19:20 -0600)]
Fix duplicate display of error messages

4 years agoAlways use "self" so inheritance works
Karl O. Pinc [Sun, 17 Jan 2021 01:20:13 +0000 (19:20 -0600)]
Always use "self" so inheritance works

4 years agoPass stats to the template regardless of upload success
Karl O. Pinc [Fri, 15 Jan 2021 05:15:30 +0000 (23:15 -0600)]
Pass stats to the template regardless of upload success

4 years agoFix typo in parameter reference
Karl O. Pinc [Fri, 15 Jan 2021 05:13:53 +0000 (23:13 -0600)]
Fix typo in parameter reference

4 years agoHave open only the file that is being uploaded, not all files
Karl O. Pinc [Thu, 14 Jan 2021 04:06:29 +0000 (22:06 -0600)]
Have open only the file that is being uploaded, not all files

4 years agoCatch only the exceptions we expect to be raised
Karl O. Pinc [Thu, 14 Jan 2021 03:54:27 +0000 (21:54 -0600)]
Catch only the exceptions we expect to be raised

4 years agoColor errors discovered during initialization
Karl O. Pinc [Wed, 13 Jan 2021 20:48:29 +0000 (14:48 -0600)]
Color errors discovered during initialization

4 years agoSimplify what's passed to the DataLineProcessor; remove extra coloring
Karl O. Pinc [Wed, 13 Jan 2021 20:14:09 +0000 (14:14 -0600)]
Simplify what's passed to the DataLineProcessor; remove extra coloring

4 years agoInitial commit
Karl O. Pinc [Tue, 5 Jan 2021 21:44:56 +0000 (15:44 -0600)]
Initial commit