def category(*, request, category_id):
# 获取当前分类的名字
category = yield from Category.findOne([category_id])
if category is not None:
# 获取博客分类和文章分类下的文章
category_sql = ['%s %s %s' % (
'select B.id,B.title,count(*) num from blog_category as A',
'left join category as B on A.category_id = B.id where B.is_delete = 0',
'group by A.category_id'
)]
blog_category = yield from select(category_sql, [])
# 获取热门文章
hot_blog_sql = ['select id,title,view_count from blogs order by view_count desc limit 10']
hot_blog = yield from select(hot_blog_sql, [])
return display('category', {'blog_category': blog_category, 'hot_blog': hot_blog, 'category': category})
else:
return redirect('/404')
def edit_article(*, request, category_id):
cate = yield from Category.findOne(category_id)
if cate is not None:
return display('edit_category', {'cate': cate})
else:
return redirect('/404')
