def details():
qs = get_json(request)
threadID = qs.get('thread')
if not threadID:
return json.dumps({"code": 2, "response": "No 'thread' key"}, indent=4)
thread = get_thread_by_id(threadID)
if thread == list():
return json.dumps({"code": 1, "response": "Empty set"}, indent=4)
relatedValues = list()
qsRelated = qs.get('related')
if type(qsRelated) is list:
relatedValues.extend(qsRelated)
elif type(qsRelated) is str:
relatedValues.append(qsRelated)
forumRelated = False
userRelated = False
for relatedValue in relatedValues:
if relatedValue == 'forum':
forumRelated = True
elif relatedValue == 'user':
userRelated = True
else:
return json.dumps({"code": 3, "response": "Wrong related value"}, indent=4)
if forumRelated:
thread['forum'] = get_forum_dict(short_name=thread['forum'])
if userRelated:
thread['user'] = get_user_dict(thread['user'])
return json.dumps({"code": 0, "response": thread}, indent=4)
def update():
requestBody = request.json
message = requestBody.get('message')
slug = requestBody.get('slug')
threadID = requestBody.get('thread')
db.execute("""UPDATE Thread SET message = %(message)s, slug = %(slug)s WHERE thread = %(thread)s;""",
{'message': message, 'slug': slug, 'thread': threadID}, True)
return json.dumps({"code": 0, "response": get_thread_by_id(threadID)}, indent=4)
def listPosts():
qs = get_json(request)
forum = qs.get('forum')
if not forum:
return json.dumps({"code": 2, "response": "No 'forum' key"}, indent=4)
# Related part
relatedValues = list()
qsRelated = qs.get('related')
if type(qsRelated) is list:
relatedValues.extend(qsRelated)
elif type(qsRelated) is str:
relatedValues.append(qsRelated)
threadRelated = False
forumRelated = False
userRelated = False
for relatedValue in relatedValues:
if relatedValue == 'thread':
threadRelated = True
elif relatedValue == 'forum':
forumRelated = True
elif relatedValue == 'user':
userRelated = True
else:
return json.dumps({
"code": 3,
"response": "Wrong related value"
},
indent=4)
since = qs.get('since', '')
limit = qs.get('limit', -1)
sort = qs.get('sort', 'flat')
order = qs.get('order', 'desc')
postList = get_post_list(forum=forum,
since=since,
limit=limit,
sort=sort,
order=order)
for post in postList:
if userRelated:
post['user'] = get_user_dict(post['user'])
if threadRelated:
post['thread'] = get_thread_by_id(post['thread'])
if forumRelated:
post['forum'] = get_forum_dict(short_name=post['forum'])
return json.dumps({"code": 0, "response": postList}, indent=4)
def vote():
requestBody = request.json
voteValue = requestBody.get('vote')
threadID = requestBody.get('thread')
if voteValue == 1:
db.execute("""UPDATE Thread SET likes = likes + 1, points = points + 1 WHERE thread = %(thread)s;""",
{'thread': threadID}, True)
else:
db.execute("""UPDATE Thread SET dislikes = dislikes + 1, points = points - 1 WHERE thread = %(thread)s;""",
{'thread': threadID}, True)
return json.dumps({"code": 0, "response": get_thread_by_id(threadID)}, indent=4)
def listPosts():
qs = get_json(request)
forum = qs.get('forum')
if not forum:
return json.dumps({"code": 2, "response": "No 'forum' key"}, indent=4)
# Related part
relatedValues = list()
qsRelated = qs.get('related')
if type(qsRelated) is list:
relatedValues.extend(qsRelated)
elif type(qsRelated) is str:
relatedValues.append(qsRelated)
threadRelated = False
forumRelated = False
userRelated = False
for relatedValue in relatedValues:
if relatedValue == 'thread':
threadRelated = True
elif relatedValue == 'forum':
forumRelated = True
elif relatedValue == 'user':
userRelated = True
else:
return json.dumps({"code": 3, "response": "Wrong related value"}, indent=4)
since = qs.get('since', '')
limit = qs.get('limit', -1)
sort = qs.get('sort', 'flat')
order = qs.get('order', 'desc')
postList = get_post_list(forum=forum, since=since, limit=limit, sort=sort, order=order)
for post in postList:
if userRelated:
post['user'] = get_user_dict(post['user'])
if threadRelated:
post['thread'] = get_thread_by_id(post['thread'])
if forumRelated:
post['forum'] = get_forum_dict(short_name=post['forum'])
return json.dumps({"code": 0, "response": postList}, indent=4)
