小白求助， flask_sqlalchemy 条件查询的一个问题

```python
filters = []
if xxx is not None:
filters.append(Model.attr == xxx)
.query.filter(*filters).xxxx
```

通过 if 判断一下字段，不就可以随便拼接 sql 语句了么

```
if not xxx:
data = Xxx.query.all()
```

你都用 SQLAlchemy 了~~
'''
if cond is None:
objs = Xxx.query.all()
'''

```
filters = [OrderModel.date == date] if isinstance(date, str) else [OrderModel.date.in_(date)]
filters += [OrderModel.type.in_(type)] if type else []
filters += [OrderModel.successed == successed] if successed else []
order_list = OrderModel.query.filter(*filters).all()
order_name = [f.name for f in order_list]
return list(set(order_name))


```