pydantic 和 sqlalchemy 之间的模型转换
字段dict
# Assuming `session` is your SQLAlchemy session
user_instance = session.query(User).first()
# Convert to Pydantic model
dapter = TypeAdapter(User, UserPydantic)
user_pydantic = adapter.to_pydantic(user_instance)
# 也可以
UserPydantic.model_validate(user_instance)
print(user_pydantic.json())
列表
# Assuming `session` is your SQLAlchemy session
user_instances = session.query(User).all()
# Convert to Pydantic model
TypeAdapter(List[UserPydantic]).validate_python(user_instances)
模型设置
class UserPydantic(BaseModel):
id: int
name: str
email: str
label_json: List[Dict]
class Config:
orm_mode = True
from_attributes=True
alias_generator = to_camel
populate_by_name = True
``
本文来自博客园,作者:vx_guanchaoguo0,转载请注明原文链接:https://www.cnblogs.com/guanchaoguo/p/18406484