Skip to main content
 首页 » 编程设计

python之Django NOT NULL 约束失败 : shop_product. user_id

2025年05月04日36zlslch

我是 Django 的新手,我正在尝试通过一些项目的实践来学习,但我遇到了这个问题,

NOT NULL constraint failed: shop_product.user_id

模型.py

from django.db import models 
from django.conf import settings 
from django.core.urlresolvers import reverse 
class Category(models.Model): 
    user = models.ForeignKey(settings.AUTH_USER_MODEL, 
                             related_name='category_created') 
    name = models.CharField(max_length=200, db_index=True) 
    slug = models.SlugField(max_length=200, db_index=True, unique=True) 
 
    class Meta: 
        ordering = ('name',) 
        verbose_name = 'category' 
        verbose_name_plural = 'categories' 
 
    def __str__(self): 
        return self.name 
 
class Product(models.Model): 
    user = models.ForeignKey(settings.AUTH_USER_MODEL, 
                             related_name='product_created') 
    category = models.ForeignKey(Category, related_name='products') 
    name = models.CharField(max_length=200, db_index=True) 
    slug = models.SlugField(max_length=200, db_index=True) 
    image = models.ImageField(upload_to='products/%Y/%m/%d', blank=True) 
    description = models.TextField(blank=True) 
    price = models.DecimalField(max_digits=10, decimal_places=2) 
    stock = models.PositiveIntegerField() 
    available = models.BooleanField(default=True) 
    negiotiable = models.BooleanField(default=True) 
    created = models.DateTimeField(auto_now_add=True) 
    updated = models.DateTimeField(auto_now=True) 
    users_like = models.ManyToManyField(settings.AUTH_USER_MODEL, 
                                        related_name='product_liked', 
                                        blank=True) 
 
    class Meta: 
        ordering = ('name',) 
        index_together = (('id', 'slug'),) 
 
    def __str__(self): 
        return self.name 
    def get_absolute_url(self): 
        return reverse('products_detail', 
                       args=[self.slug]) 

这是我的 views.py 但我不确定我的观点是否有问题,我认为问题一定出在我的模型上....

views.py

from django.views.generic import * 
from django.core.urlresolvers import reverse_lazy 
from .models import Category, Product 
 
class CategoryList(ListView): 
    model = Category 
 
class CategoryDetail(DetailView): 
    model = Category 
 
class ProductList(ListView): 
    model = Product 
 
class ProductDetail(DetailView): 
    model = Product 
 
class ProductCreate(CreateView): 
    model = Product 
    fields = ("category", 'name', 'image', 'description', 'price', 'stock','available', 'negiotiable') 
 
class ProductUpdate(UpdateView): 
    model = Product 
    fields = ('name', 'image', 'description', 'price', 'stock','available', 'negiotiable') 
 
class ProductDelete(DeleteView): 
    model = Product 
    success_url = reverse_lazy('product_list') 

请告诉我可以做什么。

请您参考如下方法:

将用户添加到列表中:

class ProductCreate(CreateView): 
    model = Product 
    fields = ["category", 'name', 'image', 'description', 'price','stock','available', 'negiotiable', 'user'] 

或确保 Field 必须为 null=true 和 blank=True。

class Product(models.Model): 
    user = models.ForeignKey(settings.AUTH_USER_MODEL, 
                         related_name='product_created', null=True, blank=True)