def getLiuyans():
args = request.args
start = args.get('start')
size = args.get('size')
if start == None:
start = 1
if size == None:
size = 10
start = int(start)
size = int(size)
start = (start - 1) * size
total = 0
data = {}
list = []
# 查询总条数
mysql = dbConn.Mysql()
sql0 = "SELECT count(1) FROM liuyan;"
ret0 = mysql.getOne(sql0, None)
if ret0:
total = ret0[0]
if total == 0:
data['list'] = list
data['start'] = start
data['size'] = size
data['totalCount'] = total
data['totalPage'] = 0
return control.okData(data)
# 查询列表
sql = "SELECT id,content,reply,createtime,replytime FROM liuyan ORDER BY createtime DESC LIMIT %(start)s,%(size)s;"
page = {"start": start, "size": size}
ret = mysql.getAll(sql, page)
mysql.dispose()
if ret:
print(ret)
for row in ret:
replytime = ''
if row[4] != None:
replytime = str(row[4])[0:10]
liuyan = {
"id": row[0],
"content": row[1],
"reply": row[2],
"createtime": str(row[3])[0:10],
"replytime": replytime
}
list.append(liuyan)
data['list'] = list
data['start'] = start
data['size'] = size
data['total'] = total
ys = total % size
if ys == 0:
data['totalPage'] = int(total / size)
else:
data['totalPage'] = int(total / size) + 1
return control.okData(data)
else:
print(ret)
return control.error()
def getArticles():
args = request.args
start = args.get('start')
size = args.get('size')
if start == None:
start = 1
if size == None:
size = 10
start = int(start)
size = int(size)
start = (start - 1) * size
total = 0
data = {}
list = []
# 查询总条数
mysql = dbConn.Mysql()
sql0 = "SELECT count(1) FROM article;"
ret0 = mysql.getOne(sql0, None)
if ret0:
total = ret0[0]
if total == 0:
data['list'] = list
data['start'] = start
data['size'] = size
data['totalCount'] = total
data['totalPage'] = 0
return control.okData(data)
# 查询列表
sql = "SELECT * FROM article ORDER BY createtime DESC LIMIT %(start)s,%(size)s;"
page = {"start": start, "size": size}
ret = mysql.getAll(sql, page)
mysql.dispose()
if ret:
print(ret)
for row in ret:
article = {
"id": row[0],
"title": row[1],
"content": row[2],
"likecount": row[3],
"readcount": row[4],
"updatetime": str(row[6])[0:10],
"createtime": str(row[7])[0:10],
"coverimg": row[10]
}
list.append(article)
data['list'] = list
data['start'] = start
data['size'] = size
data['total'] = total
ys = total % size
if ys == 0:
data['totalPage'] = int(total / size)
else:
data['totalPage'] = int(total / size) + 1
return control.okData(data)
else:
print(ret)
return control.error()
def getArticleDetail():
args = request.args
id = args.get('id')
if id == None:
return control.errorMsg('请输入文章id')
id = int(id)
data = {}
# 查询列表
sql = "SELECT * FROM article WHERE id=%(id)s;"
param = {"id": id}
mysql = dbConn.Mysql()
ret = mysql.getOne(sql, param)
if ret:
print(ret)
data['id'] = ret[0]
data['title'] = ret[1]
data['content'] = ret[2]
data['likecount'] = ret[3]
data['likecount'] = ret[4]
data['createtime'] = str(ret[7])[0:10]
data['coverimg'] = ret[10]
sql2 = "update article set readcount=readcount+1 where id=%(id)s;"
ret2 = mysql.update(sql2, param)
mysql.dispose()
return control.okData(data)
else:
print(ret)
mysql.dispose()
return control.error()
def upload():
images = request.files.get('file')
# 得到upload的路径
upload_dir = os.path.join(os.path.join(sys.path[0], 'static'), 'upload')
if not os.path.exists(upload_dir):
os.makedirs(upload_dir)
url = os.path.join(upload_dir, images.filename)
print(url)
images.save(url)
realurl = os.path.join(request.host_url,
'static/upload/' + images.filename)
data = {"url": realurl}
return control.okData(data)
def getComments():
args = request.args
start = args.get('start')
size = args.get('size')
id = args.get('id')
if id == None:
return control.errorMsg('请输入文章id')
id = int(id)
if start == None:
start = 1
if size == None:
size = 5
start = int(start)
start = (start - 1) * size
total = 0
data = {}
list = []
# 查询总条数
mysql = dbConn.Mysql()
sql0 = "SELECT count(1) FROM comment WHERE articleid=%(id)s AND parentid=0;"
param = {"id": id}
ret0 = mysql.getOne(sql0, param)
if ret0:
print(ret0)
total = ret0[0]
if total == 0:
data['list'] = list
data['start'] = start
data['size'] = size
data['totalCount'] = total
data['totalPage'] = 0
mysql.dispose()
return control.okData(data)
# 查询列表
sql = "SELECT * FROM comment WHERE articleid=%(id)s AND parentid=0 ORDER BY createtime DESC LIMIT %(start)s,%(size)s;"
page = {"id": id, "start": start, "size": size}
ret = mysql.getAll(sql, page)
if ret:
print(ret)
for row in ret:
comm = {
"id": row[0],
"username": row[2],
"content": row[4],
"createtime": str(row[8])
}
list.append(comm)
data['list'] = list
data['start'] = start
data['size'] = size
data['total'] = total
ys = total % size
if ys == 0:
data['totalPage'] = int(total / size)
else:
data['totalPage'] = int(total / size) + 1
mysql.dispose()
return control.okData(data)
else:
print(ret)
mysql.dispose()
return control.error()