sqlalchemy中获取模型属性 查询指定字段

sqlalchemy获取模型属性

Pop为模型类

import Pop
getattr(Pop,'uuid')
<sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x36e8410>
Pop.uuid
<sqlalchemy.orm.attributes.InstrumentedAttribute object at 0x36e8410>

查询指定字段

# 第一种种方法
field_list = ['uuid','name'...]
query = db_session.query()

for field in field_list:
    # add_column 加一列对应的查询字段
    query = query.add_column(getattr(Pop,field))
query[0].uuid

# 第二种方法
field_object_list = []
for field in field_list:
    field_object_list.append(getattr(Pop,field))
query = db_session.query(*field_object_list )