#!/usr/bin/python3
# -*- coding: utf-8 -*-
# import pymysql
import mysql.connector
import json
db = mysql.connector.connect(host='222.73.129.15',
                             user='root',
                             passwd='kepaiteng!QAZ',
                             db='eq',
                             port=31306)

# tname="buydetail"
tname=input("请输入表名：")
cursor = db.cursor(dictionary=True)
err =cursor.execute("select * from %s limit 1"%(tname))
result =cursor.fetchall()
print(f"json: {json.dumps(result, indent=4, sort_keys=True, default=str)}")
# write_file = open("%s.json"%(tname), "w", encoding="utf-8").write(sqlstr)
print(err)
db.close()