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 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 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 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 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 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 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 retrieveReplyFromXGetN(session_id, topicId, x, n): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if topicId == '': 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 topicId = int(topicId) x = int(x) n = int(n) if x < 0 or n <= 0: data = {'code': 1, 'msg': '跟帖获取失败'} return data result = replyDao.selectReplyFromXGetN(topicId, x, n) if result is None: data = {'code': 1, 'msg': '跟帖获取失败'} return data else: data = [] total = replyDao.selectSumReplyByTopicId(topicId) for reply in result: replyId = reply.replyId floor = reply.floor userId = reply.userId replyTime = reply.replyTime.strftime('%Y-%m-%d %H:%M:%S') likes = reply.likes comNumber = reply.comNumber picture1 = reply.picture1 picture2 = reply.picture2 picture3 = reply.picture3 picture4 = reply.picture4 picture5 = reply.picture5 content = reply.content user = usersDao.selectUserByUserId(userId) if user is None: data = {'code': 1, 'msg': '跟帖获取失败'} return data username = user['username'] iconUrl = user['iconUrl'] rep = { 'replyId': replyId, 'floor': floor, 'userId': userId, 'username': username, 'iconUrl': iconUrl, 'replyTime': replyTime, 'likes': likes, 'picture1': picture1, 'picture2': picture2, 'picture3': picture3, 'picture4': picture4, 'picture5': picture5, 'comNumber': comNumber, 'content': content } data.append(rep) data = {'code': 0, 'data': data, 'total': total} return data
def retrieveOtherUserInfoByUserId(session_id, otherUserId): if session_id == '': data = {'code': 1, 'msg': 'session_id不能为空'} return data if otherUserId == '': data = {'code': 1, 'msg': 'otherUserId不能为空'} return data userId = redisCon.get(session_id) if userId is None: data = {'code': 1, 'msg': '请先登录'} return data result = usersDao.selectUserByUserId(otherUserId) if result is None: data = {'code': 1, 'msg': '用户信息获取失败'} else: isFollow = followDao.selectFollow(int(userId), int(otherUserId)) userPrivacy = userPrivacyDao.selectUserPrivacy(int(otherUserId)) if userPrivacy.isTel == 1: tel = result['tel'] else: tel = '' if userPrivacy.isGender == 1: gender = result['gender'] else: gender = '' if userPrivacy.isAge == 1: age = result['age'] else: age = '' if userPrivacy.isHeight == 1: height = result['height'] else: height = '' if userPrivacy.isWeight == 1: weight = result['weight'] else: weight = '' if userPrivacy.isArea == 1: area = result['area'] else: area = '' if userPrivacy.isJob == 1: job = result['job'] else: job = '' if userPrivacy.isIntegral == 1: integral = result['integral'] else: integral = '' data = { 'code': 0, 'tel': tel, 'username': result['username'], 'gender': gender, 'age': age, 'height': height, 'weight': weight, 'area': area, 'job': job, 'iconUrl': result['iconUrl'], 'integral': integral, 'isFollow': isFollow } return data