How can I generate a PDF file directly from byte data in Python without having to write it to a binary file first?

Question

How can I generate a PDF file directly from byte data in Python without having to write it to a binary file first?

This Python code retrieves data from a database table and converts it into a PDF file without saving it to disk, then displays it in the browser.

l_statement = "select srno,attachment from dbo.attachments where srno = 1"
sqlcursor.execute(l_statement)
for row in sqlcursor.fetchall():
```
   print(type(row[1]))
```
```
   print(row[1])
```
```
   '''f='output.pdf'
```
```
   with open(f,'wb') as outfile:
```
```
        outfile.write(row[1])'''
```
webbrowser.open_new(pdf)

Data Type of Output:

<class 'bytes'> b"%PDF-1.3\n1 0 obj\n<<\n/Count 1\n/Kids [3 0 R]\n/MediaBox [0 0 595.28 841.89]\n/Type /Pages\n>>\nendobj\n2 0 obj\n<<\n/OpenAction [3 0 R /FitH null]\n/PageLayout /OneColumn\n/Pages 1 0 R\n/Type /Catalog\n>>\nendobj\n3 0 obj\n<<\n/Contents 4 0 R\n/Parent 1 0 R\n/Resources 6 0 R\n/Type /Page\n>>\nendobj\n4 0 obj\n<<\n/Filter /FlateDecode\n/Length 74\n>>\nstream\nx\x9c3R\xf0\xe22\xd035W(\xe7r\nQ\xd0w3T04\xd330P\x08ISp\r\x01\t\x19\x1b\xea\x19Z(\x98\x9b\x99\xe9\x19\x19)\x84\xa4(hx\xa4\xe6\xe4\xe4+\x84\xe7\x17\xe5\xa4(j*\x84d\x81\xd4\x01\x00\x16#\x10M\nendstream\nendobj\n5 0 obj\n<<\n/BaseFont /Helvetica-Bold\n/Encoding /WinAnsiEncoding\n/Subtype /Type1\n/Type /Font\n>>\nendobj\n6 0 obj\n<<\n/Font <</F1 5 0 R>>\n/ProcSet [/PDF /Text /ImageB /ImageC /ImageI]\n>>\nendobj\n7 0 obj\n<<\n/CreationDate (D:20230929150353Z15'03')\n>>\nendobj\nxref\n0 8\n0000000000 65535 f \n0000000009 00000 n \n0000000096 00000 n \n0000000199 00000 n \n0000000279 00000 n \n0000000424 00000 n \n0000000526 00000 n \n0000000613 00000 n \ntrailer\n<<\n/Size 8\n/Root 2 0 R\n/Info 7 0 R\n/ID [<4527CC16A77C85F8369BA38DDA715212><4527CC16A77C85F8369BA38DDA715212>]\n>>\nstartxref\n674\n%%EOF\n"

python pdf

Answer 1

Answer №1

l_query = "select ID, file from dbo.documents where ID = 1" print(l_query) database_cursor.execute(l_query)
for data_row in database_cursor.fetchall(): download_headers = {'Content-Disposition': 'attachment; filename="out.pdf"'} return Response(data_row[1], headers=download_headers, media_type='application/pdf')

Answer 2

l_query = "select ID, file from dbo.documents where ID = 1" print(l_query) database_cursor.execute(l_query)
for data_row in database_cursor.fetchall(): download_headers = {'Content-Disposition': 'attachment; filename="out.pdf"'} return Response(data_row[1], headers=download_headers, media_type='application/pdf')

How can I generate a PDF file directly from byte data in Python without having to write it to a binary file first?

Answer №1

Similar questions

An error has occurred as the Chrome binary could not be located. Please raise the exception class with the message, screen, and stack trace to resolve this issue

Divide the strings using punctuation marks, but leave the tags intact

The issue with Python Selenium driver.get() function not functioning properly when used within a for loop

I am encountering difficulty using Selenium to interact with the dropdown link on my UI

What could be the reason for scrapy not returning any URLs?

Python (Selenium) - Guide on extracting and storing data from multiple pages into a single CSV file

Using regular expressions in Python to compare C++ strings and string literals

An error is thrown when Django tries to pass a variable to Httpresponseredirect

How to extract text from HTML body using Python with Selenium without the tags?

Python's ability to nest objects within other objects allows for complex data

The response from $http.get is not defined

Opening a Webpage with Logged-in Status Using Python and Selenium

What are some types of webpage elements that change and move?

Create a Jacobian matrix using Python without relying on existing libraries

Using Python to Determine MariaDB Connection Status

Is it recommended to utilize either a single or multiple instances of Python's secrets.SystemRandom() class?

Using a "while" loop, eliminate items from one list that are present in another list

What are the steps to start running the while loop?

The Django annotate function does not support accessing a floatfield within a model

ìdentifying Incomplete JSON Data using Python