def get(self, page=1):
dreams = BlogDream.select().paginate(int(page), int(pageConf['DREAM_NUM']))
nav = {
'model': 'index',
'num': BlogDream.select().count(),
}
sides = self.get_side()
self.render('index/index.html', title="首页", dreams=dreams, side=sides, nav=nav)
def get(self, tag, page=1):
p = BlogDream.select(BlogDream).join(BlogDreamTag).join(BlogTag).where(BlogTag.tag == tag).\
paginate(int(page), pageConf['DREAM_NUM'])
nav = {
'model': 'tag/' + tag,
'num': BlogDream.select(BlogDream).join(BlogDreamTag).join(BlogTag).where(BlogTag.tag == tag).count(),
}
self.render("tag/index.html", dreams=p, title=tag, side=self.get_side(), nav=nav)
def get_side(self):
side = {
"recent_dream": BlogDream.select().limit(pageConf["RECENT_DREAM_NUM"]),
# "recent_dream":[{"id":"3","title":"liwq"},{"id":"5","title":"vince"}],
# "tags":BlogTag.select().limit(pageConf["TAG_NUM"])
# "tags":[{"tag":"python","count":3},{"tag":"tornado","count":5}]
"tags": BlogTag.select(BlogTag, fn.Count(BlogDream.id).alias('count')).join(BlogDreamTag).join(BlogDream).group_by(BlogTag)
}
return side
