import MySQLdb as mdb
def write_image_to_db():
"""
向数据库写入图片
:return:
"""
try:
fin = open("mon.png")
img = fin.read()
fin.close()
except IOError as e:
print ("Error %d: %s" % (e.args[0], e.args[1]))
sys.exit(1)
try:
conn = mdb.connect(host='xxxx', user='xxxx',
passwd='xxxx', db='xxxx')
cursor = conn.cursor()
cursor.execute("INSERT INTO Images SET Data='%s'" % \
mdb.escape_string(img))
conn.commit()
cursor.close()
conn.close()
except mdb.Error as e:
print ("Error %d: %s" % (e.args[0], e.args[1]))
sys.exit(1)
def read_image_from_db():
"""
从数据库读取图片
:return:
"""
try:
conn = mdb.connect(host='xxxx', user='xxxx',
passwd='xxxx', db='xxxx')
cursor = conn.cursor()
cursor.execute("SELECT Data FROM Images LIMIT 1")
fout = open('image.png', 'wb')
fout.write(cursor.fetchone()[0])
fout.close()
cursor.close()
conn.close()
except IOError as e:
print ("Error %d: %s" % (e.args[0], e.args[1]))
sys.exit(1)