Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
612 views
in Technique[技术] by (71.8m points)

Error "Object of type QuerySet is not JSON serializable" when using request.session in django

I have a trouble when using request.session in search function django It shows error "Object of type QuerySet is not JSON serializable".

def list_contract_test(request):
    context = {}
    if request.method == 'GET':
        query1= request.GET.get('search1')
        query2= request.GET.get('search2')
        submitbutton= request.GET.get('submit')
        if query1 or query2 is not None:
            lookups_contract= Q(contract__icontains=query1)
            lookups_name = (Q(name__icontains=query2.upper())|Q(name__icontains=query2.lower()))
            contract_posts= Contracts.objects.filter(lookups_contract,lookups_name).distinct()
            context['contract_posts'] = contract_posts
            #request.session['contract_posts'] = contract_posts
            return render(request, "customer2.html", context)
        else:
        contract_posts = serializers.serialize('json', Contracts.objects.all())
        contract_posts = json.loads(contract_posts)
        request.session['contract_posts'] = contract_posts
        context['contract_posts'] = contract_posts
        return render(request, 'customer2.html', context)
    else:
        return render(request, 'customer2.html')

In html file

{% for contract in contract_posts %}
                    <tr>
                      <td>{{ contract.contract}}</a></td>
                      <td>{{ contract.name }}</td>
                      <td>{{ contract.debt }}</td>
                      <td>{{ contract.created_at}}
                    </tr>
                  {% endfor %}

Please help me!

question from:https://stackoverflow.com/questions/65949082/error-object-of-type-queryset-is-not-json-serializable-when-using-request-sess

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...