pgwui_sql
7 months agoExplain why we can safely use the SQLHander to process the SQL edit form
Karl O. Pinc [Fri, 13 Sep 2024 18:54:36 +0000 (13:54 -0500)]
Explain why we can safely use the SQLHander to process the SQL edit form

7 months agoRemove blank line
Karl O. Pinc [Fri, 13 Sep 2024 18:52:47 +0000 (13:52 -0500)]
Remove blank line

7 months agoDon't try to automatically open a SQL edit window
Karl O. Pinc [Fri, 13 Sep 2024 18:40:48 +0000 (13:40 -0500)]
Don't try to automatically open a SQL edit window

The problem is that the current sql is not passed to the sql edit
window.  So the new window always opens with no sql.  Changing this
is more bother than it's worth.  At least right now.

7 months agoRequire logging in before use of the sql edit popup
Karl O. Pinc [Fri, 13 Sep 2024 18:24:08 +0000 (13:24 -0500)]
Require logging in before use of the sql edit popup

7 months agoLabel button to match sql edit window title
Karl O. Pinc [Fri, 13 Sep 2024 18:06:20 +0000 (13:06 -0500)]
Label button to match sql edit window title

7 months agoPosition and size, more or less correctly, sql edit window
Karl O. Pinc [Fri, 13 Sep 2024 18:05:47 +0000 (13:05 -0500)]
Position and size, more or less correctly, sql edit window

7 months agoChange window title when showing sql results
Karl O. Pinc [Fri, 13 Sep 2024 17:38:27 +0000 (12:38 -0500)]
Change window title when showing sql results

7 months agoRemove navigation menu from popup sql edit window
Karl O. Pinc [Fri, 13 Sep 2024 16:22:06 +0000 (11:22 -0500)]
Remove navigation menu from popup sql edit window

7 months agoA working control flow from login to sql edit window opening
Karl O. Pinc [Fri, 13 Sep 2024 15:48:48 +0000 (10:48 -0500)]
A working control flow from login to sql edit window opening

8 months agoAdd "login" user interface when not logged in
Karl O. Pinc [Wed, 11 Sep 2024 23:00:02 +0000 (18:00 -0500)]
Add "login" user interface when not logged in

8 months agoTest that templates render, at least somewhat
Karl O. Pinc [Wed, 11 Sep 2024 00:17:51 +0000 (19:17 -0500)]
Test that templates render, at least somewhat

8 months agoBeginnings of a SQL edit window
Karl O. Pinc [Tue, 3 Sep 2024 19:17:53 +0000 (14:17 -0500)]
Beginnings of a SQL edit window

8 months agoImprove code formatting
Karl O. Pinc [Tue, 3 Sep 2024 19:16:33 +0000 (14:16 -0500)]
Improve code formatting

8 months agoBetter menu label
Karl O. Pinc [Tue, 20 Aug 2024 20:25:40 +0000 (15:25 -0500)]
Better menu label

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

8 months agoStyle SQL text in a monospace font
Karl O. Pinc [Tue, 20 Aug 2024 01:06:07 +0000 (20:06 -0500)]
Style SQL text in a monospace font

8 months agoStyle the PGResult status message
Karl O. Pinc [Tue, 20 Aug 2024 00:56:45 +0000 (19:56 -0500)]
Style the PGResult status message

8 months agoGive the component it's own CSS file
Karl O. Pinc [Tue, 20 Aug 2024 00:56:09 +0000 (19:56 -0500)]
Give the component it's own CSS file

8 months agoReport warning when there are no results
Karl O. Pinc [Mon, 19 Aug 2024 23:57:43 +0000 (18:57 -0500)]
Report warning when there are no results

8 months agoSubclass "runtime" exceptions
Karl O. Pinc [Mon, 19 Aug 2024 23:44:47 +0000 (18:44 -0500)]
Subclass "runtime" exceptions

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

8 months agoRefactor SQL query result into its own object
Karl O. Pinc [Mon, 19 Aug 2024 17:16:43 +0000 (12:16 -0500)]
Refactor SQL query result into its own object

8 months agoRefactor to abstract formatting of error detail
Karl O. Pinc [Mon, 19 Aug 2024 16:35:49 +0000 (11:35 -0500)]
Refactor to abstract formatting of error detail

8 months agoShow SQL at the top of the results
Karl O. Pinc [Sun, 18 Aug 2024 22:55:53 +0000 (17:55 -0500)]
Show SQL at the top of the results

8 months agoReport on syntax errors without crashing
Karl O. Pinc [Sun, 18 Aug 2024 22:37:15 +0000 (17:37 -0500)]
Report on syntax errors without crashing

8 months agoRefactor to make methods simpler
Karl O. Pinc [Sun, 18 Aug 2024 19:57:03 +0000 (14:57 -0500)]
Refactor to make methods simpler

8 months agoAdd horizontal rules between result of each sql command
Karl O. Pinc [Sun, 18 Aug 2024 19:56:35 +0000 (14:56 -0500)]
Add horizontal rules between result of each sql command

8 months agoRemove unnecessary test
Karl O. Pinc [Sun, 18 Aug 2024 19:54:05 +0000 (14:54 -0500)]
Remove unnecessary test

8 months agoHandle SQL statements that return no result
Karl O. Pinc [Sun, 18 Aug 2024 19:43:04 +0000 (14:43 -0500)]
Handle SQL statements that return no result

8 months agoAdjust for SQL that returns no result
Karl O. Pinc [Sun, 18 Aug 2024 19:08:53 +0000 (14:08 -0500)]
Adjust for SQL that returns no result

8 months agoBring heading type values in line with what the template expects
Karl O. Pinc [Sun, 18 Aug 2024 19:08:28 +0000 (14:08 -0500)]
Bring heading type values in line with what the template expects

8 months agoDocument template variable
Karl O. Pinc [Sun, 18 Aug 2024 19:07:49 +0000 (14:07 -0500)]
Document template variable

8 months agoMove sql execution into upload handler's cleanup() method
Karl O. Pinc [Sun, 18 Aug 2024 18:11:36 +0000 (13:11 -0500)]
Move sql execution into upload handler's cleanup() method

The data line processor is designed to work with lines of data,
and we don't have that.

8 months agoFix log message
Karl O. Pinc [Sun, 18 Aug 2024 18:11:02 +0000 (13:11 -0500)]
Fix log message

8 months agoFix sql textarea generated id
Karl O. Pinc [Sun, 18 Aug 2024 18:10:21 +0000 (13:10 -0500)]
Fix sql textarea generated id

8 months agoKeep sql id from showing up twice in form data
Karl O. Pinc [Sun, 18 Aug 2024 18:09:05 +0000 (13:09 -0500)]
Keep sql id from showing up twice in form data

8 months agoFix SQL textarea name
Karl O. Pinc [Sun, 18 Aug 2024 18:08:08 +0000 (13:08 -0500)]
Fix SQL textarea name

8 months agoFix SQL textarea tabindex
Karl O. Pinc [Sun, 18 Aug 2024 18:07:32 +0000 (13:07 -0500)]
Fix SQL textarea tabindex

8 months agoBuild result rows to be given to the template
Karl O. Pinc [Fri, 16 Aug 2024 22:59:52 +0000 (17:59 -0500)]
Build result rows to be given to the template

8 months agoRemove source code whitespace from rendered form
Karl O. Pinc [Fri, 16 Aug 2024 22:53:48 +0000 (17:53 -0500)]
Remove source code whitespace from rendered form

8 months agoImprove success message
Karl O. Pinc [Fri, 16 Aug 2024 22:52:34 +0000 (17:52 -0500)]
Improve success message

8 months agoMake SQL entry page work
Karl O. Pinc [Fri, 16 Aug 2024 17:25:00 +0000 (12:25 -0500)]
Make SQL entry page work

8 months agoHave a separate module for forms
Karl O. Pinc [Fri, 16 Aug 2024 17:24:21 +0000 (12:24 -0500)]
Have a separate module for forms

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

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

9 months agoProperly initialize the upload handler
Karl O. Pinc [Sun, 4 Aug 2024 20:48:29 +0000 (15:48 -0500)]
Properly initialize the upload handler

9 months agoDependencies are dynamic because they contain version numbers
Karl O. Pinc [Sun, 4 Aug 2024 17:40:16 +0000 (12:40 -0500)]
Dependencies are dynamic because they contain version numbers

9 months agoPut page heading in the base template
Karl O. Pinc [Sat, 3 Aug 2024 21:23:51 +0000 (16:23 -0500)]
Put page heading in the base template

9 months agoUse table row abstractions
Karl O. Pinc [Sat, 3 Aug 2024 21:21:53 +0000 (16:21 -0500)]
Use table row abstractions

9 months agoAdjust for pgwui_common template structure changes
Karl O. Pinc [Wed, 31 Jul 2024 17:46:56 +0000 (12:46 -0500)]
Adjust for pgwui_common template structure changes

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

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

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

10 months agoA little bit of work away from the basic template
Karl O. Pinc [Sun, 23 Jun 2024 02:06:04 +0000 (21:06 -0500)]
A little bit of work away from the basic template

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

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

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

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

11 months agoInitial commit
Karl O. Pinc [Wed, 12 Jun 2024 18:23:34 +0000 (13:23 -0500)]
Initial commit