mysql数据库读写图片

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)