def restore():
requestBody = request.json
postID = requestBody.get('post')
post = get_post_by_id(postID)
threadID = post['thread']
restore_post(postID)
inc_posts_for_thread(threadID)
return json.dumps({"code": 0, "response": {"post": postID}}, indent=4)
def restore():
requestBody = request.json
postID = requestBody.get('post')
post = get_post_by_id(postID)
threadID = post['thread']
restore_post(postID)
inc_posts_for_thread(threadID)
return json.dumps({"code": 0, "response": {"post": postID}}, indent=4)
def create():
requestBody = request.json
# Required
date = requestBody.get('date')
thread = requestBody.get('thread')
message = requestBody.get('message')
user = requestBody.get('user')
forum = requestBody.get('forum')
# Optional
parent = requestBody.get('parent', None)
if requestBody.get('isApproved', False):
isApproved = 1
else:
isApproved = 0
if requestBody.get('isHighlighted', False):
isHighlighted = 1
else:
isHighlighted = 0
if requestBody.get('isEdited', False):
isEdited = 1
else:
isEdited = 0
if requestBody.get('isSpam', False):
isSpam = 1
else:
isSpam = 0
if requestBody.get('isDeleted', False):
isDeleted = 1
else:
isDeleted = 0
sql = """INSERT INTO Post (user, thread, forum, message, parent, date, \
isSpam, isEdited, isDeleted, isHighlighted, isApproved) VALUES \
(%(user)s, %(thread)s, %(forum)s, %(message)s, %(parent)s, %(date)s, \
%(isSpam)s, %(isEdited)s, %(isDeleted)s, %(isHighlighted)s, %(isApproved)s);"""
args = {'user': user, 'thread': thread, 'forum': forum, 'message': message, 'parent': parent, 'date': date,
'isSpam': isSpam, 'isEdited': isEdited, 'isDeleted': isDeleted, 'isHighlighted': isHighlighted,
'isApproved': isApproved}
postID = db.execute(sql, args, True)
post = get_post_by_id(postID)
inc_posts_for_thread(thread)
if not post:
return json.dumps({"code": 1, "response": "Empty set"}, indent=4)
return json.dumps({"code": 0, "response": post}, indent=4)
def create():
requestBody = request.json
# Required
date = requestBody.get('date')
thread = requestBody.get('thread')
message = requestBody.get('message')
user = requestBody.get('user')
forum = requestBody.get('forum')
# Optional
parent = requestBody.get('parent', None)
if requestBody.get('isApproved', False):
isApproved = 1
else:
isApproved = 0
if requestBody.get('isHighlighted', False):
isHighlighted = 1
else:
isHighlighted = 0
if requestBody.get('isEdited', False):
isEdited = 1
else:
isEdited = 0
if requestBody.get('isSpam', False):
isSpam = 1
else:
isSpam = 0
if requestBody.get('isDeleted', False):
isDeleted = 1
else:
isDeleted = 0
sql = """INSERT INTO Post (user, thread, forum, message, parent, date, \
isSpam, isEdited, isDeleted, isHighlighted, isApproved) VALUES \
(%(user)s, %(thread)s, %(forum)s, %(message)s, %(parent)s, %(date)s, \
%(isSpam)s, %(isEdited)s, %(isDeleted)s, %(isHighlighted)s, %(isApproved)s);"""
args = {
'user': user,
'thread': thread,
'forum': forum,
'message': message,
'parent': parent,
'date': date,
'isSpam': isSpam,
'isEdited': isEdited,
'isDeleted': isDeleted,
'isHighlighted': isHighlighted,
'isApproved': isApproved
}
postID = db.execute(sql, args, True)
post = get_post_by_id(postID)
inc_posts_for_thread(thread)
if not post:
return json.dumps({"code": 1, "response": "Empty set"}, indent=4)
return json.dumps({"code": 0, "response": post}, indent=4)
