下载到django搜索的结果CSV

Question

我正在尝试从搜索的结果下载CSV，作为一个选项。这意味着用户应该能够进行搜索并在模板中查看结果，然后根据需要下载该搜索结果的CSV。模板不是问题，而是我需要解决的观点。我有以下视图：

首先是搜索视图，

def binder_search(request):
    if request.method == "POST":
        searched = request.POST['searched']
        binders_searched = Binders.objects.filter(Q(description__contains=searched) | Q(step__name__contains=searched) | Q(status__name__contains=searched))

        return render(request, "binder_search.html", {'searched': searched, 'binders_searched': binders_searched})

    else:
        return render(request, "binder_search.html", {})

然后是CSV。此视图创建数据库中所有项目的列表。我要做的是从上面的视图中获得搜索结果，然后然后创建CSV文件。我最终会得到一个只有搜索结果的CSV文件。

def binders_csv(request):
    response = HttpResponse(content_type='text/csv')
    response['Content-Disposition'] = 'attachment; filename=binders_result.csv'

    # create a csv writer
    writer = csv.writer(response)

    # designate the model
    binders = Binders.objects.all()

    # add column at the heading of csv file
    writer.writerow(['Item Code', 'Description', 'Item Type', 'Current Step', 'Current Status', 'Last change by'])

    # loop thru and output
    for binder in binders:
        writer.writerow([binder.itemcode, binder.description, binder.itemtype, binder.step, binder.status, binder.user])

    return response

我环顾四周不同的解决方案，但实际上没有一个调试我。知道该怎么做吗？

Answer 1

我想念什么？你不能只结合两个吗？

def binder_search(request):
    if request.method != "POST":
        return render(request, "binder_search.html", {})

    # POST

    searched = request.POST['searched']
    binders_searched =   Binders.objects.filter(Q(description__contains=searched) | Q(step__name__contains=searched) | Q(status__name__contains=searched))

    # create a csv writer with header writing to response
    response = HttpResponse(content_type='text/csv')
    response['Content-Disposition'] = 'attachment; filename=binders_result.csv'
    writer = csv.writer(response)
    writer.writerow(['Item Code', 'Description', 'Item Type', 'Current Step', 'Current Status', 'Last change by'])

    # loop thru filtered results and output
    for binder in binders_searched:
        writer.writerow(
            [binder.itemcode, binder.description, binder.itemtype, binder.step, binder.status, binder.user]
        )
    return response

Answer 2

这是一个解决方案，可以在Nigel222和会话框架（请求。Session）的帮助下进行。该解决方案提供了将搜索结果显示到模板中所需的视图，然后按按钮或链接将确切的结果下载到CSV格式中。因此，用户可以获取搜索结果，然后如果他愿意下载结果。我一直在环顾四周，但找不到类似的解决方案，所以我在这里将其发布在这里。

第一个视图（binder_search）进行搜索和使用请求，以缓存变量“搜索”。

def binder_search(request):
    if request.method == "GET":
        searched = request.GET['searched']

        # Cache variable "searched" for views.binder_search_csv
        request.session['searched'] = searched

        # multiple columns
        binders_searched = Binders.objects.filter(Q(description__contains=searched) | Q(step__name__contains=searched) | Q(status__name__contains=searched))
        return render(request, "binder_search.html", {'searched': searched, 'binders_searched': binders_searched})
    
    else:
        return render(request, "binder_search.html", {})

第二视图使用从上面的视图“搜索”的缓存变量，然后将搜索结果下载到CSV文件。

def binder_search_csv(request):
    if request.method != "GET":
        return render(request, "binder_search.html", {})

    # Use cached variable from views.binder_search
    searched = request.session['searched']

    binders_searched = Binders.objects.filter(Q(description__contains=searched) | Q(step__name__contains=searched) | Q(status__name__contains=searched))

    # create a csv writer with header writing to response
    response = HttpResponse(content_type='text/csv')
    response['Content-Disposition'] = 'attachment; filename=binders_result.csv'
    writer = csv.writer(response)
    writer.writerow(['Item Code', 'Description', 'Item Type', 'Current Step', 'Current Status', 'Last change by'])

    # loop thru filtered results and output
    for binder in binders_searched:
        writer.writerow(
            [binder.itemcode, binder.description, binder.itemtype, binder.step, binder.status, binder.user]
        )
    return response

可能有一些方法可以简化这两种观点，但是正如现在一样，它们的工作完全很好。