Filters: datetime filter example not working

[Huuhailija]

When you define SQLalchemy model with:

and make schema according to:

Then you produce error at filter creation in sqlalchemy.py at line 86 trying to cast type(value) to datetime, when filter value is str format.

Seems like it's not intended to use datetime value in filtering. Changing schema to str will fix the error, but will result more problems later with ORM models which expects datetime matching column.

Using filter example in SwaggerUI as filter parameter.

[Huuhailija]

The issue seems to present in the repo example too. https://github.com/mts-ai/FastAPI-JSONAPI/tree/main/examples/api_for_sqlalchemy

[Huuhailija]

Making clear_value = datetime.strptime(value, '%Y-%m-%dT%H:%M:%S.%f'), will fix the issue and the underlying query filter will work as expected returning records between timestamps. This method needs to cast datetimes properly for filtering to work. Hope this will be updated soon.

[mahenzon]

ouch, thank you, we'll take a look