def get_by_id(id):
dao = BaseDao()
sql = 'select * from v_foods_cate where id=%s'
data = dao.query(sql, id)
# 将当前查看的foods_id加入人气排行中
redis_.add_popu_rank_foods(id)
return jsonify(data)
def top_rank_foods():
rank_list = redis_.top_popu_rank_foods(5) # 前5个人气排行
dao = BaseDao()
sql = 'select * from v_foods_cate where id=%s'
results = {
score: dao.query(sql, foods_id)[0]
for foods_id, score in rank_list
}
return jsonify(results)
def query_category():
dao = BaseDao()
sql = """
select * from v_foods_cate
order by cate_name
limit %s, 10
"""
page_num = request.args.get('page')
page_num = int(page_num) if page_num else 1
data = dao.query(sql, (page_num - 1) * 10)
total = dao.total('t_foods')
return jsonify({
'data': data,
'total_rows': total,
'total_page': total // 10 + 1 if (total % 10) > 0 else 0
})