Python中Mysql数据导出为json数据

import json

from pymysql import Connection

conn = Connection(          #建立Mysql连接
    host='localhost',
    port=3306,
    user='root',
    password='000000',
    autocommit=True
)

f = open("D://pythontest.txt","a",encoding = "UTF-8")   #打开的txt文件

cursor = conn.cursor()
conn.select_db("py_sql")        #选择数据库

cursor.execute("SELECT * FROM orders")

#此处从数据库导出的数据有四列
results: tuple = cursor.fetchall()      #保留查询结果，元组

for r in results:

    dict_temp = {"date": r[0],"order_id":r[1],"money":r[2],"province":r[3]}     #转化为字典对象
    r = json.dumps(dict_temp,ensure_ascii=False)       #转化为json数据
    f.write(r+"\n")         #写入数据
    f.flush()

#关闭数据流，连接流
conn.close()
f.close()