python - peewee 中的动态字段查询

Question

我已经定义了模式，并且能够通过选择查询获取结果:

country = 'usa'
User.select(User.email, User.username).where(User.country==country)

我想过滤这个动态字段名称，例如:

field = 'country'
country = 'usa'
User.select(User.email, User.username).where(User[field]==country)

可以这样做吗？

Answer 1

尝试 attrgetter:

from operator import attrgetter


field = 'country'
country = 'usa'
User.select(User.email, User.username).where(attrgetter(field)(User)==country)