jquery - 从两个表中获取数据Python

嗨，我需要从两个表中的其他外键中的第一个ID提取数据

这是我的代码

def allplayers(request):
    cursor = connection.cursor()
    player_list = myplayer.objects.all()
    get_player_vital=[]
    for i in player_list:
        get_player_vital = [vitals.objects.filter(playerID =i.id )]

    paginator = Paginator(player_list, 25) # Show 25 contacts per page

    page = request.GET.get('page')
    try:
        contacts = paginator.page(page)
    except PageNotAnInteger:
        # If page is not an integer, deliver first page.
        contacts = paginator.page(1)
    except EmptyPage:
        # If page is out of range (e.g. 9999), deliver last page of results.
        contacts = paginator.page(paginator.num_pages)

    return render_to_response('allplayers.html', {"contacts": contacts,'get_player_vital':get_player_vital})

当我在模板中打印get_player_vital时，它仅返回最后一条记录

最佳答案

我猜你需要做这样的事情：

def allplayers(request):
    player_list = myplayer.objects.all()
    get_player_vital = [vitals.objects.filter(playerID__in=player_list.values_list('id', flat=True))]
   ...
   return render_to_response('allplayers.html', {"contacts": contacts,'get_player_vital':get_player_vital})

因为您在每个迭代循环中都创建了新的list对象，所以该对象只包含一个对象。

关于jquery - 从两个表中获取数据Python，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/18266891/