我需要基于queryset结果生成csv文件,将结果文件作为附件附加到电子邮件并发送。如您所见,我需要遍历指定的_lead并将其写入一个文件,因此我认为yield可以做到这一点。现在,当我运行代码时,我会收到带有下面消息的附件的电子邮件,而不是我期望的行。如果使用return,则从queryset结果中获取一行。
<generator object data at 0x7f5e508d93c0>
def send_lead_reminder(request):
usercompany = Listing.objects.filter(submitted_by=request.user)
assigned_leads = lead.objects.filter(assigned_to__in=usercompany).distinct()
def data():
csvfile=StringIO.StringIO()
csvwriter =csv.writer(csvfile)
for leads in assigned_leads:
csvwriter.writerow([leads.business_name, leads.first_name, leads.last_name, leads.email, leads.phone_number,leads.address, leads.city, leads.state, leads.zipcode, leads.submission_date, leads.time_frame, leads.comments])
yield csvfile.getvalue()
message = EmailMessage("Hello","Your Leads","myemail@gmail.com",["myemail@gmail.com"])
message.attach('invoice.csv', data(), 'text/csv')
#message.to="myemail@gmail.com"
message.send()
return HttpResponseRedirect('/')
Python 3和
DictWriter
示例:你使用附加功能有什么特别的原因吗?只需在内存中构建csv—如果你将它附加到电子邮件中,就无法避免—然后发送它。
相关问题 更多 >
编程相关推荐