def saveArticle():
args = request.args
title = request.form['title']
content = request.form['content']
coverimg = request.form['coverimg']
id = args.get('id')
if title == None:
return control.errorMsg('请输入标题')
if content == None:
return control.errorMsg('请输入内容')
if coverimg == None:
return control.errorMsg('请输入封面')
if id != None:
id = int(id)
article = {
"id": id,
"title": title,
"content": content,
'authorname': '管理员',
"coverimg": coverimg
}
mysql = dbConn.Mysql()
sql = "insert into article(title,content,authorid,authorname,createtime,updatetime,coverimg) values (%(title)s,%(content)s,1,%(authorname)s,NOW(),NOW(),%(coverimg)s);"
if id != None:
sql = "update article set title=%(title)s,content=%(content)s,updatetime=NOW(),coverimg=%(coverimg)s where id=%(id)s;"
print(sql)
ret = mysql.update(sql, article)
mysql.dispose()
if ret:
return control.ok()
else:
return control.errorMsg('保存失败')
def delLiuyan():
args = request.args
id = args.get('id')
if id == None:
return control.errorMsg('请输入ID')
id = int(id)
mysql = dbConn.Mysql()
param = {"id": id}
sql = "delete from liuyan where id=%(id)s;"
print(sql)
ret = mysql.update(sql, param)
mysql.dispose()
if ret:
return control.ok()
else:
return control.errorMsg('操作失败')
def likeArticle():
args = request.args
id = args.get('id')
if id == None:
return control.errorMsg('请输入文章ID')
id = int(id)
mysql = dbConn.Mysql()
param = {"id": id}
sql = "update article set likecount=likecount+1 where id=%(id)s;"
print(sql)
ret = mysql.update(sql, param)
mysql.dispose()
if ret:
return control.ok()
else:
return control.errorMsg('回复失败')
def saveLiuyan():
print(111)
args = request.args
content = request.form['content']
reply = request.form['reply']
id = args.get('id')
if id != None:
id = int(id)
article = {"id": id, "content": content}
mysql = dbConn.Mysql()
sql = "insert into liuyan(content,createtime) values (%(content)s,NOW());"
if id != None:
article = {"id": id, "reply": reply}
sql = "update liuyan set reply=%(reply)s,replytime=NOW() where id=%(id)s;"
print(sql)
ret = mysql.update(sql, article)
mysql.dispose()
if ret:
return control.ok()
else:
return control.errorMsg('保存失败')
def saveComment():
args = request.args
articleid = args.get('articleid')
content = args.get('content')
if articleid == None:
return control.errorMsg('请输入文章ID')
if content == None:
return control.errorMsg('请输入内容')
content = urllib.parse.unquote(content)
articleid = int(articleid)
username = '******'
mysql = dbConn.Mysql()
sql = "insert into comment(articleid,content,userid,username,parentid,createtime,updatetime) value(%s,'%s',0,'%s',0,NOW(),NOW());" % (
articleid, content, username)
print(sql)
ret = mysql.insertOne(sql)
mysql.dispose()
if ret:
return control.ok()
else:
return control.errorMsg('回复失败')