1。模型 图书和作者是多对多关系
class Book(models.Model):
book_name=models.CharField(max_length=40)
price=models.DecimalField(max_digits=4,decimal_places=2)
publish=models.ForeignKey(to="Publish",on_delete=models.CASCADE,related_name="publish")
author=models.ManyToManyField(to="Author",related_name="author")
class Meta:
db_table="tbl_book"
# def __str__(self):
# return self.book_name
class Publish(models.Model):
publish_name=models.CharField(max_length=20)
address=models.CharField(max_length=30)
class Meta:
db_table="tbl_publish"
# def __str__(self):
# return self.publish_name
class Author(models.Model):
sex_choices=[(0,"男"),(1,"女")]
name=models.CharField(max_length=20,unique=True)
phone=models.BigIntegerField()
sex=models.IntegerField(choices=sex_choices)
class Meta:
db_table="tbl_author"
# def __str__(self):
# return self.name
序列化器:
class SerBook(serializers.ModelSerializer):
""" add(1) add(1,2), set(list_object), remove(1), remove(1,2) or remove(*[1,2])"""
#publish = serializers.PrimaryKeyRelatedField(queryset=Publish.objects.all())
#author = serializers.PrimaryKeyRelatedField(allow_empty=False, many=True, queryset=Author.objects.all())
class Meta:
model=Book
fields="__all__"
class SerPublish(serializers.ModelSerializer):
class Meta:
model = Publish
fields = "__all__"
class SerAuthor(serializers.ModelSerializer):
class Meta:
model = Author
fields = "__all__"
视图以图书为例:
class BookView(APIView):
def get(self,request,*args,**kwargs):
pk= kwargs.get("id")
if pk :
inst = Book.objects.filter(id=kwargs.get("id")).first()
if inst:
ser = SerBook(instance=inst, many=False)
return Response(data=ser.data, status=200)
else:
return Response(data={"msg": "not found", "data": []}, status=200)
else:
inst = Book.objects.all()
ser = SerBook(instance=inst, many=True)
return Response(data=ser.data, status=200)
def post(self,request,*args,**kwargs):
data=request.data
many=False
if isinstance(data,list):
many=True
ser = SerBook(data=data, many=many)
if ser.is_valid():
ser.save()
return Response(data=ser.data, status=status.HTTP_200_OK)
else:
return Response(data=ser.errors, status=status.HTTP_404_NOT_FOUND)
def put(self,request,*args,**kwargs):
data=request.data
pk=kwargs.get("id")
if pk :
inst=Book.objects.filter(id=pk).first()
print(Book.objects.filter(id=pk).values().first(),"xxxx")
if inst:
ser = SerBook(instance=inst, many=False,data=data
)
if ser.is_valid():
ser.save()
return Response(data=ser.data, status=200)
序列化器结构:
postman测试:
创建单个图书:
PUT 修改图书根据图书book id:
多对多删除:
def delete(self,request,*args,**kwargs):
pk= kwargs.get("id")
data=request.data
if pk:
inst=Book.objects.filter(id=pk).first()
if inst:
inst.delete()
return Response(data={"code":200,"msg":"删除ok"})
else: return Response(data={"code":404,"msg":"删除失败,不存在!"})
else:
ids=data.get("ids")
if isinstance(ids,list):
objs=Book.objects.filter(id__in=ids)
objs.delete()
return Response(data={"code":200,"msg":"删除ok"})
批量删除: