使用and_和or_进行sqlalchemy动态过滤

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy import and_, or_
from your_model_module import YourModel

# 创建数据库引擎和会话
engine = create_engine('your_database_url')
Session = sessionmaker(bind=engine)
session = Session()

# 动态过滤条件
filter1 = YourModel.column1 == value1
filter2 = YourModel.column2 > value2
filter3 = YourModel.column3.like('%value3%')

# 使用and_连接多个过滤条件，要求它们同时满足
results1 = session.query(YourModel).filter(and_(filter1, filter2))

# 使用or_连接多个过滤条件，只要任意一个条件满足即可
results2 = session.query(YourModel).filter(or_(filter1, filter3))

# 执行查询并获取结果
print(results1.all())
print(results2.all())