bcgov / bcgov/bcdata_py

bc2pg - simplify

Ouverte
#209 0 commentaires 0 réactions 0 personnes assignées Voir sur GitHub
Langage dominant
Python
Étoiles
32
Forks
7
Merge moyen
12 min
PR mergées (30 j)
14

Description

Data loads to existing postgres tables can be done via `bcdata dump | ogr2ogr`, a specific postgres loader isn't really required.

`bc2pg` could be stripped back to just table creation from the catalogue provided metadata:
- read schema from bcdc catalogue
- download a sample of the data
- create empty table based on combination of bcdc schema and data download
- add comments to columns/table
- do not attempt to track the primary keys

Maybe support providing a mapping of {"column_name": "column_type"} to override the detected types - but this is not a priority. Just guess the types / add comments and let the user alter the postgres table definition if any customization required.

Low priority as existing bc2pg works fine apart from minor noted issues - but for v1.0, simplifying makes sense.

Guide de contribution

Aucun guide de contribution indexé pour ce dépôt

Évaluation

Cette issue n'a pas encore été évaluée.

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.