def getTableMainInfo(page, pageSize, kind):
startNum = (page - 1) * pageSize
sql = connectMysql.getTableMainInfo(startNum, pageSize, kind)
sql2 = connectMysql.getTableCountInfo(kind)
getResult = connectMysql.getTableInfoResult(sql)
getTotal = connectMysql.getTableInfoResult(sql2)
tableList = []
for item in getResult:
listItem = {
'id': item[0],
'pic_url': item[1],
'pic_width': item[2],
'pic_height': item[3],
'pic_message': item[4],
'greypic_url': item[5],
'greypic_width': item[6],
'greypic_height': item[7],
'greypic_message': item[8],
'judge_result': item[9],
'judge_message': item[10],
'upload_time': item[11],
'likes': item[12],
'favorites': item[13],
'dislikes': item[14],
}
tableList.append(listItem)
return {'list': tableList, 'total': getTotal[0][0]}
def updateFieldNum(id, field):
try:
sql1 = connectMysql.getFieldNum(id, field)
getResult = connectMysql.getTableInfoResult(sql1)
sql2 = connectMysql.addFieldNum(id, field,
list(list(getResult)[0])[0] + 1)
connectMysql.getTableInfoResult(sql2)
return {'code': 200, 'message': '修改成功'}
except BaseException:
return {'code': 205, 'message': '修改成功'}
def getManageInfo():
sql = connectMysql.getManageInfo()
getResult = connectMysql.getTableInfoResult(sql)
result = []
for item in list(getResult):
result.append({'username': list(item)[1], 'password': list(item)[3]})
return result
def getChartSource():
sql = connectMysql.getChartSourceSQL()
getResult = connectMysql.getTableInfoResult(sql)
result = []
sum = 0
for item in list(getResult):
result.append({'item': list(item)[1], 'count': list(item)[0]})
sum += list(item)[0]
return {'result': result, 'sum': sum}
def loginVerify(username, password):
hl = hashlib.md5()
hl.update(password.encode(encoding='utf-8'))
sql = connectMysql.getLoginInfo(username)
passwordResult = connectMysql.getTableInfoResult(sql)
try:
if (list(list(passwordResult)[0])[0] == hl.hexdigest()):
# 高林雄很帅，200是校验成功
return 200
else:
# 反之
return 204
except BaseException:
return 205
def insertLoginInfo(username, password):
hl = hashlib.md5()
hl.update(password.encode(encoding='utf-8'))
sql = connectMysql.insertLoginInfo(username, hl.hexdigest(), password)
connectMysql.getTableInfoResult(sql)
return '增加成功'
def changePicStatus(picId, kind):
sql = connectMysql.changePicStatus(picId, kind)
connectMysql.getTableInfoResult(sql)