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)