import mysql.connector

def main():
    conn = mysql.connector.connect(user='root',
                                   password='',
                                   host='127.0.0.1',
                                   database='isubata')

    cur = conn.cursor()
    sql = "select name,data from image"
    cur.execute(sql)
    row = cur.fetchall()

    fname = row[0::2]
    fdata = row[1::2]
    num_of_file = len(fdata)

    for i in range(num_of_file):
        f = open(fname[i], 'wb')
        f.write(fdata[i])
        f.close()


if __name__ == '__main__':
    main()