peewee中的动态字段查询

from peewee import *

# 定义数据库模型
db = SqliteDatabase('my_database.db')

class User(Model):
    name = CharField()
    age = IntegerField()
    email = CharField()

    class Meta:
        database = db

# 连接数据库
db.connect()

# 创建表格
db.create_tables([User])

# 动态字段查询示例
def dynamic_field_query(field_name, field_value):
    query = User.select().where(getattr(User, field_name) == field_value)
    return query

# 根据姓名查询用户
name_query = dynamic_field_query('name', 'John')
for user in name_query:
    print(user.name, user.age, user.email)

# 根据年龄查询用户
age_query = dynamic_field_query('age', 25)
for user in age_query:
    print(user.name, user.age, user.email)

# 关闭数据库连接
db.close()