获取查询中的下一项

Question

以下是投票网站项目的一个片段，我正在尝试在投票后获得下一个类别。。。你知道吗

当用户成功投票后，我希望页面重定向到下一个类别。。。我所做的是获取该类别的id，然后将一个变量保存为next\u category，使原始类别的id增加1（next\u category=类别id+ 1). 你知道吗

但正如你所知道的，Django并没有严格地按顺序生成id，所以如果我之前删除了一个类别，比如说cat5，我将cat1 cat2考虑到cat10，当它到达cat4时，它会有问题

提名者视图提供特定类别的页面，投票视图是表单处理视图。 希望它足够解释。你知道吗

@login_required
def Nominees(request, category_id):
    categories = Category.objects.get(id=category_id)
    next_category = categories.id +1
    college_id = categories.College.id
    if lastday < today:
        messages.info(request, "Window closed")
    context = {'categories':categories, 'college_id':college_id, 'lastday':lastday, 'today':today,'next_category':next_category}
    return render(request, 'nomination/contestants.html', context )

def Voting(request):
    if request.method == "POST": 
        vote_user = request.POST.get('vote_user')
        vote_contestant = request.POST.get('vote_contestant')
        vote_category = request.POST.get('vote_category')
        next_category = request.POST.get('next_cat')
        vote_college = request.POST.get('vote_college')
        college = College.objects.get(pk=int(vote_college))
        college_id = college.id
        nex = int(next_category)-1
        try:
            Vote.objects.filter(user_id=request.user.id, category_id=vote_category)[0]
            messages.error(request, "You've already voted")
            return HttpResponseRedirect(reverse('nomination:nominees', args=(vote_category,)))
        except(IndexError, Vote.DoesNotExist):
            if lastday < today:
                messages.error(request, "Too late")
                return HttpResponseRedirect(reverse('nomination:nominees', args=(vote_category,)))
            else:
                new_vote = Vote(contestant_id=vote_contestant, category_id=vote_category, college_id=vote_college, user_id=vote_user)
                new_vote.save()
                messages.success(request, "Successfully voted!!")
                try:
                    categories = college.category_set.filter(id=next_category, College_id=college_id)[nex]
                    category_id=categories.id
                    return HttpResponseRedirect(reverse('nomination:nominees', args=(category_id,)))
                except (IndexError, Category.DoesNotExist):
                    categories = college.category_set.first()
                    category_id = categories.id
                    return HttpResponseRedirect(reverse('nomination:categories', args=(college_id,)))

我也会很感激如果我能得到一个更好的方法来做这件事，比如也许使用下一个函数，我已经尝试，但它仍然给我的问题。你知道吗

Answer 1

为了防止有人还在想办法，我后来找到了另一种方法，我将queryset转换成一个列表，并使用index函数：

def Nominees(request, category_id):
    category = Category.objects.get(id=category_id)
    college_id = category.College.id
    college = College.objects.get(id=college_id)
    categories = list(college.category_set.all())
    next_category = (categories.index(category)) + 1
    if lastday < today:
        messages.info(request, "Window closed")
    context = {'categories':category, 'college_id':college_id, 'lastday':lastday, 'today':today,'next_category':next_category}
    return render(request, 'nomination/contestants.html', context )

def Next(request):
    next_category = request.POST.get('next_cat')
    college_id = request.POST.get('college_id')
    college = College.objects.get(id=int(college_id))
    nex = int(next_category)
    nxcate = list(college.category_set.all())
    if request.method =="POST":
        try:
            name = nxcate[nex]
            nxcat = college.category_set.filter(Name=name)[0]
            print(nxcat, nxcat.id)
            return HttpResponseRedirect(reverse('nomination:nominees', args=(name.id,)))
        except IndexError:
            name = nxcate[0]
            print('\n',name)
            messages.info(request,"Thank you for voting!!!")
            return HttpResponseRedirect(reverse('nomination:categories', args=(college_id,)))