def get(self): sql = "SELECT COUNT(*) FROM blog_list WHERE blog_status = 2" total = get_total(sql) count = page_count if total < page_count: count = total sql = "SELECT blog_id, auther_id, blog_info, create_time FROM blog_list WHERE blog_status = 2 ORDER BY create_time DESC LIMIT 0," + str(count) blog_list = mysql_util.select(sql) self.render('index.html', blog_list=blog_list, current_page=1, total_page=get_page("SELECT COUNT(*) FROM blog_list WHERE blog_status = 2"), login=self.is_login())
def get(self): if not self.get_current_user(): self.write('请先登录') return blog = self.get_argument('blog') sql = "SELECT blog_info,blog_status FROM blog_list WHERE blog_id = '" + blog + "'" blog_list = mysql_util.select(sql) txt = '' for each in blog_list: txt = each self.render('blog_update.html', blog=blog, txt=txt[0], blog_status=txt[1], login=self.is_login())
def recommend(): results = [] try: results.extend( mysql_util.select(constant.DB_NAME, constant.RECOMMEND_SQL_1)) results.extend( mysql_util.select(constant.DB_NAME, constant.RECOMMEND_SQL_2)) except Exception as e: logging.error(e) return if len(results) == 0: content = "暂无推荐" else: content = "今日(%s)推荐:\n" % datetime.datetime.now().strftime( "%Y-%m-%d") for r in results: content += "%s %s \n" % (r[0], r[1]) mail.send(content) logging.warning("发送邮件")
def get(self, page): page = int(page) sql = "SELECT COUNT(*) FROM blog_list WHERE blog_status = 2" if page > get_page(sql) or page < 1: self.redirect("/") else: total = get_total(sql) count = page_count if total < (page * page_count): count = total - (page - 1) * page_count start = (page - 1) * page_count sql = "SELECT blog_id, auther_id, blog_info, create_time FROM blog_list WHERE blog_status = 2 ORDER BY create_time DESC LIMIT " + str(start) + "," + str(count) blog_list = mysql_util.select(sql) self.render('index.html', blog_list=blog_list, current_page=page, total_page=get_page("SELECT COUNT(*) FROM blog_list WHERE blog_status = 2"), login=self.is_login())
def get(self, page): if not self.get_current_user(): self.set_secure_cookie('url', self.request.uri) self.redirect('/session') return page = int(page) sql = "SELECT COUNT(*) FROM blog_list WHERE blog_status = 1" if page > get_page(sql) or page < 1: self.redirect("/") else: total = get_total(sql) count = page_count if total < (page * page_count): count = total - (page - 1) * page_count start = (page - 1) * page_count sql = "SELECT blog_id, auther_id, blog_info, create_time, blog_status FROM blog_list WHERE blog_status = 1 ORDER BY create_time DESC LIMIT " + str(start) + "," + str(count) blog_list = mysql_util.select(sql) self.render('home.html', blog_list=blog_list, current_page=page, total_page=get_page("SELECT COUNT(*) FROM blog_list WHERE blog_status = 1"), login=self.is_login())
def get_total(sql): cur = mysql_util.select(sql) return cur.fetchall()[0][0]
def get(self): k = self.get_argument('k') sql = "SELECT blog_id, auther_id, blog_info, create_time FROM blog_list WHERE blog_status = 2 AND blog_info LIKE '%" + k + "%' ORDER BY create_time DESC " blog_list = mysql_util.select(sql) self.render('search.html', blog_list=blog_list, k=k, login=self.is_login())