从数据库中读数据

import pymysqlimport numpy as npdef connectViogidata(ebayno):    db = pymysql.connect(host='', user='', passwd='', db='viogidata', port=3306, charset='utf8')    cursor = db.cursor()    sql = ' select  id, ebayno, product_name, price, currency, when_time,shop_name from feedback where ebayno = %s'    cursor.execute(sql,(ebayno))    db.commit()    cursor.close()    db.close()    result = cursor.fetchall()    return resultdef connectLocal():    db = pymysql.connect(host='localhost', user='root', passwd='', db='test', port=3306, charset='utf8')    cursor = db.cursor()    sql = ' select ebayno from ebayno '    cursor.execute(sql)    db.commit()    cursor.close()    db.close()    result = cursor.fetchall()    return  resultif __name__ == '__main__':    file_object = open("feedback.txt","w")    file_object.write(" id, ebayno, product_name, price, currency, when_time,shop_name\n")    result = connectLocal()    result = list(result)    re = []    # id = "401289199654"    # idd="232265687646"    # feedback = connectViogidata(id)  #得到元组数据    # if feedback is not None:    #     for row in feedback: #去掉外层括号    #          file_object.write(str(row[0]) + "," + str(row[1]) + "," + str(row[2]) + "," + str(row[3]) + "," + str( row[4]) + "," + str(row[5]) + "," + str(row[6]) + "\n")    #    for i in result:        ebayno = i[0]        feedback = connectViogidata(ebayno) #得到元组数据        if feedback is not None:            for row in feedback:  # 去掉外层括号                file_object.write(str(row[0]) + "," + str(row[1]) + "," + str(row[2]) + "," + str(row[3]) + "," + str(                    row[4]) + "," + str(row[5]) +","+str(row[6]) + "\n")