geopython / pycsw

pycsw is an OGC CSW server implementation written in Python. pycsw fully implements the OpenGIS Catalogue Service Implementation Specification [Catalogue Service for the Web]. Initial development started in 2010 (more formally announced in 2011). The project is certified OGC Compliant, and is an OGC Reference Implementation. pycsw allows for the publishing and discovery of geospatial metadata via numerous APIs (CSW 2/CSW 3, OpenSearch, OAI-PMH, SRU). Existing repositories of geospatial metadata can also be exposed, providing a standards-based metadata and catalogue component of spatial data infrastructures. pycsw is Open Source, released under an MIT license, and runs on all major platforms (Windows, Linux, Mac OS X). Please read the docs at https://pycsw.org/docs for more information.
https://pycsw.org
MIT License
209 stars 155 forks source link

some tests with date filters #1034

Open pvgenuchten opened 1 month ago

pvgenuchten commented 1 month ago

Some queries work fine on demo, but not on our postgres backed instance, differences can be explained by the database?

after date; error: sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedFunction) operator does not exist: text >= timestamp with time zone LINE 4: WHERE records.insert_date >= '2020-07-16T00:00:00+00:00'::ti...

using during keyword sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedFunction) operator does not exist: text >= timestamp with time zone LINE 4: WHERE records.date >= '1969-07-16T13:32:00+00:00'::timestamp...

Seems the field is text, date type is expected?

I also tried date without T00:00:00Z, but then the code converted the date to an integer (1969 minus 07 minus 16 = 1946)