无法从Django发送HttpACK

Question

我正在尝试发送添加了标题的JSON格式。csv格式到前端进行下载。在发送HTTP响应时，我遇到了一个“不是JSON可序列化的”错误。

我的 views.py 文件：

from datetime import datetime
from django.shortcuts import render
from django.http import HttpResponse
import json as simplejson
import random
import csv

def DownloadEventLog(request):
    downloadeventlog = "[{\"severity\":\"0\",\"description\":\"USB Connected\",\"date\":\"01/01/2015\",\"time\":\"11:35:20\"},{\"severity\":\"3\",\"description\":\"USB Disconnected\",\"date\":\"01/01/2015\",\"time\":\"10:30:19\"}]";

    data = simplejson.loads(downloadeventlog)
    response = HttpResponse(content_type='text/csv')
    response['Content-Disposition'] = 'attachment; filename="eventlog.csv"'

    writer = csv.writer(response)
    writer.writerow(data[0].keys())
    for row in data:
        writer.writerow(row.values())
    print response
    return HttpResponse(simplejson.dumps(response), content_type = "application/json")

打印响应cmd正在打印:

Content-Type: text/csv
Content-Disposition: attachment; filename="eventlog.csv"

date,time,severity,description
01/01/2015,11:35:20,0,"USB Connected"
02/02/2015,10:30:19,3,"USB Disconnected"

但是，最后一行会抛出如下错误:

TypeError at /eventlog/downloadeventlog
<django.http.response.HttpResponse object at 0x9c059ec>is not JSON serializable

Request Method: POST
Request URL: http://127.0.0.1:8001/eventlog/downloadeventlog
Django Version: 1.7.1
Python Version: 2.7.3

Answer 1

你应该在这里使用django的序列化程序：
https://docs.djangoproject.com/en/dev/topics/serialization/

相关问题在这里：

Answer 2

您可以只返回< code>response，而不需要将其包装在< code>HttpResponse中。

return response

Answer 3

simplejson和json不能很好地处理django对象。

Django的内置序列化器只能序列化填充有django对象的查询集：

**** To use ****

data = serializers.serialize('json', self.get_queryset())
return HttpResponse(data, mimetype="application/json")

希望这有帮助