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())
