Py02·数据导出到csv文件

数据库环境配置

setConfig.py

# 本地数据库 
L_host = "127.0.0.1" 
L_user = "root" 
L_password = "123456" 
L_database = "yy" 
L_port = 3306

数据导出

mysqltocsv.py

import pymysql
import csv
import codecs
import zipfile
import setConfig as datasource 
# 数据连接
def Local_get_conn():
    db = pymysql.connect(host=datasource.L_host, port=datasource.L_port, user=datasource.L_user, passwd=datasource.L_password, db=datasource.L_database, charset='utf8')
    return db
# 执行sql的形式-全部打印
def Local_execute_all(cursor,sql,args):
    cursor.execute(sql,args)
    return cursor.fetchall()

db=Local_get_conn()
cursor=db.cursor() 
def red_mysql_to_csv(filename):
    with codecs.open(filename=filename,mode='w',encoding='utf-8')as f:
        write = csv.writer(f,dialect='excel')
        write.writerow(['序列','订单编号','收件人','收件人电话','收件人地址','快递公司','快递单号','商品信息','订单状态','入库exce名','时间'])
        try:
            sql = r""" 
                SELECT * FROM shop_customer1 limit 10 
                """
            results = Local_execute_all(cursor=cursor,sql=sql,args=None)
            db.close() 
            cursor.close()
            for res in results:
                print(res)           # 打印查询数据
                write.writerow(res)  # 数据写入文件
            print("导出完成")
                
        except db.Error as e:
            print("執行失敗")
            print(e)
            db.close()
            cursor.close()
            return ;

if __name__ == '__main__':
    csvFile = r"shop_customer1.csv"
    red_mysql_to_csv(csvFile)
    print ("執行完成");