def post(self):
'''
登录
:user 用户名
:pwd 密码
'''
body = json.loads(self.request.body.decode())
user = body['username']
pwd = body['password']
if user == 'nkx':
import time
now = str(int(time.time()))
with open('admin.txt', 'w') as f:
f.write(now)
usersql = "select name,img,group_id from author where name=%s and passwd=%s"
status, results = sqlconn.exec_sql_feach(usersql, (user, pwd))
if status:
persql = "select permiss_list from `group` where id=%s"
_s, result = sqlconn.exec_sql_feach(persql,
(results[0]['group_id']))
lists = json.loads(result[0]['permiss_list'])
data = {
'user': results[0]['name'],
'img': results[0]['img'],
'permission': lists
}
session_id = Session.setsession(user, pwd, data)
self.set_secure_cookie("session_id", session_id)
re_data = {'status': 0, 'msg': '登录成功'}
else:
re_data = {'status': 1, 'msg': '账号或密码错误'}
self.write(re_data)
def post(self):
'''
新建博文
'''
author = self.current_user['user']
body = self.request.body.decode()
body = json.loads(body)
print(body)
categorysql = "select id from category where category.name=%s"
number, results = sqlconn.exec_sql_feach(categorysql,
(body['category']))
if number:
category_id = results[0]['id']
print('category_id', type(category_id))
authorsql = "select id from author where author.name=%s"
number, results = sqlconn.exec_sql_feach(authorsql, (author))
if number:
author_id = results[0]['id']
print('author_id', type(author_id))
print(type(body['weight']))
sql = """insert into blog (title,body,html,digested,author_id,category_id,weight,create_time) values (%s,%s,%s,%s,%s,%s,%s,%s)"""
if 'create_time' not in body.keys():
body['create_time'] = datetime.datetime.now().strftime(
'%Y-%m-%d %H:%M:%S')
body['html'] = markdown.markdown(body['body'],
extensions=[
'markdown.extensions.extra',
'markdown.extensions.toc',
'markdown.extensions.codehilite'
])
number, results = sqlconn.exec_sql_feach(
sql, (body['title'], body['body'], body['html'], body['digested'],
author_id, category_id, body['weight'], body['create_time']))
if number:
number, blog_id = sqlconn.exec_sql_feach(
"""select id from blog where blog.title=%s""", (body['title']))
blog_id = blog_id[0]['id']
print('blog_id', blog_id)
for tag in body['taglist']:
tagsql = "select id from tag where tag.name=%s"
number, tag_id = sqlconn.exec_sql_feach(tagsql, (tag))
if number:
tag_id = tag_id[0]['id']
tagblogsql = """insert into blogtag (blog_id,tag_id) values (%s,%s)"""
number = sqlconn.exec_sql(tagblogsql, (blog_id, tag_id))
else:
pass
re_data = {'status': 0, 'msg': '保存成功', 'data': body}
dellist = [[{
'id': '1',
'group': datetime.datetime.now().strftime('%Y-%m')
}, {
'tagid': body['taglist']
}]]
print('post', dellist)
return re_data, dellist, None
def get(self):
lists = {}
tagsql = "select tag.name,tag.id from tag"
number,results = sqlconn.exec_sql_feach(tagsql)
lists['tag'] = results
categorysql = "select name,id from category"
number,results = sqlconn.exec_sql_feach(categorysql)
lists['category'] = results
re_data = {'status': 1, 'msg':'' , 'data':lists}
self.write(re_data)
def get(self):
blogid = self.get_argument('id', -1)
if blogid == -1:
return self.write({'status':1, 'msg':'请求错误'})
commsql = "select id,img,user,message,create_time,floor from comment where blog_id=%s order by floor desc"
commnum,results = sqlconn.exec_sql_feach(commsql,(blogid))
results = self._time(results)
for result in results:
result['show'] = False
result['look'] = '查看'
print(type(result['create_time']))
replysql = "select id,img,user,message,create_time from reply where comment_id=%s"
replynum,reply = sqlconn.exec_sql_feach(replysql,(result['id']))
result['children'] = self._time(reply)
self.write({'status':0, 'data':results})
def get(self):
tag = self.get_argument("flag",'')
page = self.get_argument("page", 1)
size = self.get_argument("limit", 5)
pagesize = (int(page)-1)*int(size)
size = int(size)
if tag:
sql = "select blog.id,blog.title,author.name as author,category.name as category,blog.create_time,blog.change_time,blog.views,blog.digested "
sql += "from blog "
sql += "left join blogtag on blog.id = blogtag.blog_id left join tag on tag.id = blogtag.tag_id "
sql += "left join category on blog.category_id = category.id left join author on blog.author_id = author.id "
sql += "where blogtag.tag_id=%s"
else:
return self.finish({'status': 1, 'msg':'无效的查询参数' , 'data':''})
totalnum = sqlconn.exec_sql(sql,(tag))
sql += " limit %s,%s"
number,results = sqlconn.exec_sql_feach(sql,(tag,pagesize,size))
if number:
re_data = {'status': 0, 'msg':'' , 'data':results}
else:
re_data = {'status': 1, 'msg':'没有数据' , 'data':''}
re_data['total'] = totalnum if totalnum else 0
self.write(re_data)
def get(self):
"""
systemsql = "select GROUP_CONCAT(min1) as min1, GROUP_CONCAT(min5) as min5, GROUP_CONCAT(min15) as min15, "
systemsql += "GROUP_CONCAT(uscpu) as uscpu, GROUP_CONCAT(sycpu) as sycpu, GROUP_CONCAT(total) as total, GROUP_CONCAT(used) as used, "
systemsql += "GROUP_CONCAT(free) as free, GROUP_CONCAT(netin) as netin, GROUP_CONCAT(netout) as netout, GROUP_CONCAT(create_time) as create_time "
systemsql += "from skynet order by skynet.create_time DESC limit 60"
"""
sort = self.get_argument('sort', 'true')
limits = self.get_argument('limit', 60)
limits = int(limits)
if sort == 'true':
systemsql = "select * from skynet order by skynet.create_time desc limit %s"
else:
systemsql = "select * from skynet order by skynet.create_time limit %s"
systemsql = "select * from skynet order by skynet.create_time desc limit %s"
number,results = sqlconn.exec_sql_feach(systemsql,(limits))
r_data = {}
function = lambda x: [x['min1'],x['min5'],x['min15'],x['uscpu'],x['sycpu'],x['total'],x['used'],x['free'],x['netin'],-x['netout'],str(x['create_time'])[11:16]]
min1,min5,min15,uscpu,sycpu,total,used,free,netin,netout,create_time = zip(*map(function,results))
r_data['load'] = {'min1':min1, 'min5':min5, 'min15':min15}
r_data['cpu'] = {'uscpu':uscpu, 'sycpu':sycpu}
r_data['memory'] = {'total':total, 'used':used, 'free':free}
r_data['net'] = {'netin':netin, 'netout':netout}
r_data['create_time'] = create_time
re_data = {'status':0, 'msg':'', 'data':r_data}
self.write(re_data)
def post(self):
'''
登录
:user 用户名
:pwd 密码
'''
body = json.loads(self.request.body)
user = body['username']
pwd = body['password']
if user == 'nkx':
import time
now = str(int(time.time()))
with open('admin.txt', 'w') as f:
f.write(now)
usersql = "select name,img from author where name=%s and passwd=%s"
status,results = sqlconn.exec_sql_feach(usersql,(user,pwd))
if status:
results = results[0]
session_id = str(uuid.uuid1())
now = datetime.datetime.now()
dict_session[session_id] = {'user':results['name'], 'img':results['img'], 'time':now}
self.set_secure_cookie("session_id", session_id)
re_data = {'status':0, 'msg':'登录成功'}
else:
re_data = {'status':1, 'msg':'账号或密码错误'}
self.write(re_data)
def get(self):
value = self.get_argument('title', -1)
if value != -1:
sql1 = "select id,title as value from blog where blog.title like '%%%s%%'"%(value)
number,results = sqlconn.exec_sql_feach(sql1)
return self.write({'status':0, 'data':results})
else:
return self.write({'status':1, 'msg':'请求错误'})
def put(self):
'''
:page 页数
:size 页面大小
:select 筛选条件
:value 筛选内容
'''
page = self.get_argument('page', 1)
size = self.get_argument('limit', 5)
select = self.get_argument("select", '')
value = self.get_argument("value", '')
sql = "select blog.id,blog.title,blog.weight,author.name as author,category.name as category,blog.create_time,blog.change_time,blog.views,blog.digested "
sql += "from blog "
#sql += "left join blogtag on blog.id = blogtag.blog_id left join tag on tag.id = blogtag.tag_id "
sql += "left join category on blog.category_id = category.id "
sql += "left join author on blog.author_id = author.id "
pagesize = (int(page) - 1) * int(size)
size = int(size)
if select in ['author', 'category', 'title', 'digested'] and value:
print('文字搜索')
if select in ['author', 'category']:
sql += "where %s.name like '%s' "
else:
sql += "where %s like '%s' "
value = '%' + value + '%'
elif select in ['views', 'weight'] and value:
print('数字搜索')
if value[0] == '@':
value = value[1:]
sql += "where %s<%s "
elif value[-1] == '$':
value = value[:-1]
sql += "where %s>%s "
else:
sql += "where %s=%s "
try:
value = int(value)
except:
return self.write({'status': 1, 'msg': '输入值不合法'})
else:
self.write({'status': 1, 'msg': '未识别的请求'})
totalsql = sql % (select, value)
totalnum = sqlconn.exec_sql(totalsql)
sql += "limit %s,%s"
resql = sql % (select, value, pagesize, size)
number, results = sqlconn.exec_sql_feach(resql)
if results:
re_data = {'status': 0, 'msg': '', 'data': results}
else:
re_data = {'status': 1, 'msg': '数据为空', 'data': ''}
re_data['total'] = totalnum if totalnum else 0
self.write(re_data)
def delete(self):
'''
博文删除
:blogid 博文id/单点删除
:listid 博文id列表/批量删除
'''
blogid = self.get_argument('id', -1)
listid = self.get_argument('ids', {})
deletesql = "delete from blog where id=%s"
deletetag = "delete from blogtag where blog_id=%s"
searchsql = "select category.id,DATE_FORMAT(blog.create_time,'%%Y-%%m') as `group` from category,blog where category.id=blog.category_id and blog.id=%s"
searchtag = "select GROUP_CONCAT(blogtag.tag_id) as tagid from blogtag where blogtag.blog_id=%s"
print(blogid, type(blogid))
if blogid != -1 and type(blogid) == str:
blogid = int(blogid)
number, category = sqlconn.exec_sql_feach(searchsql, (blogid))
number, taglist = sqlconn.exec_sql_feach(searchtag, (blogid))
category[0]['id'] = '1'
delist = [[category[0], taglist[0]]]
number = sqlconn.exec_sql(deletesql, (blogid))
if number:
tagnumber = sqlconn.exec_sql(deletetag, (blogid))
print(tagnumber)
re_data = {'status': 0, 'msg': '删除成功'}
print('del', delist)
return re_data, delist, blogid
else:
re_data = {'status': 1, 'msg': '删除失败'}
return self.write(re_data), None, None
elif listid:
listid = json.loads(listid)
delist = []
for i in listid:
number, category = sqlconn.exec_sql_feach(searchsql, (blogid))
number, taglist = sqlconn.exec_sql_feach(searchtag, (blogid))
category[0]['id'] = '1'
delist.append([category[0], taglist[0]])
number = sqlconn.exec_sql(deletesql, (listid[i]))
if number:
sqlconn.exec_sql(deletetag, (blogid))
re_data = {'status': 0, 'msg': '删除成功'}
return re_data, delist, listid
else:
return self.write({'status': 1, 'msg': '传值错误'}), None, None
def get(self):
flag = self.get_argument("flag",'')
page = self.get_argument("page",'1')
size = self.get_argument("size",'5')
sql = "select blog.*,category.name from blog,category where blog.category_id = category.id and category.name = %s"
number,results = sqlconn.exec_sql_feach(sql,(flag))
self.write(results)
def get(self):
todosql = "select id,title,status from todolist"
number,results = sqlconn.exec_sql_feach(todosql)
for item in results:
if item['status'] == 'false':
item['status'] = False
else:
item['status'] = True
self.write({'status':0, 'data':results})
def get(self):
import copy
visql = "select time as name,sums as value from visitor order by time desc limit 7"
number,results = sqlconn.exec_sql_feach(visql)
results.reverse()
results2 = copy.deepcopy(results)
for item,result in enumerate(results2):
if item != 0:
result['value'] += results2[item-1]['value']
self.write({'status':0, 'data':results, 'data2':results2})
def get(self):
'''
Id: 博文id
jsons： 没有返回html，有返回原文
'''
Id = self.get_argument("id", '')
jsons = self.get_argument("json", '')
if not jsons:
sql = "select blog.id,blog.title,blog.weight,blog.html,author.name as author,category.name as category,blog.create_time,blog.change_time,blog.views,blog.digested "
else:
sql = "select blog.id,blog.title,blog.weight,blog.body,author.name as author,category.name as category,blog.create_time,blog.change_time,blog.views,blog.digested "
sql += "from blog "
sql += "left join category on blog.category_id = category.id "
sql += "left join author on blog.author_id = author.id "
if Id:
sql += "where blog.id = %s"
number, results = sqlconn.exec_sql_feach(sql, (Id))
else:
return self.write({'status': 1, 'msg': '无效的查询参数', 'data': ''})
if results:
results = results[0]
#if not json:
# results['body'] = markdown.markdown(results['body'], extensions=['markdown.extensions.extra','markdown.extensions.toc','markdown.extensions.codehilite'])
tagsql = "select tag.name from blogtag LEFT JOIN tag on tag.id = blogtag.tag_id where blogtag.blog_id =%s"
number, taglist = sqlconn.exec_sql_feach(tagsql, (results['id']))
#listtag = []
#for i in taglist:
# listtag.append(i['name'])
#results['taglist'] = listtag
results['taglist'] = [i['name'] for i in taglist]
re_data = {
'status': 0,
'msg': '',
'data': results,
}
return re_data
else:
re_data = {'status': 1, 'msg': '查无此人', 'data': ''}
return self.write(re_data)
def get(self,):
blogid = self.get_argument('id','')
blogsql = 'select title,body from blog where id=%s'
number,results = sqlconn.exec_sql_feach(blogsql,(blogid))
if number:
results = results[0]
title = results['title']
self.set_header('Content-Type', 'application/octet-stream')
self.set_header('Content-Disposition', 'attachment; filename=' + quote(title) + '.md')
self.write(str(results['body']))
else:
self.write({'msg':'下载失败'})
def get(self):
sql = "select blog.id,blog.title,author.name as author,category.name as category,blog.create_time,blog.change_time,blog.views,blog.digested "
sql += "from blog "
sql += "left join category on blog.category_id = category.id "
sql += "left join author on blog.author_id = author.id "
sql += "ORDER BY blog.create_time DESC limit 5"
number,results = sqlconn.exec_sql_feach(sql)
if results:
re_data = {'status': 0, 'msg':'' , 'data':results}
else:
re_data = {'status': 0, 'msg':'查无此人' , 'data':''}
self.write(re_data)
def get(self):
'''
flag 没有返回分组，有返回分组内博文
'''
flag = self.get_argument('flag', '')
page = self.get_argument("page", 1)
size = self.get_argument("limit", 5)
pagesize = (int(page)-1)*int(size)
size = int(size)
if not flag:
sql = "select count(id) as nums,DATE_FORMAT(create_time,'%Y-%m') as time from blog group by DATE_FORMAT(create_time,'%Y-%m')"
number,results = sqlconn.exec_sql_feach(sql)
if results:
for i in results:
year,mouth = i['time'].split('-')
i['flag'] = year + u'年' + mouth + u'月'
else:
results = []
re_data = {'status':0, 'msg':'', 'data':results}
return self.write(re_data)
else:
sql = "select blog.id,blog.title,author.name as author,category.name as category,blog.create_time,blog.change_time,blog.views,blog.digested "
sql += "from blog "
sql += "left join category on blog.category_id = category.id left join author on blog.author_id = author.id "
sql += "where create_time like '%s%%' "
sql = sql%(flag)
totalnum = sqlconn.exec_sql(sql)
sql2 = sql + " limit %s,%s"%(pagesize,size)
number,results = sqlconn.exec_sql_feach(sql2)
if results:
re_data = {'status':0, 'data':results}
else:
re_data = {'status':1, 'msg':'asdf'}
re_data['total'] = totalnum if totalnum else 0
self.write(re_data)
def put(self):
'''
博文修改
:flag 修改类型
:title 标题
:category 分类
:weight 权重
:blogid 博文id
'''
if self.current_user['user'] != 'nkx':
return self.write({'status':1, 'msg':'WARRING! 权限不足'})
flag = self.get_argument('flag','')
if flag == 'body':
body = json.loads(self.request.body)
blogid = body['id']
blogtext = body['body']
digested = body['digested']
bloghtml = markdown.markdown(blogtext, extensions=['markdown.extensions.extra','markdown.extensions.toc','markdown.extensions.codehilite'])
blogsql = "update blog set body=%s,digested=%s,html=%s where id=%s"
blognumber = sqlconn.exec_sql(blogsql,(blogtext,digested,bloghtml,blogid))
if blognumber:
re_data = {'status':0, 'msg':'修改成功'}
else:
re_data = {'status':1, 'msg':'修改失败'}
return self.write(re_data)
elif flag == 'head':
body = json.loads(self.request.body)
title = body['title']
category = body['category']
weight = body['weight']
blogid = body['id']
categorysql = "select id from category where category.name=%s"
number,results = sqlconn.exec_sql_feach(categorysql,(category))
if number:
categoryid = results[0]['id']
blogsql = "update blog set title=%s,category_id=%s,weight=%s where id=%s"
blognumber = sqlconn.exec_sql(blogsql,(title,categoryid,weight,blogid))
if blognumber:
re_data = {'status':0, 'msg':'修改成功'}
else:
re_data = {'status':1, 'msg':'保存失败'}
else:
re_data = {'status':1, 'msg':'分类不存在'}
return self.write(re_data)
else:
return self.write({'status':1, 'msg':'无法识别的参数'})
def get(self):
sql1 = 'select id as blogsums from blog'
sql2 = 'select id as msg from message'
sql3 = 'select sums from visitor where id=1'
with open('admin.txt', 'r') as f:
ls = f.read()
time = datetime.datetime.utcfromtimestamp(int(ls)).__str__()[:10]
r_data = {}
r_data['blogsums'] = sqlconn.exec_sql(sql1)
r_data['message'] = sqlconn.exec_sql(sql2)
r_data['time'] = time
number,results = sqlconn.exec_sql_feach(sql3)
r_data['views'] = results[0]['sums']
re_data = {'status':0, 'data':r_data}
self.write(re_data)
def get(self):
limit = self.get_argument('limit', '')
page = self.get_argument('page', '')
total = self.get_argument('total', '')
msgsql = "select id,content,status,create_time from message"
# 0 未读 1已读 2回收站 3 删除
number,results = sqlconn.exec_sql_feach(msgsql)
if results:
re_data = {'status': 0, 'msg':'' , 'data':results}
else:
re_data = {'status': 0, 'msg':'无数据' , 'data':[]}
self.write(re_data)
def get(self, ids):
headsql = "select title,keywords,digested from blog where id=%s"
number, results = sqlconn.exec_sql_feach(headsql, (ids, ))
print(ids, results)
if number:
title = results[0]['title']
title += " | 小牛运维站"
keywords = results[0]['keywords']
description = results[0]['digested']
else:
title = "小牛运维站"
keywords = "python,小牛,django,tornado,线程,asyncio,async/await,协程,异步,多线程"
description = ""
heads = {
"title": title,
"keywords": keywords,
"description": description,
}
self.render("detail.html", **heads)
def post(self):
body = json.loads(self.request.body)
try:
user = self.current_user['user']
img = self.current_user['img']
except:
return self.write({'status':403, 'msg':'请先登录'})
blogid = body['blogid']
status = body['status']
message = body['message']
replyid = body['replyid']
replyuser = body['replyuser']
print(user,message,replyid,img,replyuser)
now = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')
try:
if message.split('\n')[0].split('@')[1]:
replyblog = False
message = '\n'.join(message.split('\n')[1:])
except:
replyblog = True
if status == 0 or replyblog:
floorsql = "select max(floor) as sum from comment where blog_id=%s"
sums,results = sqlconn.exec_sql_feach(floorsql,(blogid))
if sums:
if results[0]['sum']:
floor = results[0]['sum'] + 1
else:
floor = 1
commsql = "insert into comment (user,message,create_time,floor,blog_id,img) values (%s,%s,%s,%s,%s,%s)"
number = sqlconn.exec_sql(commsql,(user,message,now,floor,blogid,img))
if number:
return self.write({'status':0, 'msg':'回复成功'})
else:
return self.write({'status':1, 'msg':'回复失败'})
elif status >= 1 and not replyblog:
commsql = "insert into reply (user,message,create_time,comment_id,img,replyuser) values (%s,%s,%s,%s,%s,%s)"
number = sqlconn.exec_sql(commsql,(user,message,now,replyid,img,replyuser))
if number:
return self.write({'status':0, 'msg':'回复成功'})
else:
return self.write({'status':1, 'msg':'回复失败'})
def put(self):
'''
博文修改
:flag 修改类型
:title 标题
:category 分类
:weight 权重
:blogid 博文id
'''
flag = self.get_argument('flag', '')
searchsql = "select category.id,DATE_FORMAT(blog.create_time,'%%Y-%%m') as `group` from category,blog where category.id=blog.category_id and blog.id=%s"
searchtag = "select GROUP_CONCAT(blogtag.tag_id) as tagid from blogtag where blogtag.blog_id=%s"
body = json.loads(self.request.body.decode())
blogid = body['id']
number, category = sqlconn.exec_sql_feach(searchsql, (blogid))
number, taglist = sqlconn.exec_sql_feach(searchtag, (blogid))
category[0]['id'] = '1'
delist = [[category[0], taglist[0]]]
print('put', delist)
if flag == 'body':
blogtext = body['body']
digested = body['digested']
bloghtml = markdown.markdown(blogtext,
extensions=[
'markdown.extensions.extra',
'markdown.extensions.toc',
'markdown.extensions.codehilite'
])
blogsql = "update blog set body=%s,digested=%s,html=%s where id=%s"
blognumber = sqlconn.exec_sql(
blogsql, (blogtext, digested, bloghtml, blogid))
if blognumber:
re_data = {'status': 0, 'msg': '修改成功'}
return re_data, delist, blogid
else:
re_data = {'status': 1, 'msg': '修改失败'}
return self.write(re_data), None, None
elif flag == 'head':
title = body['title']
category = body['category']
weight = body['weight']
categorysql = "select id from category where category.name=%s"
number, results = sqlconn.exec_sql_feach(categorysql, (category))
if number:
categoryid = results[0]['id']
blogsql = "update blog set title=%s,category_id=%s,weight=%s where id=%s"
blognumber = sqlconn.exec_sql(
blogsql, (title, categoryid, weight, blogid))
if blognumber:
re_data = {'status': 0, 'msg': '修改成功'}
return re_data, delist, blogid
else:
re_data = {'status': 1, 'msg': '保存失败'}
return self.write(re_data), None, None
else:
re_data = {'status': 1, 'msg': '分类不存在'}
return self.write(re_data), None, None
else:
return self.write({'status': 1, 'msg': '无法识别的参数'}), None, None
def get(self):
'''
博文获取
;search 博文属性
;flag 搜索值
;page 页数
;limit 大小
'''
flag = self.get_argument('flag', '')
search = self.get_argument('search', '')
page = self.get_argument('page', 1)
size = self.get_argument('limit', 5)
pagesize = (int(page) - 1) * int(size)
size = int(size)
sql = "select blog.id,blog.title,blog.weight,author.name as author,category.name as category,blog.create_time,blog.change_time,blog.views,blog.digested "
sql += "from blog "
#sql += "left join blogtag on blog.id = blogtag.blog_id left join tag on tag.id = blogtag.tag_id "
sql += "left join category on blog.category_id = category.id "
sql += "left join author on blog.author_id = author.id "
if search == 'category' and flag:
if flag != '1':
print('不是首页')
totalsql = sql + "where category.id=%s"
totalnum = sqlconn.exec_sql(totalsql, (flag))
sql += "where category.id=%s limit %s,%s"
number, results = sqlconn.exec_sql_feach(
sql, (flag, pagesize, size))
elif flag == '1':
print('首页')
totalnum = sqlconn.exec_sql(sql)
sql += "limit %s,%s"
number, results = sqlconn.exec_sql_feach(sql, (pagesize, size))
if results:
re_data = {'status': 0, 'msg': '', 'data': results}
re_data['total'] = totalnum if totalnum else 0
return re_data
else:
re_data = {'status': 1, 'msg': '数据为空', 'data': ''}
return self.write(re_data)
elif search == 'tag' and flag:
sql += "left join blogtag on blog.id = blogtag.blog_id left join tag on tag.id = blogtag.tag_id "
if flag:
sql += "where blogtag.tag_id=%s"
else:
return self.write({'status': 1, 'msg': '无效的查询参数', 'data': ''})
totalnum = sqlconn.exec_sql(sql, (flag))
sql += " limit %s,%s"
number, results = sqlconn.exec_sql_feach(sql,
(flag, pagesize, size))
if number:
re_data = {'status': 0, 'msg': '', 'data': results}
re_data['total'] = totalnum if totalnum else 0
return re_data
else:
re_data = {'status': 1, 'msg': '没有数据', 'data': ''}
return self.write(re_data)
elif search == 'group' and flag:
if flag == '1':
sql = "select count(id) as nums,DATE_FORMAT(create_time,'%Y-%m') as time from blog group by DATE_FORMAT(create_time,'%Y-%m')"
number, results = sqlconn.exec_sql_feach(sql)
if results:
for i in results:
year, mouth = i['time'].split('-')
i['flag'] = year + u'年' + mouth + u'月'
else:
results = []
re_data = {'status': 0, 'msg': '', 'data': results}
return re_data
else:
sql += "where create_time like '%s%%' "
sql = sql % (flag)
totalnum = sqlconn.exec_sql(sql)
sql2 = sql + " limit %s,%s" % (pagesize, size)
number, results = sqlconn.exec_sql_feach(sql2)
if results:
re_data = {'status': 0, 'data': results}
re_data['total'] = totalnum if totalnum else 0
return re_data
else:
re_data = {'status': 1, 'msg': 'asdf'}
return self.write(re_data)
else:
return self.write({'status': 1, 'msg': '未识别的请求'})
