TypeError：对象在DJango 1.8 Python 3.4中不可序列化JSON

Question

我使用的是 DJango 1.8 和蟒蛇 3.4

当运行下面的视图时，Django抛出类型错误-对象不可JSON序列化

Views.py

from django.http import HttpRequest,HttpResponse
from django.http import JsonResponse
from json import dumps

def get_stats(request):
    if request.method == "POST":
        srch_dropV = request.POST['srch_dropAJ']
    else:
        srch_dropV = ''
    if(srch_dropV == 'Green'):
        students = GreenBased.objects.all()
    if(srch_dropV == 'Yellow'):
        students = YellowBased.objects.all()
    response_data = {}
    try:
        response_data['result'] = 'Success'
        response_data['message'] = list(students)
    except:
        response_data['result'] = 'Ouch!'
        response_data['message'] = 'Script has not ran correctly'
    return HttpResponse(JsonResponse(response_data), content_type="application/json")

我试图从mysql数据库中读取几行数据并显示在html文件中，当上面的视图运行时，我看到下面的错误信息

TypeError: YellowBased: YelloBased object is not JSON serializable

在HTML页面中，我有一个下拉列表。根据选择的选项，我的Ajax将返回从mysql表获取的记录。

Models.py

class GreenBased(models.Model):
    NumOfStudents = models.CharField(max_length=300,blank=True)
    Green = models.CharField(max_length=300,blank=True)
    class Meta:
        managed = False
        db_table = "GreenStats"

class YelloBased(models.Model):
    NumOfStudents = models.CharField(max_length=300,blank=True)
    Yellow = models.CharField(max_length=300,blank=True)
    class Meta:
        managed = False
        db_table = "YellowStats"

GreenStats和YellowStats表在mysql中只包含2*2行可以有人帮我识别这个问题吗？

Answer 1

您必须序列化您的< code>student对象列表，尝试如下方式:

from django.http import HttpRequest,HttpResponse
from django.http import JsonResponse
from json import dumps
from django.core import serializers


def get_stats(request):
    if request.method == "POST":
        srch_dropV = request.POST['srch_dropAJ']
    else:
        srch_dropV = ''
    if(srch_dropV == 'Green'):
        students = GreenBased.objects.all()
    if(srch_dropV == 'Yellow'):
        students = YellowBased.objects.all()
    response_data = {}
    try:
        response_data['result'] = 'Success'
        response_data['message'] = serializers.serialize('json', students)
    except:
        response_data['result'] = 'Ouch!'
        response_data['message'] = 'Script has not ran correctly'
    return JsonResponse(response_data)

请注意以下行中的更改：
response_data[“消息”] = 序列化程序。

此外，JsonACK自己完成了这项工作，因此无需将其包装在HttpRepose中。

查看文档以获取更多自定义：https://docs.djangoproject.com/en/1.8/topics/serialization/

希望这有帮助！