从数据库中读数据

import pymysql
import numpy as np

def 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 result


def 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  result

if __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")