Open MatsiukMykola opened 11 months ago
anyway i have work good solution to parse mongo-style queries to sqlalchemy, work fine in many projects:
sample:
{
"limit": 5,
"skip": 1,
# can be string or List[str]
# 'order_by': 'price desc, name asc',
"order_by": ["price desc", "name asc"],
# can be string, search-term or dict
"where": {"or": [{"price": {"lt": 100}}, {"price": {"gt": 66}}]},
# calculate count (need only for pagination), don't use if you don't need them
"with_count": True,
}
I can help implement this side or public this project main future: nested conditions
from you side - need you support something like: https://querybuilder.js.org/ in UI
hello, please add
to fastapi_amis_admin\crud_sqlalchemy.py
or need some way to extend in runtime flexibly
my ugly way to global ovveride: # extend amis-admin search futures, example: [~]%Yogurt%