def editFamily(session_id, tel, nickname, verifyCode): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if tel == '': data = {'code': 1, 'msg': '手机号不能为空'} return data if nickname == '': data = {'code': 1, 'msg': '昵称不能为空'} return data if verifyCode == '': data = {'code': 1, 'msg': '验证码不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data telCode = redisCon.get(tel) if telCode is None: data = {'code': 1, 'msg': '验证码错误或已失效'} return data if int(telCode) != int(verifyCode): data = {'code': 1, 'msg': '无法保存家属链接'} return data result = familyDao.updateFamily(userId, tel, nickname) if result == 0: data = {'code': 1, 'msg': '无法保存家属链接'} else: data = {'code': 0} return data
def retrieveUserPrivacy(session_id): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data userId = int(userId) privacy = userPrivacyDao.selectUserPrivacy(userId) if privacy is None: data = {'code': 1, 'msg': '无法获取隐私权限'} else: data = { 'code': 0, 'isTel': privacy.isTel, 'isGender': privacy.isGender, 'isAge': privacy.isAge, 'isHeight': privacy.isHeight, 'isWeight': privacy.isWeight, 'isArea': privacy.isArea, 'isJob': privacy.isJob, 'isIntegral': privacy.isIntegral } return data
def editHealth(session_id, insulin, sportTime, weight, bloodPressure, healthTime, healthDate): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if insulin == '': data = {'code': 1, 'msg': '胰岛素用量不能为空'} return data if sportTime == '': data = {'code': 1, 'msg': '运动时间不能为空'} return data if weight == '': data = {'code': 1, 'msg': '体重不能为空'} return data if bloodPressure == '': data = {'code': 1, 'msg': '血压不能为空'} return data if healthTime == '': data = {'code': 1, 'msg': '保存时间不能为空'} return data if healthDate == '': data = {'code': 1, 'msg': '日期不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data result = healthDao.updateHealth(userId, insulin, sportTime, weight, bloodPressure, healthTime, healthDate) if result == 0: data = {'code': 1, 'msg': '无法保存健康记录'} else: data = {'code': 0} return data
def createSubReply(session_id, replyId, content): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if replyId == '': data = {'code': 1, 'msg': '跟帖ID不能为空'} return data if content == '': data = {'code': 1, 'msg': 'content不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data replyId = int(replyId) userId = int(userId) effect_row = subReplyDao.insertSubReply(userId, replyId, content) if effect_row == 1: data = {'code': 0} # 更新话题评论数量、最后回复时间 reply = replyDao.selectReplyByReplyId(replyId) if reply is not None: topicId = reply.topicId topicDao.updateComnumber(topicId, 1) topicDao.updateTopicLastTime(topicId) # 更新跟帖评论数 replyDao.updateComNumber(replyId, 1) else: data = {'code': 1, 'msg': '评论失败'} return data
def retrieveUserOneDayHealth(session_id, healthDate): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if healthDate == '': data = {'code': 1, 'msg': '日期不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data health = healthDao.selectUserOneDayHealth(userId, healthDate) if health is None: data = {'code': 1, 'msg': '健康记录获取失败'} else: data = { 'code': 0, 'healthId': health.healthId, 'insulin': health.insulin, 'sportTime': health.sportTime, 'weight': health.weight, 'bloodPressure': health.bloodPressure, 'healthTime': health.healthTime } return data
def userRetrieveArticle(session_id, articleId): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if articleId == '': data = {'code': 1, 'msg': 'articleId不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data userId = int(userId) articleId = int(articleId) articleData = articleDao.selectArticle(articleId) favoriteData = favoriteArticleDao.seletcFavoriteArticle(userId, articleId) if favoriteData == 1: favorite = 1 else: favorite = 0 if articleData is None: data = {'code': 1, 'msg': '查看文章失败'} else: title = articleData.title contentUrl = '/getArticle?articleId=' + str(articleId) comNumber = articleData.comNumber data = { 'code': 0, 'title': title, 'contentUrl': contentUrl, 'comNumber': comNumber, 'favorite': favorite } return data
def removeSubReply(session_id, subreplyId): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if subreplyId == '': data = {'code': 1, 'msg': '跟帖评论ID不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data subreplyId = int(subreplyId) subreply = subReplyDao.selectSubReplyBySubReplyId(subreplyId) replyId = subreply.replyId reply = replyDao.selectReplyByReplyId(replyId) topicId = reply.topicId result = subReplyDao.deleteSubReply(subreplyId) if result == 1: # 更新话题中记录的跟帖评论的数量 topicDao.updateComnumber(topicId, -1) # 更新跟帖中记录的跟帖评论的数量 replyDao.updateComNumber(replyId, -1) data = {'code': 0, 'msg': '跟帖评论删除成功'} else: data = {'code': 1, 'msg': '跟帖评论无法删除'} return data
def editLikes(session_id, topicId, likes): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if topicId == '': data = {'code': 1, 'msg': '话题ID不能为空'} return data if likes == '': data = {'code': 1, 'msg': '点赞数不能为空'} return data userId = redisCon.get(session_id) topicId = int(topicId) likes = int(likes) if likes != 1 and likes != -1: data = {'code': 1, 'msg': '点赞失败'} return data if userId is None: data = {'code': 1, 'msg': '请先登录'} return data effect_row = topicDao.updateLikes(topicId, likes) if effect_row == 1: data = {'code': 0} else: data = {'code': 1, 'msg': '点赞失败'} return data
def retrieveUserBySessionId(session_id): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data try: userId = redisCon.get(session_id) result = usersDao.selectUserByUserId(userId) except Exception: data = {'code': 1, 'msg': '用户信息获取失败'} return data if userId is None: data = {'code': 1, 'msg': '请先登录'} return data if result is None: data = {'code': 1, 'msg': '用户信息获取失败'} else: data = { 'code': 0, 'tel': result['tel'], 'username': result['username'], 'gender': result['gender'], 'age': result['age'], 'height': result['height'], 'weight': result['weight'], 'area': result['area'], 'job': result['job'], 'iconUrl': result['iconUrl'], 'integral': result['integral'] } return data
def editLikes(session_id, replyId, isLike): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if replyId == '': data = {'code': 1, 'msg': '跟帖ID不能为空'} return data if isLike == '': data = {'code': 1, 'msg': '点赞数不能为空'} return data userId = redisCon.get(session_id) replyId = int(replyId) isLike = int(isLike) if isLike != 1 and isLike != -1: data = {'code': 1, 'msg': '点赞失败'} return data if userId is None: data = {'code': 1, 'msg': '请先登录'} return data effect_row = replyDao.updateLikes(replyId, isLike) if effect_row == 1: data = {'code': 0} else: data = {'code': 1, 'msg': '点赞失败'} return data
def retrieveFamilyList(session_id): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data familyData = familyDao.selectFamilyByUserId(userId) if familyData is None: data = {'code': 1, 'msg': '家属连接获取失败'} else: data = [] total = familyDao.selectSumFamily(userId) for family in familyData: familyId = family.familyId tel = family.tel nickname = family.nickname data.append({ 'familyId': familyId, 'tel': tel, 'nickname': nickname }) data = {'code': 0, 'data': data, 'total': total} return data
def createUser(tel, username, verifyCode, password): if tel == '': data = {'code': 1, 'msg': '手机号不能为空'} return data if username == '': data = {'code': 1, 'msg': '用户名不能为空'} return data if verifyCode == '': data = {'code': 1, 'msg': '验证码不能为空'} return data if password == '': data = {'code': 1, 'msg': '密码不能为空'} return data tableCode = redisCon.get(tel) if tableCode is None: data = {'code': 1, 'msg': '验证码错误或已失效'} return data if int(tableCode) == int(verifyCode): result = usersDao.insertUser(tel, password, username) if result == 0: userData = usersDao.selectUserByTel(tel) userId = userData.userId effect_raw = userPrivacyDao.insertUserPrivacy(userId) if effect_raw == 1: data = {'code': 0} else: data = {'code': 1, 'msg': '注册失败'} elif result == 2: data = {'code': 1, 'msg': '该用户已经注册'} else: data = {'code': 1, 'msg': '注册失败'} else: data = {'code': 1, 'msg': '验证码错误或已失效'} return data
def retrieveFollowMeList(session_id, x, n): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data userId = int(userId) x = int(x) n = int(n) if x < 0 or n <= 0: data = {'code': 1, 'msg': '关注获取失败'} return data result = followDao.selectFollowMeList(userId, x, n) if result is None: data = {'code': 1, 'msg': '请先登录'} else: data = [] total = followDao.selectSumFollowByFollowId(userId) for followMe in result: followMeId = followMe.userId userData = usersDao.selectUserByUserId(int(followMeId)) fol = { 'followMeId ': followMeId, 'username': userData['username'], 'iconUrl': userData['iconUrl'] } data.append(fol) data = {'code': 0, 'data': data, 'total': total} return data
def getArticleLikeTitle(session_id, labelName, keyword, x, n): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if keyword == '': data = {'code': 1, 'msg': '关键词不能为空'} return data if x == '': data = {'code': 1, 'msg': '起始位置不能为空'} return data if n == '': data = {'code': 1, 'msg': '文章数量不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data labelList = eval(labelName) while len(labelList) < 5: labelList.append('') labelOne = str(labelList[0]) labelTwo = str(labelList[1]) labelThree = str(labelList[2]) labelFour = str(labelList[3]) labelFive = str(labelList[4]) x = int(x) n = int(n) if n <= 0 or x < 0: data = {'code': 1, 'msg': '搜索失败'} return data result = articleDao.selectArticleLikeTitle(labelOne, labelTwo, labelThree, labelFour, labelFive, keyword, x, n) if result is None: data = {'code': 1, 'msg': '无法搜索文章'} else: data = [] total = articleDao.selectSumArticleLikeTitle(labelOne, labelTwo, labelThree, labelFour, labelFive, keyword) for article in result: articleId = article.articleId title = article.title content = article.content[:30] articleTime = article.articleTime.strftime('%Y-%m-%d %H:%M:%S') imgData = getImgUrlByArticleId(articleId) imgUrl = imgData['imgUrl'] views = article.views art = { 'articleId': articleId, 'title': title, 'content': content, 'articleTime': articleTime, 'imgUrl': imgUrl, 'views': views } data.append(art) data = {'code': 0, 'data': data, 'total': total} return data
def adminGetFromXGetNTopic(session_id, x, n): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if x == '': data = {'code': 1, 'msg': 'x不能为空'} return data if n == '': data = {'code': 1, 'msg': 'n不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data x = int(x) n = int(n) if x < 0 or n <= 0: data = {'code': 1, 'msg': '话题获取失败'} return data result = topicDao.selectFromXGetNTopic(x, n) if result is None: data = {'code': 1, 'msg': '话题获取失败'} return data else: data = [] total = topicDao.selectSumTopic() for topic in result: topicId = topic.topicId userId = topic.userId lastTime = topic.lastTime.strftime('%Y-%m-%d %H:%M:%S') content = topic.content[:40] picture1 = topic.picture1 picture2 = topic.picture2 picture3 = topic.picture3 replyNum = topic.replyNum comNum = topic.comNum user = usersDao.selectUserByUserId(userId) if user is None: data = {'code': 1, 'msg': '话题获取失败'} return data username = user['username'] iconUrl = user['iconUrl'] top = {'topicId': topicId, 'userId': userId, 'username': username, 'iconUrl': iconUrl, 'lastTime': lastTime, 'content': content, 'picture1': picture1, 'picture2': picture2, 'picture3': picture3, 'replyNum': replyNum, 'comNum': comNum} data.append(top) data = {'code': 0, 'rows': data, 'total': total} return data
def retireveHealthWeekly(session_id): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data dietData = dietPlanDao.selectDietPlan(userId) sportData = sportPlanDao.selectSportPlan(userId) controlData = controlPlanDao.selectConteolPlan(userId) cerealsValue = int(dietData.cereals) fruitValue = int(dietData.fruit) meatValue = int(dietData.meat) milkValue = int(dietData.milk) fatValue = int(dietData.fat) vegetablesValue = int(dietData.vegetables) diet = {'cereals': str(25 * cerealsValue) + '克大米, 麦片,面食, 面包, '+str(50 * cerealsValue)+'克马铃薯', 'fruit': str(500*fruitValue) + '克西瓜, +' + str(300*fruitValue) + '克草莓,'+str(200*fruitValue)+'克葡萄,橙子,橘子 '+str(150*fruitValue)+'克香蕉,荔枝', 'meat': str(25*meatValue) + '克大豆,' + str(20*meatValue) + '克腐竹,' + str(60*meatValue) + '克鸡蛋,' + str(50*meatValue) + '克鸭肉,猪肉,' + str(80*meatValue) + '克草鱼,' + str(100*meatValue) +'克鲫鱼', 'milk': str(20*milkValue) + '克奶粉,' + str(160*milkValue) + '克牛奶,羊奶', 'fat': '(一汤勺为准)' + str(10*fatValue) + '克花生油,豆油,黄油,菜籽油,'+ str(15*fatValue) + '克核桃,杏仁,花生', 'vegetables': str(500*vegetablesValue) + '克白菜,韭菜,西红柿,冬瓜,茄子,丝瓜,' + str(200*vegetablesValue)+'克胡萝卜,' + str(150*vegetablesValue) + '克山药,' + str(70*vegetablesValue) +'克毛豆', 'cerealsValue': cerealsValue, 'fruitValue': fruitValue, 'meatValue': meatValue, 'milkValue': milkValue, 'fatValue': fatValue, 'vegetablesValue': vegetablesValue} sport = { 'sport1': sportData.sport1, 'sport2': sportData.sport2, 'sport3': sportData.sport3, 'sport4': sportData.sport4, 'time1': sportData.time1, 'time2': sportData.time2, 'time3': sportData.time3, 'time4': sportData.time4, 'week1': sportData.week1, 'week2': sportData.week1, 'week3': sportData.week1, 'week4': sportData.week1, } control = { 'min1': controlData.min1, 'max1': controlData.max1, 'min2': controlData.min1, 'max2': controlData.max2, 'sleep1': controlData.sleep1, 'sleep2': controlData.sleep2, } data = {'code': 0, 'diet': diet, 'sport': sport, 'control': control} return data
def retrieveSubReplyFromXGetN(session_id, replyId, x, n): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if replyId == '': data = {'code': 1, 'msg': '跟帖ID不能为空'} return data if x == '': data = {'code': 1, 'msg': 'x不能为空'} return data if n == '': data = {'code': 1, 'msg': 'n不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data replyId = int(replyId) x = int(x) n = int(n) if x < 0 or n <= 0: data = {'code': 1, 'msg': '跟帖评论获取失败'} return data result = subReplyDao.selectSubReplyFromXGetN(replyId, x, n) if result is None: data = {'code': 1, 'msg': '跟帖评论获取失败'} return data else: data = [] total = subReplyDao.selectSumSubReplyByReplyId(replyId) for subreply in result: subreplyId = subreply.subreplyId userId = subreply.userId subreplyTime = subreply.subreplyTime.strftime('%Y-%m-%d %H:%M:%S') content = subreply.content likes = subreply.likes user = usersDao.selectUserByUserId(userId) if user is None: data = {'code': 1, 'msg': '跟帖评论获取失败'} return data username = user['username'] iconUrl = user['iconUrl'] subrep = { 'subreplyId': subreplyId, 'userId': userId, 'iconUrl': iconUrl, 'username': username, 'content': content, 'subreplyTime': subreplyTime, 'likes': likes } data.append(subrep) data = {'code': 0, 'data': data} return data
def retrieveLastTopicList(session_id, topicIdList, n): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if topicIdList == '': data = {'code': 1, 'msg': '已有话题列表不能为空'} return data if n == '': data = {'code': 1, 'msg': 'n不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data n = int(n) if n <= 0: data = {'code': 1, 'msg': '话题获取失败'} return data topicIdList = eval(topicIdList) result = topicDao.selectLastTopicList(topicIdList, n) if result is None: data = {'code': 1, 'msg': '话题获取失败'} return data else: data = [] for topic in result: topicId = topic.topicId userId = topic.userId lastTime = topic.lastTime.strftime('%Y-%m-%d %H:%M:%S') content = topic.content[:40] picture1 = topic.picture1 picture2 = topic.picture2 picture3 = topic.picture3 replyNum = topic.replyNum comNum = topic.comNum user = usersDao.selectUserByUserId(userId) if user is None: data = {'code': 1, 'msg': '话题获取失败'} return data username = user['username'] iconUrl = user['iconUrl'] top = {'topicId': topicId, 'userId': userId, 'username': username, 'iconUrl': iconUrl, 'lastTime': lastTime, 'content': content, 'picture1': picture1, 'picture2': picture2, 'picture3': picture3, 'replyNum': replyNum, 'comNum': comNum} data.append(top) data = {'code': 0, 'data': data} return data
def adminGetFromXGetNUser(session_id, x, n): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if x == '': data = {'code': 1, 'msg': 'x不能为空'} return data if n == '': data = {'code': 1, 'msg': 'n不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data x = int(x) n = int(n) if x < 0 or n <= 0: data = {'code': 1, 'msg': '无法获取用户'} return data result = usersDao.selectFromXGetNUser(x, n) if result is None: data = {'code': 1, 'msg': '无法获取x之后n个用户'} return data else: data = [] total = usersDao.selectSumUsers() for user in result: userId = user.userId tel = user.tel username = user.username gender = user.gender age = user.age signTime = user.signTime.strftime('%Y-%m-%d %H:%M:%S') height = user.height weight = user.weight area = user.area job = user.job integral = user.integral users = { 'userId': userId, 'tel': tel, 'username': username, 'gender': gender, 'age': age, 'signTime': signTime, 'height': height, 'weight': weight, 'area': area, 'job': job, 'integral': integral } data.append(users) temp = {'total': total, 'rows': data, 'code': 0} return temp
def retrieveFavoriteTopic(session_id, x, n): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if x == '': data = {'code': 1, 'msg': 'x不能为空'} return data if n == '': data = {'code': 1, 'msg': 'n不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data userId = int(userId) x = int(x) n = int(n) if x < 0 or n <= 0: data = {'code': 1, 'msg': '获取收藏的话题失败'} return data favoriteData = favoriteTopicDao.seletcUserFavoriteTopic(userId, x, n) if favoriteData is None: data = {'code': 1, 'msg': '获取收藏的话题失败'} else: data = [] total = favoriteTopicDao.selectSumFavoriteTopicByUserId(userId) for favorite in favoriteData: topicId = favorite.topicId topic = topicDao.selectTopicByTopicId(topicId) user = usersDao.selectUserByUserId(userId) if topic is None or user is None: data = {'code': 1, 'msg': '获取收藏的话题失败'} return data content = topic.content[:40] picture1 = topic.picture1 picture2 = topic.picture2 picture3 = topic.picture3 iconUrl = user['iconUrl'] username = user['username'] data.append({ 'topicId': topicId, 'content': content, 'picture1': picture1, 'picture2': picture2, 'picture3': picture3, 'userId': userId, 'iconUrl': iconUrl, 'username': username }) data = {'code': 0, 'data': data, 'total': total} return data
def userLogout(session_id): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '无法登出'} else: redisCon.delete(userId) redisCon.delete(session_id) data = {'code': 0} return data
def retrieveTopicByUserId(session_id, x, n): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if x == '': data = {'code': 1, 'msg': 'x不能为空'} return data if n == '': data = {'code': 1, 'msg': 'n不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data x = int(x) n = int(n) if x < 0 or n <= 0: data = {'code': 1, 'msg': '获取话题失败'} return data topicData = topicDao.selectFromXGetNTopicByUserId(userId, x, n) if topicData is None: data = {'code': 1, 'msg': '获取话题失败'} else: data = [] total = topicDao.selectSumTopicByUserId(userId) for topic in topicData: topicId = topic.topicId content = topic.content[:40] picture1 = topic.picture1 picture2 = topic.picture2 picture3 = topic.picture3 replyNum = topic.replyNum comNum = topic.comNum likes = topic.likes topicTime = topic.topicTime.strftime('%Y-%m-%d %H:%M:%S') favoriteNum = favoriteTopicDao.selectSumTopicByTopicId(topicId) top = {'topicId': topicId, 'content': content, 'picture1': picture1, 'picture2': picture2, 'picture3': picture3, 'replyNum': replyNum, 'comNum': comNum, 'likes': likes, 'topicTime': topicTime, 'favoriteNum': favoriteNum } data.append(top) data = {'code': 0, 'data': data} return data
def getFromXGetNCommentByArticleId(session_id, articleId, x, n): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if articleId == '': data = {'code': 1, 'msg': 'articleId不能为空'} return data if x == '': data = {'code': 1, 'msg': 'x不能为空'} return data if n == '': data = {'code': 1, 'msg': 'n不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data articleId = int(articleId) x = int(x) n = int(n) if x < 0 or n <= 0: data = {'code': 1, 'msg': '评论获取失败'} return data result = commentDao.selectFromXGetNCommentByArticleId(articleId, x, n) if result is None: data = {'code': 1, 'msg': '无法获取x之后n个评论'} else: data = [] total = commentDao.selectSumCommentByArticleId(articleId) for comment in result: commentId = comment.commentId content = comment.content commentTime = comment.commentTime.strftime('%Y-%m-%d %H:%M:%S') userId = comment.userId likes = comment.likes userData = usersDao.selectUserByUserId(userId) username = userData['username'] iconUrl = userData['iconUrl'] art = {'commentId': commentId, 'content': content, 'commentTime': commentTime, 'userId': userId, 'likes': likes, 'username': username, 'iconUrl': iconUrl } data.append(art) data = {'code': 0, 'data': data, 'total': total} return data
def retrieveTopicLikeTopic(session_id, keyword, x, n): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if keyword == '': data = {'code': 1, 'msg': '关键词不能为空'} return data if x == '': data = {'code': 1, 'msg': '起始位置不能为空'} return data if n == '': data = {'code': 1, 'msg': '文章数量不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data x = int(x) n = int(n) if n <= 0 or x < 0: data = {'code': 1, 'msg': '搜索失败'} return data result = topicDao.selectTopicLikeContent(keyword, x, n) if result is None: data = {'code': 1, 'msg': '无法搜索文章'} else: data = [] total = topicDao.selectSumTopicLikeContent(keyword) for topic in result: topicId = topic.topicId lastTime = topic.lastTime.strftime('%Y-%m-%d %H:%M:%S') content = topic.content[:40] userId = topic.userId user = usersDao.selectUserByUserId(userId) if user is None: data = {'code': 1, 'msg': '话题获取失败'} return data username = user['username'] iconUrl = user['iconUrl'] top = {'topicId': topicId, 'lastTime': lastTime, 'content': content, 'userId': userId, 'username': username, 'iconUrl': iconUrl } data.append(top) data = {'code': 0, 'data': data, 'total': total} return data
def retrieveTopicByTopicId(session_id, topicId): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if topicId == '': data = {'code': 1, 'msg': 'topicId不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data userId = int(userId) topicId = int(topicId) topic = topicDao.selectTopicByTopicId(topicId) if topic is None: data = {'code': 1, 'msg': '获取话题失败'} else: topicTime = topic.topicTime.strftime('%Y-%m-%d %H:%M:%S') likes = topic.likes content = topic.content picture1 = topic.picture1 picture2 = topic.picture2 picture3 = topic.picture3 picture4 = topic.picture4 picture5 = topic.picture5 favorite = favoriteTopicDao.seletcFavoriteTopic(userId, topicId) topicUserId = topic.userId user = usersDao.selectUserByUserId(topicUserId) if user is None: data = {'code': 1, 'msg': '话题获取失败'} return data username = user['username'] iconUrl = user['iconUrl'] top = {'userId': topicUserId, 'username': username, 'iconUrl': iconUrl, 'topicTime': topicTime, 'favorite': favorite, 'likes': likes, 'content': content, 'picture1': picture1, 'picture2': picture2, 'picture3': picture3, 'picture4': picture4, 'picture5': picture5, } data = {'code': 0, 'data': top} return data
def removeUser(session_id, userId): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data user = redisCon.get(session_id) if user is None: data = {'code': 1, 'msg': '请先登录'} return data userId = int(userId) result = usersDao.deleteUser(userId) if result == 1: data = {'code': 0, 'msg': '用户删除成功'} else: data = {'code': 1, 'msg': '用户删除失败'} return data
def editUserCheckTime(session_id): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data userId = int(userId) result = usersDao.updateCheckTime(userId) if result == 1: data = {'code': 0} else: data = {'code': 1, 'msg': '签到失败'} return data
def retrieveUserBlood(session_id, x, n): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if x == '': data = {'code': 1, 'msg': 'x不能为空'} return data if n == '': data = {'code': 1, 'msg': 'n不能为空'} return data x = int(x) n = int(n) if x < 0 or n <= 0: data = {'code': 1, 'msg': '血糖记录获取失败'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data bloodData = bloodDao.selectUserBloodFromXGetN(userId, x, n) if bloodData is None: data = {'code': 1, 'msg': '血糖记录获取失败'} else: data = [] total = bloodDao.selectSumBlood(userId) for blood in bloodData: bloodId = blood.bloodId level = json.loads(blood.level) bloodData = blood.bloodDate.strftime('%Y-%m-%d') levelList = [float(v) for v in level.values()] averageBlood = '%.2f' % (sum(levelList) / 7.0) maxBlood = max(levelList) minBlood = 1000 for i in range(len(levelList)): if levelList[i] != 0: minBlood = min(minBlood, levelList[i]) data.append({ 'bloodId': bloodId, 'averageBlood': averageBlood, 'maxBlood': maxBlood, 'minBlood': minBlood, 'bloodDate': bloodData }) data = {'code': 0, 'data': data, 'total': total} return data
def removeFavoriteArticle(session_id, articleId): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if articleId == '': data = {'code': 1, 'msg': 'articleId不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data effect_row = favoriteArticleDao.deleteFavoriteArticle(userId, articleId) if effect_row == 1: data = {'code': 0} else: data = {'code': 1, 'msg': '已取消收藏'} return data
def retrieveCommentByUserId(session_id, x, n): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if x == '': data = {'code': 1, 'msg': 'x不能为空'} return data if n == '': data = {'code': 1, 'msg': 'n不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data x = int(x) n = int(n) if x < 0 or n <= 0: data = {'code': 1, 'msg': '获取收藏的文章失败'} return data commentData = commentDao.selectCommentByUser(userId, x, n) if commentData is None: data = {'code': 1, 'msg': '无法获取评论'} else: data = [] total = commentDao.selectSumCommentByUserId(userId) for comment in commentData: commentId = comment.commentId content = comment.content[:20] likes = comment.likes commentTime = comment.commentTime.strftime('%Y-%m-%d %H:%M:%S') articleId = comment.articleId article = articleDao.selectArticle(articleId) if article is None: data = {'code': 1, 'msg': '无法获取评论'} else: title = article.title com = {'commentId': commentId, 'content': content, 'title': title, 'articleId': articleId, 'likes': likes, 'commentTime': commentTime } data.append(com) data = {'code': 0, 'data': data, 'total': total} return data