从django项目中的数据库数据创建csv

import csv
from django.http import HttpResponse
from myapp.models import MyModel

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

    data = MyModel.objects.all()

    writer = csv.writer(response)
    writer.writerow(['Field 1', 'Field 2', 'Field 3'])  # 写入CSV文件的标题行

    for item in data:
        writer.writerow([item.field1, item.field2, item.field3])  # 写入每一行的数据

    return response