dynamic field query in peewee

Question

I have modal defined and able to get result with select query:

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

I want to filter this dynamic field name, like:

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

Is it possible to do that?

Answer 1

Try attrgetter:

from operator import attrgetter


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