join 连表查询时如何转化成dict
# 思路:获取结果对应的列名 使用列表生成式生成对应格式的数据类型
results = session.query(user).join(user_role,user_role.user_id==user.id).all()
result_dict = [dict(zip(result.keys(), result)) for result in results]
results = session.query(user).join(user_role).all()
for result in results:
print(result.keys())
print(result)
执行原生SQL结果转化成dict
result = db.session.execute("select field1,field2 from table")
cursor = result.cursor
result_dict = [dict(zip([field[0].lower() for field in cursor.description], d)) for d in cursor.fetchall()]