flask 常用总结

site_total_sucess = db.session.execute(sql_sucess).fetchone()

#直接添加数据
new_web = NewsSpiderWebInfo(**web_info)
db.session.add(new_web)
db.session.flush()
new_id = new_web.id
db.session.commit()

filtes = []
webcode = webcode.strip()
like_webcode = '%{}%'.format(webcode)
filtes.append(or_(NewsSpiderWebInfo.webname.like(like_webcode),
                  NewsSpiderWebInfo.webcode.like(like_webcode),))
# filtes.append(NewsSpiderWebInfo.webcode == webcode)
items = NewsSpiderWebInfo.query.filter(*filtes).all()[::-1][star:end]