在Django查询集中匹配可选字段中的空条目与必填字段中的对应条目

-1 投票
2 回答
844 浏览
提问于 2025-04-15 21:23

我在视图中有一个django的查询集(queryset),我会把它的值打包好,然后传给模板。不过,当这个查询集返回none的时候,就会出现问题,因为相关的值没有被解包。这个查询集叫做comments

这是我的views.py文件

def forums(request ):


post_list = list(forum.objects.filter(child='0')&forum.objects.filter(deleted='0').order_by('postDate'))
user = UserProfile.objects.get(pk=request.session['_auth_user_id'])
newpostform = PostForm(request.POST)
deletepostform = PostDeleteForm(request.POST)
DelPostFormSet = modelformset_factory(forum, exclude=('child','postSubject','postBody','postPoster','postDate','childParentId'))
readform = ReadForumForm(request.POST)
comments =list( forum.objects.filter(deleted='0').filter(child='1').order_by('childParentId').values('childParentId').annotate(y=Count('childParentId')))


if request.user.is_staff== True :
    staff = 1
else:
    staff = 0
staffis = 1




if newpostform.is_valid():
    topic = request.POST['postSubject']
    poster = request.POST['postPoster']
    newpostform.save()
    return HttpResponseRedirect('/forums')

else:
    newpostform = PostForm(initial = {'postPoster':user.id})

if request.GET:
    form = SearchForm(request.GET)
    if form.is_valid():
        query = form.cleaned_data['query']
        post_list = list((forum.objects.filter(child='0')&forum.objects.filter(deleted='0')&forum.objects.filter(Q(postSubject__icontains=query)|Q(postBody__icontains=query)|Q(postDate__icontains=query)))or(forum.objects.filter(deleted='0')&forum.objects.filter(Q(postSubject__icontains=query)|Q(postBody__icontains=query)|Q(postDate__icontains=query)).values('childParentId')))

if request.method == 'POST':
    delpostformset = DelPostFormSet(request.POST)
    if delpostformset.is_valid():
        delpostformset.save()
        return HttpResponseRedirect('/forums')

else:
    delpostformset = DelPostFormSet(queryset=forum.objects.filter(child='0', deleted='0'))



"""if readform.is_valid():
    user=get_object_or_404(UserProfile.objects.all())
    readform.save()
else:
    readform = ReadForumForm()"""

post= zip( post_list,comments, delpostformset.forms)
paginator = Paginator(post, 10) # Show 10 contacts per page

# Make sure page request is an int. If not, deliver first page.
try:
    page = int(request.GET.get('page', '1'))
except ValueError:
    page = 1

# If page request (9999) is out of range, deliver last page of results.
try:
    post = paginator.page(page)
except (EmptyPage, InvalidPage):
    post = paginator.page(paginator.num_pages)

return render_to_response('forum.html', {'post':post, 'newpostform': newpostform,'delpost':delpostformset, 'username':user.username, 'comments':comments, 'user':user,  },context_instance = RequestContext( request ))

我意识到问题出在comments这个查询集上,具体代码是comments = list(forum.objects.filter(deleted='0').filter(child='1').order_by('childParentId').values('childParentId').annotate(y=Count('childParentId')))。这个查询集只会返回有评论的帖子。因此,我现在需要一种方法,当post-list中的某个值post_list = list(forum.objects.filter(child='0')&forum.objects.filter(deleted='0').order_by('postDate'))没有评论时,能够返回0条评论(这是一个可选字段)。

这是我的models.py文件

class forum(models.Model):
    postID = models.AutoField(primary_key=True)
    postSubject = models.CharField(max_length=100)
    postBody = models.TextField()
    postPoster = models.ForeignKey(UserProfile)
    postDate =  models.DateTimeField(auto_now_add=True)
    child = models.BooleanField()
    childParentId = models.ForeignKey('self',blank=True, null=True)
    deleted = models.BooleanField()

    def __unicode__(self):
        return u' %d' % ( self.postID)

2 个回答

0

我觉得你可能没有做对。我不相信查询集(queryset)会返回None。为什么不直接把filter方法连在一起用呢?

list(forum.objects.filter(child='0').filter(deleted='0').order_by('postDate'))

如果你有更复杂的查询,可以使用django的查询对象,这样你就可以使用&|这些逻辑运算符了。

3

你可以这样做:

comments = list(queryset or [])

如果查询结果是空的,也就是说没有找到任何内容,那么就会使用一个空列表,这样comments就会变成一个空列表。

撰写回答