bcgov / bcgov/bcdata_py

bc2pg - simplify

未关闭
#209 0 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
Python
星标
32
派生
7
平均合并
12 分钟
30 天内合并 PR
14

描述

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.

贡献指南

这个仓库没有索引到贡献指南

评估

这个 Issue 还没有评估数据。

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。