python连接数据库读文件，sql语句读数据

import pymysql
import csv
sever = 'localhost'
user = 'root'
password = ''
database = 'acc'
conn = pymysql.connect(sever, user, password, database)
cursor = conn.cursor()

def dataload(filename):
    data = []
    with open(filename) as f:
        reader = csv.reader(f)
        #header_row = next(reader)
        for line in reader:
            data.append(line[0:])
    return data

filename = r'C:\Users\Linger\Desktop\dateACC3_3.csv'
data = dataload(filename)
for i in range(len(data)):
    data[i] = str(data[i]).replace(" ", "")[2:12]
data1 = []
for i in data:
    if i not in data1:
        data1.append(i)

data = list(data1)
#data = ['2015-12-18', '2015-12-19', '2015-12-20']
for i in range(58,len(data)):
    k = 0
    mmm = []
    temp = '\''+data[i]+"%"+'\''
    sql ='SELECT TRADE_ADDRESS, COUNT(*) FROM acc3_3 WHERE TRADE_DATE LIKE '+temp+' GROUP BY TRADE_ADDRESS'
    print(sql)
    cursor.execute(sql)
    row = cursor.fetchone()

    while row:
        temp1 = []
        #print(row[0], row[1])
        temp1.append(row[0])
        temp1.append(row[1])
        row = cursor.fetchone()
        k = k + 1
        mmm.append(temp1)

    #print(row)

    with open(r'C:\Users\Linger\Desktop\date123.txt', 'a+') as f:  # 设置文件对象
        for j in range(k):
            f.write(str(data[i])+' '+str(mmm[j][0])+' '+str(mmm[j][1])+'\n')
    print('第' + str(i + 1) + '条保存成功')