New sqlalchemy filtering errors

[mahenzon]

0: error processing invalid filters (value instead of val)

[
  {
    "name": "meta",
    "op": "eq",
    "val": {"foo":  "bar"}
  }
]

You'll get an error here:

FastAPI-JSONAPI/fastapi_jsonapi/data_layers/filtering/sqlalchemy.py

Line 254 in 3e68db5

return set(filter_item.keys()) == terminal_node_keys

1: error processing json

Try creating a filter like this:

[
  {
    "name": "meta",
    "op": "eq",
    "val": {"foo":  "bar"}
  }
]

The problem is here:

FastAPI-JSONAPI/fastapi_jsonapi/data_layers/filtering/sqlalchemy.py

Lines 199 to 201 in 3e68db5

	# for Union annotations
	if schema_field.sub_fields:
	fields = list(schema_field.sub_fields)

[mahenzon]

можно взять как отправную точку вот такую переделку. Но надо ещё списки обрабатывать

fields = {
    schema_field.name: (schema_field.outer_type_, schema_field.field_info),
}

class Config:
    arbitrary_types_allowed = True

# Create the model using create_model
ValidationModel = pydantic.create_model(
    "ValidationModel",
    **fields,
    __config__=Config,
)
validated = ValidationModel.parse_obj({schema_field.name: value})
val = getattr(validated, schema_field.name)
return getattr(model_column, operator)(val)