如何在html Django页面中显示sqlite查询的结果

Question

我在我的views.py中设置了以下查询：

with connection.cursor() as cursor:
    #cursor.execute("SELECT  AgentName FROM 'CSQ Agent Report' ")
    cursor.execute("SELECT  'AgentName', count (*) FROM 'CSQ Agent Report' WHERE  'AgentName' != 'None'  AND 'OriginatorDNHANDELED' = '1' or 'OriginatorDNNOTHANDELED' = '1' Group by 'AgentName'")
    obj = cursor.fetchall()
context = {
    'object': obj
            }



return render(request,"CSQ/detail.html", context)

我想在我的html页面中显示查询结果：

{% extends 'base.html' %}
{% block content %}
<h1> Stats Call Center Of Feb </h1>
<p> Nb of calls received by agent </p>
<ul>
{% for var in object %}
    <li> {{var}} </li>
{% endfor %}


</ul>

{% endblock %}

我在python中创建了相同的查询，它按预期工作：

cursor.execute(""" SELECT  "AgentName", count (*) FROM "CSQ Agent Report" WHERE  "AgentName" != "None"  AND "OriginatorDNHANDELED" = '1' or "OriginatorDNNOTHANDELED" = '1' Group by "AgentName"  """)

liste8= cursor.fetchall()

for i in range (len(liste8)):
    
    print (liste8[i][0],liste8[i][1])

python中的结果如下所示：

Agent1 11
Agent2 41
Agent3 249
Agent4 46
Agent5 2
Agent6 216
Agent7 117
Agent8 242
Agent9 50

我希望在我的Html Django页面中按照python显示相同的结果

谢谢

Answer 1

看起来查询正在返回嵌套数组。您可以使用以下代码获得与python控制台类似的输出。（外观可能不同，您必须应用CSS，但模式应该相同。）

`{% extends 'base.html' %}
 {% block content %}
 <h1> Stats Call Center Of Feb </h1>
 <p> Nb of calls received by agent </p>
 <ul>
 {% for var in object %}
    {% for i in var%}
          <li> {{i.AgentName}} &nbsp {{i.OriginatorDNHANDELED (use the names you use in the 
            Model)}} </li>
    {% endfor %}
 {% endfor %}
   </ul>
 {% endblock %}`