fromtypingimportType,UnionimportpytestfrompydanticimportVERSION,BaseModel,ValidationErrorfrompydanticimportFieldasPFieldfromsqlmodelimportField,SQLModel# -----------------------------------------------------------------------------------# ModelsclassPydanticUser(BaseModel):full_name:str=PField(alias="fullName")classSQLModelUser(SQLModel):full_name:str=Field(alias="fullName")# Models with config (validate_by_name=True)ifVERSION.startswith("2."):classPydanticUserWithConfig(PydanticUser):model_config= {"validate_by_name":True}classSQLModelUserWithConfig(SQLModelUser):model_config= {"validate_by_name":True}else:classPydanticUserWithConfig(PydanticUser):classConfig:allow_population_by_field_name=TrueclassSQLModelUserWithConfig(SQLModelUser):classConfig:allow_population_by_field_name=True# -----------------------------------------------------------------------------------# Tests# Test validate by name@pytest.mark.parametrize("model", [PydanticUser,SQLModelUser])deftest_create_with_field_name(model:Union[Type[PydanticUser],Type[SQLModelUser]]):withpytest.raises(ValidationError):model(full_name="Alice")@pytest.mark.parametrize("model", [PydanticUserWithConfig,SQLModelUserWithConfig])deftest_create_with_field_name_with_config(model:Union[Type[PydanticUserWithConfig],Type[SQLModelUserWithConfig]],):user=model(full_name="Alice")assertuser.full_name=="Alice"# Test validate by alias@pytest.mark.parametrize("model",    [PydanticUser,SQLModelUser,PydanticUserWithConfig,SQLModelUserWithConfig],)deftest_create_with_alias(model:Union[Type[PydanticUser],Type[SQLModelUser],Type[PydanticUserWithConfig],Type[SQLModelUserWithConfig],    ],):user=model(fullName="Bob")# using aliasassertuser.full_name=="Bob"# Test validate by name and alias@pytest.mark.parametrize("model", [PydanticUserWithConfig,SQLModelUserWithConfig])deftest_create_with_both_prefers_alias(model:Union[Type[PydanticUserWithConfig],Type[SQLModelUserWithConfig]],):user=model(full_name="IGNORED",fullName="Charlie")assertuser.full_name=="Charlie"# alias should take precedence# Test serialize@pytest.mark.parametrize("model", [PydanticUser,SQLModelUser])deftest_dict_default_uses_field_names(model:Union[Type[PydanticUser],Type[SQLModelUser]],):user=model(fullName="Dana")data=user.dict()assert"full_name"indataassert"fullName"notindataassertdata["full_name"]=="Dana"# Test serialize by alias@pytest.mark.parametrize("model", [PydanticUser,SQLModelUser])deftest_dict_default_uses_aliases(model:Union[Type[PydanticUser],Type[SQLModelUser]],):user=model(fullName="Dana")data=user.dict(by_alias=True)assert"fullName"indataassert"full_name"notindataassertdata["fullName"]=="Dana"# Test json by alias@pytest.mark.parametrize("model", [PydanticUser,SQLModelUser])deftest_json_by_alias(model:Union[Type[PydanticUser],Type[SQLModelUser]],):user=model(fullName="Frank")json_data=user.json(by_alias=True)assert ('"fullName":"Frank"'injson_data)or ('"fullName": "Frank"'injson_data)assert"full_name"notinjson_data

t.py::test_create_with_field_name[PydanticUser] PASSEDt.py::test_create_with_field_name[SQLModelUser] FAILEDt.py::test_create_with_field_name_with_config[PydanticUserWithConfig] PASSEDt.py::test_create_with_field_name_with_config[SQLModelUserWithConfig] PASSEDt.py::test_create_with_alias[PydanticUser] PASSEDt.py::test_create_with_alias[SQLModelUser] FAILEDt.py::test_create_with_alias[PydanticUserWithConfig] PASSEDt.py::test_create_with_alias[SQLModelUserWithConfig] FAILEDt.py::test_create_with_both_prefers_alias[PydanticUserWithConfig] PASSEDt.py::test_create_with_both_prefers_alias[SQLModelUserWithConfig] FAILEDt.py::test_dict_default_uses_field_names[PydanticUser] PASSEDt.py::test_dict_default_uses_field_names[SQLModelUser] FAILEDt.py::test_dict_default_uses_aliases[PydanticUser] PASSEDt.py::test_dict_default_uses_aliases[SQLModelUser] FAILEDt.py::test_json_by_alias[PydanticUser] PASSEDt.py::test_json_by_alias[SQLModelUser] FAILED