Django非空约束违反错误：无法向elephantSQL写入数据

问题描述 #

作为Django新手，向elephantSQL数据库写入ReviewRating数据时触发IntegrityError，提示违反非空约束（列存在空值）。尝试通过URL、按钮及视图传递post.id，但问题未解决。

错误根源分析 #

代码中存在以下核心问题导致非空约束错误：

• createReview视图未从请求中提取传递的post_id，且错误使用Post.objects.get()获取实例
• 直接操作表单对象而非表单保存后的实例，导致ReviewRating的post字段未正确赋值
• edit/delete视图逻辑混乱：错误操作Post模型而非ReviewRating，使用未定义的OrderForm，变量名重复或未定义
• URL配置缺失pk参数，edit和delete视图无法定位目标ReviewRating记录
• createReview视图未将post对象传入模板，可能导致隐藏字段post_id无值

修正步骤 #

1. 修复createReview视图 #

from django.contrib.auth.decorators import login_required

@login_required  # 确保用户已登录
def createReview(request):
    form = ReviewForm()
    
    if request.method == 'POST':
        form = ReviewForm(request.POST)
        if form.is_valid():
            # 从POST请求中获取post_id
            post_id = request.POST.get('post_id')
            post = get_object_or_404(Post, id=post_id)
            # 保存表单但暂不提交到数据库
            review = form.save(commit=False)
            # 关联post和当前用户
            review.post = post
            review.user = request.user
            review.save()
            messages.success(request, '评论已成功提交！')
            return redirect('post_detail', slug=post.slug)

    # 从GET参数获取post_id，传入模板上下文
    post_id = request.GET.get('post_id')
    context = {'form': form}
    if post_id:
        context['post'] = get_object_or_404(Post, id=post_id)
    return render(request, 'market/review_form.html', context)

2. 修复editReview视图 #

@login_required
def editReview(request, pk):
    review = get_object_or_404(ReviewRating, pk=pk)
    # 验证当前用户是评论作者
    if review.user != request.user:
        messages.error(request, '无权限编辑此评论！')
        return redirect('post_detail', slug=review.post.slug)
    
    form = ReviewForm(instance=review)

    if request.method == 'POST':
        form = ReviewForm(request.POST, instance=review)
        if form.is_valid():
            form.save()
            messages.success(request, '评论已更新！')
            return redirect('post_detail', slug=review.post.slug)

    context = {'form': form, 'post': review.post}
    return render(request, 'market/review_form.html', context)

3. 修复deleteReview视图 #

@login_required
def deleteReview(request, pk):
    review = get_object_or_404(ReviewRating, pk=pk)
    # 验证当前用户是评论作者
    if review.user != request.user:
        messages.error(request, '无权限删除此评论！')
        return redirect('post_detail', slug=review.post.slug)
    
    if request.method == "POST":
        post_slug = review.post.slug
        review.delete()
        messages.success(request, '评论已删除！')
        return redirect('post_detail', slug=post_slug)

    context = {'item': review, 'post': review.post}
    return render(request, 'market/delete.html', context)

4. 更新URL配置 #

urlpatterns = [
    path('', views.index, name='index'),
    path('market_posts/', views.PostList.as_view(), name='market_posts'),
    path('market/<slug:slug>/', views.PostDetail.as_view(), name='post_detail'),
    path('like/<slug:slug>', views.PostLike.as_view(), name="post_like"),

    path('create_review/', views.createReview, name="create_review"),
    path('edit_review/<int:pk>/', views.editReview, name="edit_review"),
    path('delete_review/<int:pk>/', views.deleteReview, name="delete_review")
]

5. 优化文章详情页跳转链接 #

在post_detail.html中添加跳转评论表单的链接，传递post_id：

<a href="{% url 'create_review' %}?post_id={{ post.id }}" class="btn btn-primary">添加评论</a>

额外建议 #

• 为ReviewRating模型的rating字段添加取值范围验证：

rating = models.FloatField(validators=[MinValueValidator(1.0), MaxValueValidator(5.0)])

内容的提问来源于stack exchange，提问作者Jonny