python - SQLAlchemy RowProxy 到字典

Question

如何将 sqlalchemy.engine.result.RowProxy 转换为字典？

row = db.engine.execute(sql, id=id).fetchone()

从 SO question尝试使用这个：

for c in inspect(obj).mapper.column_attrs:
    model_col = getattr(obj, c.key)
    model_dict[c.key] = model_col

错误：

sqlalchemy.exc.NoInspectionAvailable: No inspection system is available for object of type <class 'sqlalchemy.engine.result.RowProxy'>

标签： pythonsqlalchemy