GitHub - ooi-data-review/preload-database: database source scripts/files for preload

This repository has been archived by the owner on Aug 14, 2023. It is now read-only.

Name		Name	Last commit message	Last commit date
Latest commit History 108 Commits
csv		csv
model		model
templates		templates
test		test
.gitignore		.gitignore
.travis.yml		.travis.yml
README		README
RELEASE_NOTES		RELEASE_NOTES
__init__.py		__init__.py
config.py		config.py
database.py		database.py
database_util.py		database_util.py
generate_cql.py		generate_cql.py
list_stream_data.py		list_stream_data.py
load_preload.py		load_preload.py
ordered_dump.py		ordered_dump.py
parse_1100.py		parse_1100.py
parse_preload.py		parse_preload.py
pl_enum.py		pl_enum.py
preload_database.sql		preload_database.sql
requirements.txt		requirements.txt

Repository files navigation

This git module stores the code for downloading and parsing the preload data stored within the Google shared document:
    https://docs.google.com/spreadsheets/d/1jIiBKpVRBMU5Hb1DJqyR16XCkiX-CuTsn1Z1VnlRV4I/edit?pli=1#gid=1005276987

Files of interest:
    parse_preload.py     - Python script that generates a SQL script from the Google shared document
    preload_database.sql - The SQL script output by the parse script

To update the preload database SQL script execute the following command:
    python parse_preload.py