Add queryables route for Features API

bbox-services / bbox

BBOX services

https://www.bbox.earth/

Apache License 2.0

55 stars 9 forks source link

Add queryables route for Features API #57

Closed kdesjard closed 3 months ago

kdesjard commented 4 months ago

Add a Features API queryables route (json+html) (https://docs.ogc.org/DRAFTS/19-079r1.html#queryables)

new function to get column types from the sql query and optionally filter using a list of names
updated sql building to not require casting to text as the queryable fields types are now known
updated sql building to use push_bind for the datetime ranges
updated openapi.yaml

pka commented 3 months ago

Sorry for the silence, it was holiday time here.

I've run the latest DB tests and got some failures, which I don't understand immediately. Could you please rebase and check the tests? The test database has changed in the meantime:

docker run -p 127.0.0.1:5439:5432 -d --name mvtbenchdb --rm sourcepole/mvtbenchdb:v1.2
cargo test -- --ignored

Will add them to the CI, soon...

pka commented 3 months ago

Do the PG tests pass now?

kdesjard commented 3 months ago

Pull req passes features tests

pka commented 3 months ago

Could you please rebase once more? This will fix the the x86_64-apple-darwin build failure and run the DB tests.