37,721
社区成员
发帖
与我相关
我的任务
分享
mydict={}
# 这里先从数据库获取数据
mydict[d]={'hostname': hostname, 'cpu_count': cpu_count, 'mem_capicity': mem_capicity}
import pymysql.cursors
# Connect to the database
connection = pymysql.connect(host='127.0.0.1',
port=3306,
user='root',
password='password',
db='tempdb',
charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor)
col_names = ['hostname', 'cpu_count', 'mem_capacity'']
data = {}
for row in rows:
data[row[0]] = dict(zip(col_names, row[1:]))