search

geopython / pygeoapi

pygeoapi is a Python server implementation of the OGC API suite of standards. The project emerged as part of the next generation OGC API efforts in 2018 and provides the capability for organizations to deploy a RESTful OGC API endpoint using OpenAPI, GeoJSON, and HTML. pygeoapi is open source and released under an MIT license.
https://pygeoapi.io
MIT License
459 stars 250 forks source link

Unsupported Column Types using PostgreSQL provider. #1695

Closed KoalaGeo closed 1 week ago

KoalaGeo commented 1 week ago

Description

On startup i get a list of unsupported columns which I believe should be supported with the exception of maybe bytea

START /entrypoint.sh
Trying to generate openapi.yml
Unsupported column type NUMERIC(4, 3)
Unsupported column type NUMERIC(12, 5)
Unsupported column type NUMERIC(7, 2)
Unsupported column type NUMERIC(5, 3)
Unsupported column type NUMERIC(20, 7)
Unsupported column type NUMERIC(12, 5)
Unsupported column type NUMERIC
Unsupported column type BYTEA
Unsupported column type TIMESTAMP
Unsupported column type NUMERIC(12, 6)
Unsupported column type NUMERIC(38, 0)
Unsupported column type NUMERIC(18, 7)
Unsupported column type NUMERIC(17, 7)
Unsupported column type NUMERIC(12, 6)
Unsupported column type NUMERIC(7, 2)
Unsupported column type NUMERIC(10, 7)
Unsupported column type NUMERIC(11, 7)
Unsupported column type NUMERIC(7, 2)
Unsupported column type NUMERIC(38, 10)
Generating /pygeoapi/local.openapi.yml
Done
openapi.yml generated continue to pygeoapi
make SCRIPT_NAME empty from /
Start gunicorn name=pygeoapi on 0.0.0.0:80 with 4 workers and SCRIPT_NAME=
[2024-06-25 10:41:22 +0000] [1] [INFO] Starting gunicorn 20.1.0
[2024-06-25 10:41:22 +0000] [1] [INFO] Listening at: http://0.0.0.0:80 (1)
[2024-06-25 10:41:22 +0000] [1] [INFO] Using worker: gevent
[2024-06-25 10:41:22 +0000] [13] [INFO] Booting worker with pid: 13
[2024-06-25 10:41:22 +0000] [14] [INFO] Booting worker with pid: 14
[2024-06-25 10:41:22 +0000] [15] [INFO] Booting worker with pid: 15
[2024-06-25 10:41:22 +0000] [16] [INFO] Booting worker with pid: 16
[2024-06-25T10:41:30Z] {/pygeoapi/pygeoapi/api/__init__.py:1393} ERROR - Collection not found

Steps to Reproduce Connect to postgres which data using these datatypes

Expected behavior Should be supported

Screenshots/Tracebacks image

Environment latest docker image connecting to postgres 16

tomkralidis commented 1 week ago

@KoalaGeo there is now a PR in #1696. I've relaxed the JSON string format warning to a simply debug (only JSON string types emit the format semantic). If you can test the PR before I merge that would be valuable for further validation (I've targeted this issue/PR for 0.17, which is due for release this month).

KoalaGeo commented 1 week ago

Yes, thats working, thank you! -https://github.com/geopython/pygeoapi/pull/1696#issuecomment-2194446825