sqlalchemy.ext.declarative.api.DeclarativeMeta转dict

原文链接: sqlalchemy.ext.declarative.api.DeclarativeMeta转dict

def to_dict(alchemy_table):    return {c.name: getattr(alchemy_table, c.name, None) for c in alchemy_table.__table__.columns}

使用

print(to_dict(table))

table为query返回值(DeclarativeMeta类型)