From e6c1455838db22e99a984d5e366e3ae1c7fe6f01 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Sat, 23 Jan 2021 15:34:12 -0600 Subject: [PATCH] Add a "null" setting to control upload of NULL values --- examples/etc/pgwui.ini | 14 ++++++++++++++ examples/misc/development.ini | 16 ++++++++++++++++ 2 files changed, 30 insertions(+) diff --git a/examples/etc/pgwui.ini b/examples/etc/pgwui.ini index b174014..ed610ec 100644 --- a/examples/etc/pgwui.ini +++ b/examples/etc/pgwui.ini @@ -237,6 +237,16 @@ pgwui.dry_run = False # choice-yes Present a checkbox, default to "yes, trim". # choice-no Present a checkbox, default to "no, don't trim". # no-never Never trim. +# +# null +# Whether or not some uploaded data elements should be inserted as NULL +# values. +# +# The available choices are: +# yes-always Always transform some data into NULL. +# choice-yes Present a checkbox, default to "yes". +# choice-no Present a checkbox, default to "no". +# no-never Never transform data into NULL. # pgwui_bulk_upload @@ -289,6 +299,10 @@ pgwui.dry_run = False # trim = choice-yes # Remove leading and trailing whitespace. # See pgwui_upload above for details. +# +# null = choice-yes +# Insert NULL values. +# See pgwui_upload above for details. # diff --git a/examples/misc/development.ini b/examples/misc/development.ini index 684a49f..3d30e91 100644 --- a/examples/misc/development.ini +++ b/examples/misc/development.ini @@ -218,6 +218,7 @@ pgwui.validate_hmac = False # literal_column_headings = no-never # menu_label = upload -- Upload File Into Database # trim = choice-yes +# null = choice-yes # # literal_column_headings # Take uploaded column headings literally? @@ -242,6 +243,16 @@ pgwui.validate_hmac = False # choice-yes Present a checkbox, default to "yes, trim". # choice-no Present a checkbox, default to "no, don't trim". # no-never Never trim. +# +# null +# Whether or not some uploaded data elements should be inserted as NULL +# values. +# +# The available choices are: +# yes-always Always transform some data into NULL. +# choice-yes Present a checkbox, default to "yes". +# choice-no Present a checkbox, default to "no". +# no-never Never transform data into NULL. # pgwui_bulk_upload @@ -251,6 +262,7 @@ pgwui.validate_hmac = False # menu_label = bulk_upload -- Upload Many Files Into PostgreSQL # map_file = contents.yml # trim = choice-yes +# null = choice-yes # # literal_column_headings = no-never # Take uploaded column headings literally? @@ -294,6 +306,10 @@ pgwui.validate_hmac = False # trim = choice-yes # Remove leading and trailing whitespace. # See pgwui_upload above for details. +# +# null = choice-yes +# Insert NULL values. +# See pgwui_upload above for details. # -- 2.34.1