def getAllReplies(self, pid):
dao = PostsDAO()
result = dao.getAllReplies(pid)
replies = []
for r in result:
replies.append(self.build_post_query(r))
return jsonify(Replies=replies)
def getNumberOfPostReplies(self):
dao = PostsDAO()
result = dao.getNumberOfPostReplies()
replies = []
for r in result:
replies.append(self.build_post_replies(r))
return jsonify(Replies=replies)
def getAllPostWebsite(self):
dao = PostsDAO()
result = dao.getAllPostWebsite()
posts = []
for r in result:
posts.append(self.build_post_query(r))
return jsonify(Posts=posts)
def deletePost(self, pid):
dao = PostsDAO()
if not dao.getPostById(pid):
return jsonify(Error="Post not found."), 404
else:
dao.delete(pid)
return jsonify(DeleteStatus="OK"), 200
def getPostsPerDayByUser(self, uid):
dao = PostsDAO()
posts_list = dao.getPostsPerDayByUser(uid)
result_list = []
for row in posts_list:
temp = self.build_post_perday(row)
result_list.append(temp)
return jsonify(Posts=result_list)
def getAllPosts(self):
dao = PostsDAO()
posts_list = dao.getAllPosts()
result_list = []
for row in posts_list:
result = self.build_post_dict(row)
result_list.append(result)
return jsonify(Posts=result_list)
def getPostById(self, pid):
dao = PostsDAO()
row = dao.getPostById(pid)
if not row:
return jsonify(Error="Post Not Found"), 404
else:
post = self.build_post_dict(row)
return jsonify(Post=post)
def getNumberOfRepliesPerDay(self):
dao = PostsDAO()
post = dao.getNumberOfRepliesPerDay()
result_list = []
for row in post:
result = self.build_post_repliesperday(row)
result_list.append(result)
return jsonify(Posts=result_list)
def getPostsByUser(self, uid):
dao = PostsDAO()
if not dao.getPostsByUser(uid):
return jsonify(Error="This user has not posted yet"), 404
user_list = dao.getPostsByUser(uid)
result_list = []
for row in user_list:
result = self.build_post_dict(row)
result_list.append(result)
return jsonify(Posts=result_list)
def searchPost(self, args): #date, hashtag, user
date = args.get("date")
hashtag = args.get("hashtag")
user = args.get("uid")
dao = PostsDAO()
posts_list = []
if (len(args) == 3) and date and hashtag and user:
posts_list = dao.getPostsByDateAndHashtagAndUser(
date, hashtag, user)
elif (len(args) == 2) and date and hashtag:
posts_list = dao.getPostsByDateAndHashtag(date, hashtag)
elif (len(args) == 2) and date and user:
posts_list = dao.getPostsByDateAndUser(date, user)
elif (len(args) == 2) and hashtag and user:
posts_list = dao.getPostsByHashtagAndUser(hashtag, user)
elif (len(args) == 1) and date:
posts_list = dao.getPostsByDate(date)
elif (len(args) == 1) and hashtag:
posts_list = dao.getPostsByHashtag(hashtag)
elif (len(args) == 1) and user:
posts_list = dao.getPostsByUser(user)
else:
return jsonify(Error="Malformed query string"), 400
result_list = []
for row in posts_list:
result = self.build_post_dict(row)
result_list.append(result)
return jsonify(Posts=result_list)
def getPostsByHashtag(self, cid, hashtag):
dao = PostsDAO()
row = dao.getPostsByHashtag(cid, hashtag)
if not row:
return jsonify(Error="No Posts in this Chat"), 404
else:
result_list = []
for rows in row:
result = self.build_post_query(rows)
result_list.append(result)
return jsonify(Posts=result_list)
def getPostsByChatIdAndUser(self, cid, uid):
dao = PostsDAO()
row = dao.getPostsByChatIdAndUser(cid, uid)
if not row:
return jsonify(Error="This User hasn't Posted in this Chat"), 404
else:
posts_list = dao.getPostsByChatIdAndUser(cid, uid)
result_list = []
for row in posts_list:
result = self.build_post_dict(row)
result_list.append(result)
return jsonify(Posts=result_list)
def getPostsByDate(self, pdate):
dao = PostsDAO()
row = dao.getPostsByDate(pdate)
if not row:
return jsonify(Error="No Posts in this Date"), 404
else:
posts_list = dao.getPostsByDate(pdate)
result_list = []
for row in posts_list:
result = self.build_post_dict(row)
result_list.append(result)
return jsonify(Posts=result_list)
def insertPostJson(self, json):
pcaption = json['pcaption']
pdate = json['pdate']
pmedia = json['pmedia']
uid = json['uid']
cid = json['cid']
if pcaption and pdate or pmedia and uid and cid:
dao = PostsDAO()
pid = dao.insert(pcaption, pdate, pmedia, uid, cid)
result = self.build_post_attributes(pid, pcaption, pdate, pmedia,
uid, cid)
return jsonify(Post=result), 201
else:
return jsonify(Error="Unexpected attributes in post request"), 400
def insertPost(self, form):
print("form: ", form)
if len(form) != 5:
return jsonify(Error="Malformed post request"), 400
else:
pcaption = form['pname']
pdate = form['pdate']
pmedia = form['pmedia']
uid = form['uid']
cid = form['cid']
if pcaption and pdate and pmedia and uid and cid:
dao = PostsDAO()
pid = dao.insert(pcaption, pdate, pmedia, uid, cid)
result = self.build_post_attributes(pid, pcaption, pdate,
pmedia, uid, cid)
return jsonify(Post=result), 201
else:
return jsonify(
Error="Unexpected attributes in post request"), 400
def updatePost(self, pid, form):
dao = PostsDAO()
if not dao.getPostById(pid):
return jsonify(Error="Post not found."), 404
else:
if len(form) != 3:
return jsonify(Error="Malformed update request"), 400
else:
pcaption = form['pcaption']
pdate = form['pdate']
pmedia = form['pmedia']
uid = form['uid']
if pcaption and pdate and pmedia:
dao.update(pcaption, pdate, pmedia)
result = self.build_post_attributes(
pid, pcaption, pdate, pmedia)
return jsonify(Post=result), 200
else:
return jsonify(
Error="Unexpected attributes in update request"), 400
def getCountByPostId(self):
dao = PostsDAO()
result = dao.getCountByPostId()
#print(self.build_post_counts(result))
return jsonify(PostCounts=self.build_post_counts(result)), 200
def getReactionsByPost(self, pid, reaction):
dao = PostsDAO()
result = dao.getReactionsByPost(pid, reaction)
temp = self.build_post_Alpha(result, reaction)
return jsonify(Posts=temp)
def addLike(self, pid, reaction):
dao = PostsDAO()
result = dao.addLike(pid, reaction)
return result
def getActiveUsers(self):
dao = PostsDAO()
result = dao.getActiveUsers()
return jsonify(Activity=self.build_active_counts(result)), 200
