Django.db.utils.IntegrityError: и django.db.utils.OperationalError:

raise IntegrityError( django.db.utils.IntegrityError: Строка в таблице 'hazeapp_orderitem' с первичным ключом '1' имеет недопустимый внешний ключ: hazeapp_orderitem.product_id содержит значение '5', которое не имеет соответствующего значения в hazeapp_newarrival.id. django.db.utils.OperationalError: нет такой колонки: hazeapp_orderitem.collection_id

class NewArrival(models.Model):
    name = models.CharField(max_length=200, null=False, blank=True)
    price = models.FloatField(default=0)
    image = models.ImageField(null=True, blank=True)

    def __str__(self):
        return self.name

class Collection(models.Model):
    name = models.CharField(max_length=200, null=False, blank=True)
    price = models.FloatField(default=0)
    image = models.ImageField(null=True, blank=True)

    def __str__(self):
        return self.name

class Order(models.Model):
    customer = models.ForeignKey(Customer, on_delete=models.SET_NULL, blank=True, null=True)
    date_ordered = models.DateTimeField(auto_now_add=True)
    complete = models.BooleanField(default=False, null=True, blank=False)
    transaction_id = models.CharField(max_length=200, null=True)

    def __str__(self):
        return str(self.id)
       
class OrderItem(models.Model):
    collection = models.ForeignKey(Collection, on_delete=models.SET_NULL, blank=True, null=True)
    newarrival = models.ForeignKey(NewArrival, on_delete=models.SET_NULL, blank=True, null=True)
    order = models.ForeignKey(Order, on_delete=models.SET_NULL, blank=True, null=True) 
    quantity = models.IntegerField(default=0, null=True, blank=True) 
    date_added = models.DateTimeField(auto_now_add=True)

    @property
    def get_total(self):
        total = 0
        if self.collection:
            total += self.collection.price * self.quantity
        if self.newarrival:
            total += self.newarrival.price * self.quantity
        return total

Вернуться на верх