#数据库操作#
#将原生查询的resultporxy转换为dict
serverInfoResults=db_session.execute("select * from t_deviceInfo");
serverInfoResultRow
d,result = {},[]
for serverInfoResultRow in serverInfoResults:
for column, value in serverInfoResultRow.items():
d = {**d, **{column: value}};
result.append(d);