我如何显示数据库中的数据并将其导出为pdf -Django [英] How can i display my data in database and export it to pdf -Django

问题描述

我的x变量正在获取数据库中的所有数据，我猜呢？有人帮我如何显示所有数据并将其导出到pdf文件。

my x variable is getting all the data in my database, i guess? someone help me how can i display all data and export it to pdf file.

response = HttpResponse(content_type='application/pdf')
response['Content-Disposition'] = 'attachment; filename="WishList.pdf"'

buffer = BytesIO()

# Create the PDF object, using the BytesIO object as its "file."
p = canvas.Canvas(buffer)
x = Item.objects.all()

p.drawString(100, 100,x)

p.drawString(200,300,"sad")

# Close the PDF object cleanly.
p.showPage()
p.save()

# Get the value of the BytesIO buffer and write it to the response.
pdf = buffer.getvalue()
buffer.close()
response.write(pdf)
return response

推荐答案

您的变量x不会返回任何可以打印到PDF的内容，因为它是一个queryset而不是附加的几个字符串对彼此。我刚刚开始使用Django，并且获取值的工作方式如下：

Your variable x won't return anything you can print into the PDF, because its a queryset and not a couple strings attached to each other. I just started working with Django and getting the values works something like this:

x = Item.objects.all[0].name

此代码段会将Item表中第一个条目的行名称的值分配给变量x。

This code snippet will assign the vale of the row name of the first entry in your Item table to the variable x.

有关更多信息，我只能建议阅读在django网站上编写查询的教程。

For more Information I can only recommend reading the Tutorial about writing queries on the django website.

这篇关于我如何显示数据库中的数据并将其导出为pdf -Django的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！