(1062，"Django Rest Framework"上键"orders_orderitem.orders_orderitem_orderItem_ID_7d6cd69b_uniq"的重复条目"81CLZECZRW") [英] (1062, "Duplicate entry '81CLZECZRW' for key 'orders_orderitem.orders_orderitem_orderItem_ID_7d6cd69b_uniq'") on Django Rest Framework

问题描述

我正在尝试在订单创建api中生成uniq OrderItem_ID.但是，它会生成上述错误，作为 django.db.utils.IntegrityError:

I am trying to generate a uniq OrderItem_ID during the order create api. But, it generates the above error as django.db.utils.IntegrityError:

第一个api总是可以从邮递员那里获得成功，但是在第二个调用中，我尝试更改不同的产品来创建订单，但是我得到了这个唯一的id订单.

The first api is always successful from the postman, but in the second call I tried changing different products for creating the order, but I am getting this unique id order.

我必须从db中删除order_items，以创建一个新的order_item对象，否则会出现此唯一错误.

I have to remove the order_items from db , to create a new order_item object otherwise I get this unique error.

我正在发送这样的数据.

I am sending data like this.

我的模特:

import random
import string
# Create your models here.

def id_generator(size=10, chars=string.ascii_uppercase + string.digits):
   return ''.join(random.choice(chars) for _ in range(size))

class Order(models.Model):
    ORDER_STATUS = (
        ('To_Ship', 'To Ship',),
        ('Shipped', 'Shipped',),
        ('Delivered', 'Delivered',),
        ('Cancelled', 'Cancelled',),
    )
    user = models.ForeignKey(User, on_delete=models.CASCADE, blank=True)    
    order_status = models.CharField(max_length=50,choices=ORDER_STATUS,default='To_Ship')

    ordered_date = models.DateTimeField(auto_now_add=True)
    ordered = models.BooleanField(default=False)
    total_price = models.CharField(max_length=50,blank=True,null=True)
    
    def __str__(self):
        return self.user.email

    class Meta:
        verbose_name_plural = "Orders"
        ordering = ('-id',)

class OrderItem(models.Model):    
    orderItem_ID = models.CharField(max_length=12,unique=True, editable=False, default=id_generator())
    order = models.ForeignKey(Order,on_delete=models.CASCADE, blank=True,null=True,related_name='order_items')
    item = models.ForeignKey(Product, on_delete=models.CASCADE,blank=True, null=True)
    order_variants = models.ForeignKey(Variants,on_delete=models.CASCADE,blank=True,null=True)
    quantity = models.IntegerField(default=1)    
    total_item_price = models.PositiveIntegerField(blank=True,null=True,)

我的序列化器:

class OrderSerializer(serializers.ModelSerializer):

    billing_details = BillingDetailsSerializer()
    order_items = OrderItemSerializer(many=True)
    user = serializers.PrimaryKeyRelatedField(read_only=True, default=serializers.CurrentUserDefault())
    class Meta:
        model = Order
        fields = ['id','user','ordered_date','order_status', 'ordered', 'order_items', 'total_price','billing_details']
        # depth = 1   

    def create(self, validated_data):
        user = self.context['request'].user
        if not user.is_seller:
            order_items = validated_data.pop('order_items')
            billing_details = validated_data.pop('billing_details')
            order = Order.objects.create(user=user,**validated_data)
            BillingDetails.objects.create(user=user,order=order,**billing_details)
            for order_items in order_items:
                OrderItem.objects.create(order=order,**order_items)
           
            return order
        else:
            raise serializers.ValidationError("This is not a customer account.Please login as customer.")

在python shell中，我对此感到厌倦，并且效果很好

In python shell, i tired this and it works fine

推荐答案

问题出在

orderItem_ID = models.CharField(max_length=12,unique=True, editable=False, default=id_generator())

在默认情况下，您已经分配了函数调用.因此，它只会在创建时(即，您第一次运行makemigrations时)进行一次评估.

Here in the default, you're have assigned function call. Thus, it will only be evaluated once at the time of creation, .i.e., at first time you run makemigrations.

我们需要在默认值中包含函数引用，这样每次创建新实例时都会调用它.

We need to have function references in the default values, this way it will be called each time a new instance is created.

尝试将行替换为

orderItem_ID = models.CharField(max_length=12,unique=True, editable=False, default=id_generator)

请注意 default = id_generator ，而不是 default = id_generator().

希望这可以回答您的问题.PS:您将需要重新运行makemigrations和migrations命令，以使此更改生效.

Hope this answers your question. PS: you would be required to rerun the makemigrations and migrations commands to set this change into effect.

这篇关于(1062，"Django Rest Framework"上键"orders_orderitem.orders_orderitem_orderItem_ID_7d6cd69b_uniq"的重复条目"81CLZECZRW")的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！