Django将字典值加载到JSON中

Question

我试图从字典中获取值，并将它们加载到JSON中。我想我几乎用下面的代码实现了它，但是它只输出第一组值，我如何循环它以便它输出所有的值？你知道吗

def storeliqour_view(request, store_id):
    objectdicts = {}
    objects = StoreLiquor.objects.filter(storeID=store_id)
    for i in range(len(objects)):
        objectdicts = model_to_dict(objects[i])
        objectdicts["storename"] = objects[i].storeID.StoreName
    data = [objectdicts.values()] 

    #define response
    response = {
        'aaData': data,
        'iTotalRecords': iTotalRecords,
        'iTotalDisplayRecords': iTotalDisplayRecords,
        'sEcho': request.GET['sEcho']
    }

    #serialize to json
    s = BytesIO()
    json.dump(response, s, cls=MainEncoder)
    s.seek(0)
    return HttpResponse(s.read())

现在它输出这个。如你所见，只有一套： {"aaData": [[1, 0.0, 18, 96.6, 7032, false, 2610, "test store"]]}

如何让它输出多个，像这样？: {"aaData": [[1, 0.0, 18, 96.6, 7032, false, 2610, "test store"], [2, 0.0, 18, 96.6, 7032, true, 2610, "test store"]]}

Answer 1

您可以使用：

data = [
    model_to_dict(object).values() + [object.storeID.StoreName]
    for object in objects
]

如果字典以相同的顺序返回值，这将起作用。因此，更安全的做法是：

data = []
if objects:
    keys = model_to_dict(objects[0]).keys()
    for object in objects:
        d = model_to_dict(object)
        data.append([d[key] for key in keys] + [object.storeID.StoreName])

Answer 2

def storeliqour_view(request, store_id):
    objectdicts = {}
    objects = StoreLiquor.objects.filter(storeID=store_id)
    data = list()
    for i in range(len(objects)):
        objectdicts = model_to_dict(objects[i])
        objectdicts["storename"] = objects[i].storeID.StoreName
        data.append([objectdicts.values()]) 
    # rest of the code here...