我有一個名為 Lead 的模型，我正在嘗試從我的資料庫中匯出單個潛在客戶。目前我只能匯出所有潛在客戶。
模型.py
class Lead(models.Model):
transfer_date=models.DateField(blank=True, null=True)
callback_date = models.DateField(blank=True, null=True)
contact_date = models.DateField(blank=True, null=True)
first_name = models.CharField(max_length=20)
last_name = models.CharField(max_length=20)
address = models.CharField(default=0, max_length=50)
city = models.CharField(max_length=30, default="")
state = models.CharField(max_length=20, default="")
zipcode = models.IntegerField(default=0)
phone = models.CharField(max_length=10, null=True, default="", blank=True)
cell = models.CharField(max_length=10, null=True, default="", blank=True)
email = models.EmailField(default="")
def __str__(self):
return f"{self.first_name} {self.last_name}"
視圖.py
def export(request):
response = HttpResponse(content_type='text/csv')
writer = csv.writer(response)
writer.writerow(['First Name', 'Last Name', 'Email'])
for lead in Lead.objects.all().values_list('first_name', 'last_name', 'email'):
writer.writerow(lead)
response['Content-Disposition'] = 'attachment; filename="Lead.csv"'
return response
uj5u.com熱心網友回復：
讓我們為此假設一個單獨的視圖：
def export_single_lead(request):
response = HttpResponse(content_type='text/csv')
writer = csv.writer(response)
writer.writerow(['First Name', 'Last Name', 'Email'])
lead = Lead.objects.last() # Or get the lead you want some other way
writer.writerow((lead.first_name, lead.last_name, lead.email))
response['Content-Disposition'] = 'attachment; filename="Lead.csv"'
return response
uj5u.com熱心網友回復：
def export(request, pk):
response = HttpResponse(content_type='text/csv')
writer = csv.writer(response)
writer.writerow(['First Name', 'Last Name', 'Email'])
lead = Lead.objects.get(id=pk)
writer.writerow((lead.first_name, lead.last_name, lead.email))
response['Content-Disposition'] = 'attachment; filename="Lead.csv"'
return response
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/323876.html
標籤：姜戈 django-models django-views
上一篇：DjangoQueryDict如何確保“加號”不會在QueryDict中消失？
下一篇：Python/Django請求JSONDecodeError:Expectingvalue:line1column1(char0)