从BLOB mysql python写入文件 [英] Write file from BLOB mysql python
问题描述
现在我有以下代码：
I'm trying to get a file from a database and write it to disk. The file is stored as BLOB.
Now I have the following code:任何帮助将不胜感激。感谢：）
我调试了它，并将其写入磁盘，但是当我打开它显示错误说：
#!/usr/bin/python
import MySQLdb
db2 = MySQLdb.connect(host="localhost",
user="root",
passwd="root",
db="digit")
cur = db2.cursor()
#get the name of the file
cur.execute("SELECT Name FROM ContentFiles WHERE ID=3")
nombre = cur.fetchone()
#open file and write into.
with open(nombre[0],"wb") as output_file:
cur.execute("SELECT File FROM ContentFiles WHERE ID=3")
ablob = cur.fetchone()
output_file.write(ablob[0])
Any help would be appreciated. Thanks :)
$ b
Not a JPEG file: starts with 0x2f 0x39
推荐答案
b
cur = db2.cursor()
#get the file
cur.execute("SELECT mimetype,File,Name FROM ContentFiles WHERE ContentID=10414")
archivo = cur.fetchone()
imagen = open(archivo[2],'wb')
imagen.write(archivo[1].decode('base64'))
imagen.close()
这篇关于从BLOB mysql python写入文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
