python - django.db.utils.IntegrityError：唯一约束失败：auctions_bids.item_id

Question

我建立拍卖网站并遇到这个问题：

UNIQUE 约束失败：auctions_bids.item_id

模型.py

from django.contrib.auth.models import AbstractUser
from django.db import models
from django.db.models.deletion import CASCADE
from django.db.models.fields import EmailField, NOT_PROVIDED


class User(AbstractUser):
    pass

class Listings(models.Model):
    title = models.CharField(max_length=64)
    description = models.TextField(max_length=250)
    price = models.FloatField()
    image_url = models.CharField(max_length=150)
    category = models.ForeignKey(Categories, on_delete=models.CASCADE)
    listed_by = models.ForeignKey(User, on_delete=models.CASCADE)

    def __str__(self):
        return f"{self.title}" #{self.description} {self.price} {self.image_url} {self.category}"


class Bids(models.Model):
    item = models.OneToOneField(Listings, on_delete=models.CASCADE)
    bid = models.FloatField(blank=True)
    user_bid = models.ForeignKey(User, on_delete=models.CASCADE, blank=True)

    def __str__(self):
        return f"{self.item} {self.bid} {self.user_bid}"
    

视图.py

def placebid(request, id_product):
    if request.method == "POST":
        item_list = Listings.objects.get(pk=id_product)
        bid = request.POST['bid']
        user = request.user
        Bids.objects.update_or_create(item=item_list, bid=bid, user_bid=user)
        return redirect(reverse("listings", args=(id,)))

当我尝试更新新出价时，会出现上述错误，这是删除旧对象并创建新对象的唯一方法，如果对象存在，我想更新新出价，如果对象不存在则创建使用update_or_create

我认为我在设置 Bids 模型的参数项值时出错了，但我不知道如何修复它们！给我任何建议，非常感谢！！！

标签： pythondjangodjango-modelsdjango-views

Answer 1