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)