Flask SQLalchemy result 查询结果如何转换成dict

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()]