找遍全网最终在
这个回答中找到答案,也许不是最优的,但是解决了我的问题
from sqlalchemy import text
db = db_session()
sql = '''SELECT a.id,b.b1 as b1,a.a1,a.a2,a.a3,
a.a4,a.a5,a.a6,a.a7,a.a8
FROM a
INNER JOIN b ON a.aa=b.aa
WHERE 1=1
'''
if len(params) != 0: #传递过来的数组
for key, val in params.items():
if val:
t = """ and {} like '%{}%' """ #模糊搜索
sql += t
sql = sql.format(key, val)
else:
sql = sql
l = """ limit {},{} """
sql += l
sql = text(sql.format(format(page - 1) * limit, limit))
res = db.execute(sql)