Django:将JSON POST数据添加到数据库中

2024-10-01 11:34:21 发布

您现在位置:Python中文网/ 问答频道 /正文

我正在为一个屠夫制作一个API。 有了这个API和我将在下一个月建立的网站,客户将能够远程下订单。 这是我的问题。 通过订单,客户机向我发送JSON数据,如下所示:

{
    "user": 8,
    "orderDay": "2020-06-24",
    "deliveryDay": "2020-06-30",
    "deliveryAddress": "Place des Fêtes",
    "comment": "",
    "orderDetail": 
    [
        {
            "product": 2,
            "byProduct": 2,
            "quantity": 43
        },
        {
            "product": 3,
            "byProduct": 3,
            "quantity": 5
        }
    ]
}

这些数据必须保存在数据库中。 以下是我使用的模型:models.py

class order(models.Model):
    user = models.ForeignKey(memberArea, on_delete=models.CASCADE)
    comment = models.TextField(null=True, blank=True)
    orderDay = models.DateTimeField(auto_now_add=True)
    deliveryDay = models.DateField()
    deliveryAddress = models.CharField(max_length=255)
    state = models.CharField(max_length=255)
    price = models.TextField(null=True, blank=True)
    response = models.TextField(null=True, blank=True)

class orderDetail(models.Model):
    order = models.ForeignKey(order, on_delete=models.CASCADE)
    product = models.ForeignKey(product, on_delete=models.CASCADE)
    byProduct = models.ForeignKey(byProduct, on_delete=models.CASCADE)
    quantity = models.CharField(max_length=255)

class product(models.Model):
    name = models.CharField(max_length=255)
    prix_uni = models.TextField(null=True, blank=True)
    prix_kg = models.TextField(null=True, blank=True)
    dispo = models.BooleanField(null=True, blank=True)
    category = models.ForeignKey(category, on_delete=models.CASCADE)
    redu = models.TextField(null=True, blank=True)

class byProduct(models.Model):
    product = models.ForeignKey(product, on_delete = models.CASCADE)
    name = models.CharField(max_length=255)

我创建了一个序列化程序文件,如下所示serializer.py

class orderDetailSerializer(serializers.ModelSerializer):

    order = serializers.PrimaryKeyRelatedField(many=False, queryset = order.objects.all())

    class Meta:
        model = orderDetail
        fields = '__all__'

class OrderSerializer(serializers.ModelSerializer):

    orderDetail = orderDetailSerializer(many=True)

    class Meta:
        model = order
        fields = ['user', 'comment', 'deliveryAddress', 'deliveryDay', 'orderDetail']

    def create(self, validated_data):
            order_detail_data = validated_data.pop('orderDetail')
            new_order = order.objects.create(**validated_data)
            new_order.save()
            for product in order_detail_data:
                order_detail = orderDetail.objects.create(order=new_order, **product)
                new_order.orderDetail.add(order_detail.id)
            
            return new_order

这是我的观点:views.py

#Make an order
@api_view(['POST'])
def order(request, format=None):
    if request.method == 'POST':
        serializer = OrderSerializer(data=request.data)
        data = {}
        if serializer.is_valid():
            serializer.save()
            data['response'] = "Your order went well"
            return Response(data)
        return Response(serializer.errors)

当我尝试运行代码时,它告诉我缺少订单数据:

{
    "orderDetail": [
        {
            "order": [
                "This field is required."
            ]
        },
        {
            "order": [
                "This field is required."
            ]
        }
    ]
}

我不知道如何添加它,因为我需要的order_id是在orderDetail创建的同时创建的。 谢谢你的帮助


Tags: truedataonmodelsorderproductdeletenull
1条回答
网友
1楼 · 发布于 2024-10-01 11:34:21

您应该在orderDetailSerializer中创建order字段readonly

class orderDetailSerializer(serializers.ModelSerializer):

    class Meta:
        model = orderDetail
        fields = '__all__'
        read_only_fields = ('order',)
        

相关问题 更多 >