1.sqlalchemy如何用List传递参数
2.sqlalchemy如何添加“OR”条件
from sqlalchemy import or_
params = list()
params.append(ModuleInfo.M_date <= YMD)
params.append(ModuleInfo.M_id == str(MID))
c = [ModuleInfo.status == 0, ModuleInfo.status == 1, ModuleInfo.status == 2]
queryone = session.query(ModuleInfo).filter(*params).filter(or_(*c))