forked from oceanobservatories/preload-database
-
Notifications
You must be signed in to change notification settings - Fork 0
petercable/preload-database
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
This git module stores the data (as CSV) and code for parsing this data and inserting it into an SQL database. Files of interest: load_preload.py - Python script that generates a SQL script from CSV files preload_database.sql - The SQL script output by the parse script suitable for creating an SQLite database To create a virtualenv capable of running load_preload.py (requires postgres libraries installed): mkvirtualenv preload pip install -r requirements.txt To create a conda env capable of running load_preload.py: conda env create -f conda_env.yml source activate preload To create or update the preload_database.sql file: python load_preload.py To directly create or update an SQLite database: python load_preload.py sqlite:///preload.db To fill or update a postgres database: python load_preload.py postgresql://user@localhost/dbname
About
database source scripts/files for preload
Resources
Stars
Watchers
Forks
Packages 0
No packages published
Languages
- PLpgSQL 94.2%
- Python 5.5%
- HTML 0.3%