import pymysql
def get_db():
# 打开数据库连接
db = pymysql.connect(
host="**.**.**.**", port=3306, user="root", passwd="1234567", db="my_db"
)
return db
def get_sql_conn():
"""
获取数据库连接
"""
db = get_db()
cursor = db.cursor()
return db,cursor
def get_index_dict(cursor):
"""
获取数据库对应表中的字段名
"""
index_dict=dict()
index=0
for desc in cursor.description:
index_dict[desc[0]]=index
index=index+1
return index_dict
def get_dict_data_sql(cursor,sql):
"""
运行sql语句,获取结果,并根据表中字段名,转化成dict格式(默认是tuple格式)
"""
cursor.execute(sql)
data=cursor.fetchall()
index_dict=get_index_dict(cursor)
res=[]
for datai in data:
resi=dict()
for indexi in index_dict:
resi[indexi]=datai[index_dict[indexi]]
res.append(resi)
return res
def main():
db,cursor = get_sql_conn()
sql = "SELECT * FROM `My_table` WHERE `in_using`='1' limit 10;"
res_dict = get_dict_data_sql(cursor, sql)
return res_dict
pymysql 查询结果转字典dict
最新推荐文章于 2024-04-27 21:13:36 发布