From 1e3c3fa7064e30b0a9da75ca2bfa795d382ba59f Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc" <kop@karlpinc.com>
Date: Sat, 23 Jan 2021 15:33:23 -0600
Subject: [PATCH] Add a "null" setting to control upload of NULL values

---
 src/pgwui_upload/pgwui_upload.py      | 3 +++
 src/pgwui_upload/templates/upload.mak | 7 +++++--
 2 files changed, 8 insertions(+), 2 deletions(-)

diff --git a/src/pgwui_upload/pgwui_upload.py b/src/pgwui_upload/pgwui_upload.py
index 1521ccf..83429f8 100644
--- a/src/pgwui_upload/pgwui_upload.py
+++ b/src/pgwui_upload/pgwui_upload.py
@@ -26,6 +26,7 @@ DEFAULT_UPLOAD_ROUTE = '/upload'
 DEFAULT_UPLOAD_MENU_LABEL = 'upload -- Upload File Into Database'
 DEFAULT_LITERAL_COLUMN_HEADINGS = 'no-never'
 DEFAULT_TRIM = 'choice-yes'
+DEFAULT_NULL = 'choice-yes'
 
 
 def init_menu(config):
@@ -41,6 +42,8 @@ def init_menu(config):
         'literal_column_headings', DEFAULT_LITERAL_COLUMN_HEADINGS)
     upload_settings.setdefault(
         'trim', DEFAULT_TRIM)
+    upload_settings.setdefault(
+        'null', DEFAULT_NULL)
 
 
 def includeme(config):
diff --git a/src/pgwui_upload/templates/upload.mak b/src/pgwui_upload/templates/upload.mak
index f2e20e6..f0e371a 100644
--- a/src/pgwui_upload/templates/upload.mak
+++ b/src/pgwui_upload/templates/upload.mak
@@ -30,6 +30,7 @@
 
 
 <%!
+    from pgwui_upload_core.template_utils import show_choice
     from pgwui_common.path import asset_abspath
 
     upload_base_mak = asset_abspath('pgwui_upload_core:templates/upload.mak')
@@ -75,6 +76,8 @@
 
 <%
     form_elements = [table_row]
-    self.append_elements(form_elements) %>
+    self.append_elements(form_elements)
 
-${self.upload_form(form_elements)}
+    self.upload_form(form_elements,
+                     upload_nulls=show_choice(pgwui, 'null'))
+%>
-- 
2.34.1