本系列汇总，请查看这里：https://www.cnblogs.com/uncleyong/p/19503695
说明
多对多，需要单独添加、更新
修改前
student表
student_course表没有ren的记录
全字段修改：方法一
from typing import List
from fastapi import APIRouter
from pydantic import BaseModel, field_validator
from test_orm.models import Student, Coursestudent_api = APIRouter()class StudentIn(BaseModel):name: strpwd: strsno: intclas_id: intcourses: List[int] = []@field_validator("name")def name_must_alpha(cls, value): # 使用 cls 而不是 selfassert value.isalpha(), 'name must be alpha'return value@field_validator("sno")@classmethod # 必须在下面def sno_validate(cls, value):assert 1000 <= value < 10000, '学号要在[1000-10000)的范围内'return value@student_api.put("/{student_id}")
async def updateStudent(student_id: int, student_in: StudentIn):# 和添加类似，多对多关系要单独处理print(student_in, type(student_in))await Student.filter(id=student_id).update(name=student_in.name, pwd=student_in.pwd, sno=student_in.sno,clas_id=student_in.clas_id)# 设置多对多的选修课edit_stu = await Student.get(id=student_id)choose_courses = await Course.filter(id__in=student_in.courses)await edit_stu.courses.clear() # 清除之前的关系await edit_stu.courses.add(*choose_courses) # 重新绑定数据return edit_stu
请求数据
响应结果
数据库结果
全字段修改：方法二
from typing import Listfrom fastapi import APIRouter
from pydantic import BaseModel, field_validatorfrom test_orm.models import Student, Coursestudent_api = APIRouter()@student_api.get("/{student_id}")
async def getOneStudent(student_id: int):student = await Student.get(id=student_id)return studentclass StudentIn(BaseModel):name: strpwd: strsno: intclas_id: intcourses: List[int] = []@field_validator("name")def name_must_alpha(cls, value): # 使用 cls 而不是 selfassert value.isalpha(), 'name must be alpha'return value@field_validator("sno")@classmethod # 必须在下面def sno_validate(cls, value):assert 1000 <= value < 10000, '学号要在[1000-10000)的范围内'return value@student_api.put("/{student_id}")
async def updateStudent(student_id: int, student_in: StudentIn):# 和添加类似，多对多关系要单独处理# print(student_in, type(student_in))# await Student.filter(id=student_id).update(name=student_in.name, pwd=student_in.pwd, sno=student_in.sno,# clas_id=student_in.clas_id)# 设置多对多的选修课# edit_stu = await Student.get(id=student_id)# choose_courses = await Course.filter(id__in=student_in.courses)# await edit_stu.courses.clear() # 清除之前的关系# await edit_stu.courses.add(*choose_courses) # 重新绑定数据# 和上面等价，且更简单data = student_in.dict()print(data, type(data))courses = data.pop("courses") # courses的值是course这个key对应的value；data中就没有courses这个key了；print(courses, type(courses))print(data, type(data))await Student.filter(id=student_id).update(**data)# 设置多对多的选修课edit_stu = await Student.get(id=student_id)choose_courses = await Course.filter(id__in=courses)await edit_stu.courses.clear() # 清除之前的关系await edit_stu.courses.add(*choose_courses) # 重新添加数据return edit_stu
请求数据
响应结果
数据库结果
部分字段修改
from typing import Listfrom fastapi import APIRouter
from pydantic import BaseModel, field_validatorfrom test_orm.models import Student, Coursestudent_api = APIRouter()@student_api.get("/{student_id}")
async def getOneStudent(student_id: int):student = await Student.get(id=student_id)return studentclass StudentIn(BaseModel):name: strpwd: strsno: intclas_id: intcourses: List[int] = []@field_validator("name")def name_must_alpha(cls, value): # 使用 cls 而不是 selfassert value.isalpha(), 'name must be alpha'return value@field_validator("sno")@classmethod # 必须在下面def sno_validate(cls, value):assert 1000 <= value < 10000, '学号要在[1000-10000)的范围内'return value@student_api.put("/{student_id}")
async def updateStudent(student_id: int, student_in: StudentIn):# 只更新姓名和学号await Student.filter(id=student_id).update(name=student_in.name,sno=student_in.sno)# 获取更新后的学生信息返回updated_student = await Student.get(id=student_id)return updated_student
请求数据：只填需要修改的name和sno，其它默认不变
响应结果
数据库结构
下面方式会报错，StudentIn类型校验失败
