From 0bd71d8284ad3e65e240dcd3607de9a217e39251 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Tue, 5 Jan 2021 15:55:47 -0600 Subject: [PATCH] Add the pgwui_bulk_upload settings --- examples/etc/pgwui.ini | 46 +++++++++++++++++++++++++++++++++++ examples/misc/development.ini | 46 +++++++++++++++++++++++++++++++++++ 2 files changed, 92 insertions(+) diff --git a/examples/etc/pgwui.ini b/examples/etc/pgwui.ini index d0b7cea..c911a69 100644 --- a/examples/etc/pgwui.ini +++ b/examples/etc/pgwui.ini @@ -221,6 +221,52 @@ pgwui.dry_run = False # # menu_label = upload -- Upload File Into Database +# pgwui_bulk_upload + +# pgwui_bulk_upload.literal_column_headings: +# Take uploaded column headings literally? +# See pgwui_upload above for details. + +# pgwui_bulk_upload.map_file = contents.yml +# Name of the file in the zip file that maps file names to table +# names. The default name of the map file is `contents.yml`. +# +# The map file is in YAML syntax, which for purposes of this document +# can be thought of as a superset of JSON. It must contain a top-level +# tag, `map_list`, which itself contains a list of maps, each of which +# maps a file to a table or view. The table (or view) names may, +# optionally, be schema qualified. An example map file might be: +# +# # This file is contents.yml +# map_list: +# # Load the foo.csv file into the foo_table table of the default schema. +# - file_map: +# file: foo.csv +# relation: foo_table +# # Load the bar.csv file into the bar_view uploadable-view of the default +# # schema. +# - file_map: +# file: bar.csv +# relation: bar_view +# # Load the baz.csv file into the baz_table table of the meta schema. +# - file_map: +# file: baz.csv +# relation: meta.baz_table +# +# The files within each directory are uploaded in the order in which +# they are listed in the map file. The directories in the zip file are +# processed in alphabetical order. +# +# Top level tags, other than the `map_list` tag, are ignored. +# +# It is recommended to enclose file names which contain spaces, or begin +# with a digit, in single quotes. But any YAML syntax is valid. + +#pgwui.pgwui_bulk_upload = +# literal_column_headings = off +# map_file = contents.txt + + # # Pyramid configuration # https://docs.pylonsproject.org/projects/pyramid/en/latest/narr/environment.html diff --git a/examples/misc/development.ini b/examples/misc/development.ini index f2b29e0..a2080d3 100644 --- a/examples/misc/development.ini +++ b/examples/misc/development.ini @@ -226,6 +226,52 @@ pgwui.validate_hmac = False # # menu_label = upload -- Upload File Into Database +# pgwui_bulk_upload + +# pgwui_bulk_upload.literal_column_headings: +# Take uploaded column headings literally? +# See pgwui_upload above for details. + +# pgwui_bulk_upload.map_file = contents.yml +# Name of the file in the zip file that maps file names to table +# names. The default name of the map file is `contents.yml`. +# +# The map file is in YAML syntax, which for purposes of this document +# can be thought of as a superset of JSON. It must contain a top-level +# tag, `map_list`, which itself contains a list of maps, each of which +# maps a file to a table or view. The table (or view) names may, +# optionally, be schema qualified. An example map file might be: +# +# # This file is contents.yml +# map_list: +# # Load the foo.csv file into the foo_table table of the default schema. +# - file_map: +# file: foo.csv +# relation: foo_table +# # Load the bar.csv file into the bar_view uploadable-view of the default +# # schema. +# - file_map: +# file: bar.csv +# relation: bar_view +# # Load the baz.csv file into the baz_table table of the meta schema. +# - file_map: +# file: baz.csv +# relation: meta.baz_table +# +# The files within each directory are uploaded in the order in which +# they are listed in the map file. The directories in the zip file are +# processed in alphabetical order. +# +# Top level tags, other than the `map_list` tag, are ignored. +# +# It is recommended to enclose file names which contain spaces, or begin +# with a digit, in single quotes. But any YAML syntax is valid. + +#pgwui.pgwui_bulk_upload = +# literal_column_headings = off +# map_file = contents.txt + + # # Pyramid configuration # https://docs.pylonsproject.org/projects/pyramid/en/latest/narr/environment.html -- 2.34.1