[BUG] search criteria not using pydantic Field alias to set the key.

[axiangcoding]

Describe the bug

search criteria not using pydantic alias to set the key.

To Reproduce

class VehicleBaseInfo(BaseModel):
    unit_class: str = Field(alias="unitClass")
    
class VehiclesInDB(Document):
    vehicle_info: VehicleBaseInfo

VehiclesInDB.find(VehiclesInDB.vehicle_info.unit_class == "something")

log here:

"command": "{\"aggregate\": \"vehicles\", \"pipeline\": [{\"$match\": {\"$and\": ...{\"vehicle_info.unit_class\": \"xxx\"}...}

Expected behavior
expecting search criteria like {"vehicle_info.unitClass": "xxx"}

Additional context
None

[github-actions]

This issue is stale because it has been open 30 days with no activity.

[axiangcoding]

anyone can help with this issue?

[mhennin]

I'm hitting the same issue. Pydantic aliases work for the first level object variable but none of the children.

For example, if my aliases are converting between snake-case and camel-case, it only uses the alias on the first level.

class CollectionFoo(Document):
    root_field: Child = Field(alias="rootField")
class Child(BaseModel):
    child_field = Field(alias="childField")

x = CollectionFoo.find(CollectionFoo.root_field.child_field == "value")
print(x.find_expressions)

Result: [{'rootField.child_field': 'value'}]
Expecting: [{'rootField.childField': 'value'}]

[axiangcoding]

Is this a problem related to pydantic or beanie? If this is a known issue, i think it is better write it down in the document

[mhennin]

This is not a problem with pydantic. I use pydantic extensively with other python projects using complex nested structures. Child names are correctly formatted to their name alias rules in serialization/deserialization. This only appears to be a problem with how Beanie is translating multi-level structures to mongo specific queries. It doesn't seem to honor the field aliases for 2nd level and down, only root level names.

[github-actions]

This issue is stale because it has been open 30 days with no activity.

[mhennin]

Not stale. This is still an issue.

[07pepa]

looks like bug in beanie