Metadata-Version: 2.1 Name: pgwui-bulk-upload Version: 0.11.0 Summary: Upload into many PostgreSQL tables, assisting data cleanup, via the web. Home-page: http://pgwui_upload.readthedocs.io/ Author: Karl O. Pinc Author-email: kop@karlpinc.com License: AGPLv3+ Description: PGWUI_Bulk_Upload ================= Short Documentation ------------------- PGWUI_Bulk_Upload stands for `PostgreSQL`_ Web User Interface Bulk Upload. Usage ----- Uploads from an archive file, presently only a zip file, into (potentially) multiple PostgreSQL tables. The structure of the zip file is as follows: The zip file must contain one or more directories. Each directory may contain only files. Each directory must contain a file, the map file, which maps the directory's files to PostgreSQL tables (or views), one file per table (or view). 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. The `yamllint` syntax and style checker can be helpful when constructing YAML files. See: https://github.com/adrienverge/yamllint The default name of the map file is `contents.yml`, but this may be changed with the `pgwui_bulk_upload:map_file` setting. URL Configuration ----------------- The default URL for PGWUI_Bulk_Upload looks like *https://www.example.com/upload*. See the PGWUI_Server documentation for how to configure a different URL. Development Status ------------------ Complete Documentation ---------------------- The complete documentation set can be found on the PGWUI_Upload home page at http://pgwui_bulk_upload.readthedocs.io/. License ------- Except for files otherwise marked, distributed WITHOUT ANY WARRANTY under the terms of the GNU Affero General Public License, version 3 or a later version at your option. See the copyright notices at the top of each file and the LICENSE.txt file for details. Acknowledgments --------------- The PGWUI_Bulk_Upload code is based on the GMI_Pyramid sub-system created for the `Gombe Mother Infant Database Project `_. Support for extracting PGWUI_Core_ from GMI_Pyramid, its Python packaging, and further enhancement was provided by `The Dian Fossey Gorilla Fund `_. .. _PGWUI_Core: http://pgwui_core.readthedocs.io/ .. _PostgreSQL: https://www.postgresql.org/ Keywords: database front end,interface,Postgres,Postgres user interface,Postgres web interface,PostgreSQL,Postgres front end,user interface,web,web front end Platform: UNKNOWN Classifier: Development Status :: 3 - Alpha Classifier: Environment :: Web Environment Classifier: Framework :: Pyramid Classifier: Intended Audience :: End Users/Desktop Classifier: Intended Audience :: Information Technology Classifier: Intended Audience :: Science/Research Classifier: Intended Audience :: System Administrators Classifier: Topic :: Database :: Front-Ends Classifier: Topic :: Internet :: WWW/HTTP Classifier: Topic :: Scientific/Engineering Classifier: Topic :: Utilities Classifier: License :: OSI Approved :: GNU Affero General Public License v3 or later (AGPLv3+) Classifier: Programming Language :: Python :: 3 Classifier: Programming Language :: Python :: 3.4 Classifier: Programming Language :: Python :: 3.5 Classifier: Programming Language :: Python :: 3.6 Classifier: Programming Language :: Python :: 3.7 Description-Content-Type: text/x-rst Provides-Extra: testing