def thread_update(request): response = {} if not request.method == 'POST': return JsonResponse({ 'code': 2, 'response': 'Method in not supported' }) try: request_params = json.loads(request.body) if not ('thread' in request_params and 'message' in request_params and 'slug' in request_params): return JsonResponse({ 'code': 3, 'response': 'Missing field' }) thread_id = request_params.get('thread') message = request_params.get('message') slug = request_params.get('slug') thread_data = get_thread_by_id(thread_id) if not thread_data: return JsonResponse({ 'code': 1, 'response': 'Thread not found' }) sql = "UPDATE thread SET message = %s, slug = %s WHERE id = %s" cursor = connection.cursor() cursor.execute(sql, (message, slug, thread_id)) response = { 'user': get_user_by_id(thread_data[4])[2], 'forum': get_forum_by_id(thread_data[1])[4], 'id': thread_id, 'title': thread_data[2], 'isClosed': bool(thread_data[3]), 'date': thread_data[5].strftime('%Y-%m-%d %H:%M:%S'), 'message': message, 'slug': slug, 'isDeleted': bool(thread_data[8]), 'posts': thread_data[12] if not thread_data[8] else 0, 'likes': thread_data[10], 'dislikes': thread_data[9], 'points': thread_data[11], } except ValueError: return JsonResponse({ 'code': 3, 'response': 'No JSON object could be decoded' }) return JsonResponse({ 'code': 0, 'response': response })
def post_update(request): response = {} if not request.method == 'POST': return JsonResponse({ 'code': 2, 'response': 'Method in not supported' }) try: request_params = json.loads(request.body) except ValueError: return JsonResponse({ 'code': 3, 'response': 'No JSON object could be decoded' }) if not ('post' in request_params and 'message' in request_params): return JsonResponse({ 'code': 3, 'response': 'Missing field' }) post_id = request_params.get('post') post_data = get_post_by_id(post_id) if not post_data: return JsonResponse({ 'code': 1, 'response': 'Post not found' }) message = request_params.get('message') cursor = connection.cursor() sql = "UPDATE post SET message=%s WHERE id = %s" cursor.execute(sql, (message, post_id)) response.update({ 'id': int(post_id), 'forum': get_forum_by_id(post_data[1])[4], 'thread': post_data[2], 'user': get_user_by_id(post_data[3])[2], 'message': message, 'date': post_data[5].strftime('%Y-%m-%d %H:%M:%S'), 'parent': post_data[6], 'isApproved': bool(post_data[8]), 'isHighlighted': bool(post_data[9]), 'isSpam': bool(post_data[10]), 'isEdited': bool(post_data[11]), 'isDeleted': bool(post_data[12]), 'likes': post_data[13], 'dislikes': post_data[14], 'points': post_data[15], }) return JsonResponse({ 'code': 0, 'response': response })
def forum_create(request): response = {} if request.method == "POST": try: data = json.loads(request.body) name = data.get("name", None) short_name = data.get("short_name", None) user = data.get("user", None) if not (name and user and short_name): response.update({"code": 3, "response": "Missing field"}) return JsonResponse(response) cursor = connection.cursor() user_data = get_user_by_email(cursor, user) if not user_data: cursor.close() response.update({"code": 1, "response": "User not found"}) return JsonResponse(response) sql = "SELECT id, owner_id FROM forum WHERE name = %s" cursor.execute(sql, (name,)) sql_response = cursor.fetchone() if sql_response: response["code"] = 0 response["response"] = { "id": sql_response[0], "name": name, "short_name": short_name, "user": get_user_by_id(sql_response[1])[2], } cursor.close() return JsonResponse(response) sql = "INSERT INTO forum (name, short_name, owner_id) VALUES (%s, %s, %s);" cursor.execute(sql, (name, short_name, user_data[0])) response["code"] = 0 response["response"] = {"id": cursor.lastrowid, "name": name, "short_name": short_name, "user": user} cursor.close() except ValueError: response = {"code": 3, "response": "No JSON object could be decoded"} except Exception: response = {"code": 4, "response": "Unknown error occured"} else: response.update({"code": 2, "response": "Method is unsupported"}) return JsonResponse(response)
def forum_details(request): response = {} if not request.method == "GET": return JsonResponse({"code": 2, "response": "Method in not supported"}) if "forum" not in request.GET: return JsonResponse({"code": 3, "response": "Missing field"}) forum = request.GET.get("forum") cursor = connection.cursor() forum_data = get_forum_by_shortname(cursor, forum) cursor.close() if not forum_data: return JsonResponse({"code": 1, "response": "Forum does not exist"}) user_data = get_user_by_id(forum_data[3]) if "related" in request.GET: if request.GET["related"] != "user": return JsonResponse({"code": 3, "response": "Wrong related parameter"}) followers, following = get_follow_data(user_data[0]) subs = get_subscriptions(user_data[0]) user_info = { "username": user_data[1], "email": user_data[2], "name": user_data[3], "about": user_data[4], "isAnonymous": user_data[5], "id": user_data[0], "followers": [f[0] for f in followers], "following": [f[0] for f in following], "subscriptions": [s[0] for s in subs], } else: user_info = user_data[2] response = {"id": forum_data[0], "name": forum_data[1], "short_name": forum_data[4], "user": user_info} return JsonResponse({"code": 0, "response": response})
def thread_create(request): response = {} if not request.method == 'POST': return JsonResponse({ 'code': 2, 'response': 'Method in not supported' }) try: request_params = json.loads(request.body) forum = request_params.get('forum', None) title = request_params.get('title', None) user = request_params.get('user', None) message = request_params.get('message', None) slug = request_params.get('slug', None) date = request_params.get('date', None) is_deleted = request_params.get('isDeleted', False) if type(is_deleted) is not bool: return JsonResponse({ 'code': 3, 'response': 'Wrong isDeleted parameter type' }) if not 'isClosed' in request_params or not (forum and title and user and message and slug and date): return JsonResponse({ 'code': 3, 'response': 'Missing field' }) is_closed = request_params.get('isClosed') if type(is_closed) is not bool: return JsonResponse({ 'code': 3, 'response': 'Wrong isClosed parameter type' }) try: datetime.datetime.strptime(date, '%Y-%m-%d %H:%M:%S') except ValueError: return JsonResponse({ 'code': 3, 'response': 'Wrong date format' }) cursor = connection.cursor() user_data = get_user_by_email(cursor, user) if not user_data: return JsonResponse({ 'code': 1, 'response': 'User not found' }) forum_data = get_forum_by_shortname(cursor, forum) if not forum_data: return JsonResponse({ 'code': 1, 'response': 'Forum not found' }) sql_select = "SELECT * FROM thread WHERE title = %s AND forum_id = %s" cursor.execute(sql_select, (title, forum_data[0])) sql_response = cursor.fetchone() if sql_response: response = { 'title': title, 'forum': forum_data[4], 'message': sql_response[6], 'slug': sql_response[7], 'isClosed': bool(sql_response[3]), 'isDeleted': bool(sql_response[8]), 'id': sql_response[0], 'date': sql_response[5].strftime('%Y-%m-%d %H:%M:%S'), 'user': get_user_by_id(sql_response[4])[2] } return JsonResponse({'code': 0, 'response': response}) sql_insert = "INSERT INTO thread VALUES (null, %s, %s, %s, %s, %s, %s, %s, %s, 0, 0, 0, 0)" sql_insert_data = (forum_data[0], title, is_closed, user_data[0], date, message, slug, is_deleted) cursor.execute(sql_insert, sql_insert_data) response.update({ 'title': title, 'forum': forum_data[4], 'message': message, 'slug': slug, 'isClosed': is_closed, 'isDeleted': is_deleted, 'id': cursor.lastrowid, 'date': date, 'user': user_data[2] }) except ValueError: return JsonResponse({ 'code': 3, 'response': 'No JSON object could be decoded' }) return JsonResponse({ 'code': 0, 'response': response })
def thread_list_posts(request): t1 = datetime.datetime.now() response = [] if not request.method == 'GET': return JsonResponse({ 'code': 2, 'response': 'Method in not supported' }) if 'thread' not in request.GET: return JsonResponse({ 'code': 3, 'response': 'Missing field' }) thread_id = request.GET.get('thread') thread_data = get_thread_by_id(thread_id) if not thread_data: return JsonResponse({ 'code': 1, 'response': 'Thread not found' }) if "since" in request.GET: since = request.GET['since'] try: since = datetime.datetime.strptime(since, '%Y-%m-%d %H:%M:%S') except ValueError: return JsonResponse({ 'code': 3, 'response': 'Since id param is wrong' }) else: since = 0 if "limit" in request.GET: limit = request.GET['limit'] try: limit = int(limit) except ValueError: return JsonResponse({ 'code': 3, 'response': 'Limit param is wrong' }) else: limit = None if "order" in request.GET: order = request.GET['order'] if order != 'asc' and order != 'desc': return JsonResponse({ 'code': 3, 'response': 'Order param is wrong' }) else: order = 'desc' if "sort" in request.GET: sort = request.GET['sort'] if sort != 'flat' and sort != 'tree' and sort != 'parent_tree': return JsonResponse({ 'code': 3, 'response': 'Sort param is wrong' }) else: sort = 'flat' cursor = connection.cursor() if sort == 'flat': sql = "SELECT * FROM post WHERE thread_id = %s AND date>=%s ORDER BY date " sql += order if limit: sql += " LIMIT %s" cursor.execute(sql, (thread_id, since, limit)) else: cursor.execute(sql, (thread_id, since)) data = cursor.fetchall() elif sort == 'tree': if order == 'asc': sql = "SELECT * FROM post WHERE thread_id = %s AND date>=%s ORDER BY path ASC" if limit: sql += " LIMIT %s" cursor.execute(sql, (thread_id, since, limit)) else: cursor.execute(sql, (thread_id, since)) data = cursor.fetchall() else: # tree -> desc query = "SELECT * FROM post " \ "WHERE date>=%s AND thread_id=%s AND parent IS NULL ORDER BY path DESC" query += " LIMIT %s" if limit is not None else "" sql_data = (since, thread_id, limit) if limit is not None else (since, thread_id) cursor.execute(query, sql_data) roots = cursor.fetchall() data = [] if limit: # tree -> desc -> limit posts = 0 for root in roots: if posts < limit: data.append(root) posts += 1 if posts < limit: parent_path = root[7] + '.%' query = "SELECT * FROM post " \ "WHERE path LIKE %s ORDER BY path ASC LIMIT %s" sql_data = (parent_path, limit) cursor.execute(query, sql_data) children = cursor.fetchall() for child in children: if posts < limit: data.append(child) posts += 1 else: # tree -> desc -> no limit for p in roots: data.append(p) parent_path = p[7] + '.%' query = "SELECT * FROM post " \ "WHERE path LIKE %s ORDER BY path ASC" sql_data = (parent_path,) cursor.execute(query, sql_data) data2 = cursor.fetchall() for p1 in data2: data.append(p1) else: # parent_tree query = "SELECT * FROM post " \ "WHERE date>=%s AND thread_id=%s AND parent IS NULL ORDER BY date " query += order query += " LIMIT %s" if limit is not None else "" sql_data = (since, thread_id, limit) if limit is not None else (since, thread_id) cursor.execute(query, sql_data) data1 = cursor.fetchall() data = [] for p in data1: data.append(p) parent_path = p[7] + '.%' query = "SELECT * FROM post " \ "WHERE path LIKE %s ORDER BY path ASC" sql_data = (parent_path,) cursor.execute(query, sql_data) data2 = cursor.fetchall() for p1 in data2: data.append(p1) forum_cache = {} user_cache = {} for p in data: response.append({ 'id': p[0], 'forum': forum_cache.setdefault(p[1], get_forum_by_id(p[1])[4]), 'thread': int(thread_id), 'user': user_cache.setdefault(p[3], get_user_by_id(p[3])[2]), 'message': p[4], 'date': p[5].strftime('%Y-%m-%d %H:%M:%S'), 'parent': p[6], 'isApproved': bool(p[8]), 'isHighlighted': bool(p[9]), 'isSpam': bool(p[10]), 'isEdited': bool(p[11]), 'isDeleted': bool(p[12]), 'likes': p[13], 'dislikes': p[14], 'points': p[15], }) t2 = datetime.datetime.now() print "ELAPSED: ", t2-t1 return JsonResponse({ 'code': 0, 'response': response })
def thread_list(request): response = [] if not request.method == 'GET': return JsonResponse({ 'code': 2, 'response': 'Method in not supported' }) if not ('forum' in request.GET or 'user' in request.GET): return JsonResponse({ 'code': 3, 'response': 'Missing field' }) if 'forum' in request.GET and 'user' in request.GET: return JsonResponse({ 'code': 3, 'response': 'Provide only forum or user' }) if "since" in request.GET: since = request.GET['since'] try: since = datetime.datetime.strptime(since, '%Y-%m-%d %H:%M:%S') except ValueError: return JsonResponse({ 'code': 3, 'response': 'Since id param is wrong' }) else: since = 0 if "limit" in request.GET: limit = request.GET['limit'] try: limit = int(limit) except ValueError: return JsonResponse({ 'code': 3, 'response': 'Limit param is wrong' }) else: limit = None if "order" in request.GET: order = request.GET['order'] if order != 'asc' and order != 'desc': return JsonResponse({ 'code': 3, 'response': 'Order param is wrong' }) else: order = 'desc' by_forum = 'forum' in request.GET cursor = connection.cursor() if by_forum: forum = request.GET.get('forum') forum_data = get_forum_by_shortname(cursor, forum) if not forum_data: cursor.close() return JsonResponse({ 'code': 1, 'response': 'Forum not found' }) search_by = forum_data[0] else: user_email = request.GET.get('user') user_data = get_user_by_email(cursor, user_email) if not user_data: cursor.close() return JsonResponse({ 'code': 1, 'response': 'Thread not found' }) search_by = user_data[0] sql = "SELECT * FROM thread WHERE date>=%s AND " sql += " forum_id = %s" if by_forum else " user_id = %s" sql += " ORDER BY date " sql += order if limit: sql += " LIMIT %s" cursor.execute(sql, (since, search_by, limit)) else: cursor.execute(sql, (since, search_by)) data = cursor.fetchall() for t in data: response.append({ 'user': get_user_by_id(t[4])[2] if by_forum else user_data[2], 'forum': forum_data[4] if by_forum else get_forum_by_id(t[1])[4], 'id': t[0], 'title': t[2], 'isClosed': bool(t[3]), 'date': t[5].strftime('%Y-%m-%d %H:%M:%S'), 'message': t[6], 'slug': t[7], 'isDeleted': bool(t[8]), 'posts': t[12], 'likes': t[10], 'dislikes': t[9], 'points': t[11], }) return JsonResponse({ 'code': 0, 'response': response })
def thread_vote(request): response = {} if not request.method == 'POST': return JsonResponse({ 'code': 2, 'response': 'Method in not supported' }) try: request_params = json.loads(request.body) except ValueError: return JsonResponse({ 'code': 3, 'response': 'No JSON object could be decoded' }) if not ('thread' in request_params and 'vote' in request_params): return JsonResponse({ 'code': 3, 'response': 'Missing field' }) thread_id = request_params.get('thread') thread_data = get_thread_by_id(thread_id) if not thread_data: return JsonResponse({ 'code': 1, 'response': 'Thread not found' }) vote = request_params.get('vote') try: vote = int(vote) except ValueError: return JsonResponse({ 'code': 3, 'response': 'Wrong vote param' }) if vote != 1 and vote != -1: return JsonResponse({ 'code': 3, 'response': 'Wrong vote param' }) cursor = connection.cursor() if vote == 1: cursor.execute("UPDATE thread SET likes=likes+1 WHERE id=%s", (thread_id,)) else: cursor.execute("UPDATE thread SET dislikes=dislikes+1 WHERE id=%s", (thread_id,)) cursor.execute("UPDATE thread SET points=points+%s WHERE id=%s", (vote, thread_id)) thread_data = get_thread_by_id(thread_id) response.update({ 'user': get_user_by_id(thread_data[4])[2], 'forum': get_forum_by_id(thread_data[1])[4], 'id': thread_id, 'title': thread_data[2], 'isClosed': bool(thread_data[3]), 'date': thread_data[5].strftime('%Y-%m-%d %H:%M:%S'), 'message': thread_data[6], 'slug': thread_data[7], 'isDeleted': bool(thread_data[8]), 'posts': thread_data[12], 'likes': thread_data[10], 'dislikes': thread_data[9], 'points': thread_data[11], }) return JsonResponse({ 'code': 0, 'response': response })
def thread_details(request): response = {} if not request.method == 'GET': return JsonResponse({ 'code': 2, 'response': 'Method in not supported' }) if 'thread' not in request.GET: return JsonResponse({ 'code': 3, 'response': 'Missing field' }) thread_id = request.GET.get('thread') thread_data = get_thread_by_id(thread_id) if not thread_data: return JsonResponse({ 'code': 1, 'response': 'Thread not found' }) related = request.GET.getlist('related') forum_data = get_forum_by_id(thread_data[1]) user_data = get_user_by_id(thread_data[4]) for case in related: if case not in ['user', 'forum']: return JsonResponse({ 'code': 3, 'response': 'Wrong related param' }) if 'forum' in related: forum_info = { 'id': forum_data[0], 'name': forum_data[1], 'short_name': forum_data[4], 'user': get_user_by_id(forum_data[3])[2], 'isDeleted': bool(forum_data[2]) } else: forum_info = forum_data[4] if 'user' in related: followers, following = get_follow_data(user_data[0]) subs = get_subscriptions(user_data[0]) user_info = { 'username': user_data[1], 'email': user_data[2], 'name': user_data[3], 'about': user_data[4], 'isAnonymous': user_data[5], 'id': user_data[0], 'followers': [ f[0] for f in followers ], 'following': [ f[0] for f in following ], 'subscriptions': [ s[0] for s in subs ] } else: user_info = user_data[2] response = { 'user': user_info, 'forum': forum_info, 'id': thread_data[0], 'title': thread_data[2], 'isClosed': bool(thread_data[3]), 'date': thread_data[5].strftime('%Y-%m-%d %H:%M:%S'), 'message': thread_data[6], 'slug': thread_data[7], 'isDeleted': bool(thread_data[8]), 'posts': thread_data[12], 'likes': thread_data[10], 'dislikes': thread_data[9], 'points': thread_data[11], } return JsonResponse({ 'code': 0, 'response': response, })
def post_list(request): response = [] if not request.method == 'GET': return JsonResponse({ 'code': 2, 'response': 'Method in not supported' }) if not ('forum' in request.GET or 'thread' in request.GET): return JsonResponse({ 'code': 3, 'response': 'Missing field' }) if 'forum' in request.GET and 'thread' in request.GET: return JsonResponse({ 'code': 3, 'response': 'Provide only forum or thread' }) if "since" in request.GET: since = request.GET['since'] try: since = datetime.datetime.strptime(since, '%Y-%m-%d %H:%M:%S') except ValueError: return JsonResponse({ 'code': 3, 'response': 'Since id param is wrong' }) else: since = 0 if "limit" in request.GET: limit = request.GET['limit'] try: limit = int(limit) except ValueError: return JsonResponse({ 'code': 3, 'response': 'Limit param is wrong' }) else: limit = None if "order" in request.GET: order = request.GET['order'] if order != 'asc' and order != 'desc': return JsonResponse({ 'code': 3, 'response': 'Order param is wrong' }) else: order = 'desc' by_forum = 'forum' in request.GET search_by = None cursor = connection.cursor() if by_forum: forum = request.GET.get('forum') forum_data = get_forum_by_shortname(cursor, forum) if not forum_data: cursor.close() return JsonResponse({ 'code': 1, 'response': 'Forum not found' }) search_by = forum_data[0] else: thread_id = request.GET.get('thread') thread_data = get_thread_by_id(thread_id) if not thread_data: cursor.close() return JsonResponse({ 'code': 1, 'response': 'Thread not found' }) search_by = thread_id sql = "SELECT * FROM post WHERE date>=%s AND " sql += " forum_id = %s" if by_forum else " thread_id = %s" sql += " ORDER BY date " sql += order if limit: sql += " LIMIT %s" cursor.execute(sql, (since, search_by, limit)) else: cursor.execute(sql, (since, search_by)) data = cursor.fetchall() forum_cache = {} user_cache = {} for p in data: response.append({ 'id': int(p[0]), 'forum': forum_data[4] if by_forum else forum_cache.setdefault(p[1], get_forum_by_id(p[1])[4]), 'thread': p[2], 'user': user_cache.setdefault(p[3], get_user_by_id(p[3])[2]), 'message': p[4], 'date': p[5].strftime('%Y-%m-%d %H:%M:%S'), 'parent': p[6], 'isApproved': bool(p[8]), 'isHighlighted': bool(p[9]), 'isSpam': bool(p[10]), 'isEdited': bool(p[11]), 'isDeleted': bool(p[12]), 'likes': p[13], 'dislikes': p[14], 'points': p[15], }) return JsonResponse({ 'code': 0, 'response': response })
def post_details(request): response = {} if not request.method == 'GET': return JsonResponse({ 'code': 2, 'response': 'Method in not supported' }) if 'post' not in request.GET: return JsonResponse({ 'code': 3, 'response': 'Missing field' }) post_id = request.GET.get('post') post_data = get_post_by_id(post_id) if not post_data: return JsonResponse({ 'code': 1, 'response': 'Post not found' }) user_data = get_user_by_id(post_data[3]) thread_data = get_thread_by_id(post_data[2]) forum_data = get_forum_by_id(post_data[1]) if 'related' in request.GET: related = request.GET.getlist('related') for r in related: if r != 'forum' and r != 'user' and r != 'thread': return JsonResponse({ 'code': 3, 'response': 'Wrong related params' }) if 'user' in related: followers, following = get_follow_data(user_data[0]) subs = get_subscriptions(user_data[0]) user_info = { 'id': user_data[0], 'username': user_data[1], 'email': user_data[2], 'name': user_data[3], 'about': user_data[4], 'isAnonymous': bool(user_data[5]), 'followers': [ f[0] for f in followers ], 'following': [ f[0] for f in following ], 'subscriptions': [ s[0] for s in subs ] } else: user_info = user_data[2] if 'forum' in related: forum_info = { 'id': forum_data[0], 'name': forum_data[1], 'short_name': forum_data[4], 'user': get_user_by_id(forum_data[3])[2], 'isDeleted': bool(forum_data[2]) } else: forum_info = forum_data[4] if 'thread' in related: thread_info = { 'id': thread_data[0], 'forum': forum_data[4], 'title': thread_data[2], 'isClosed': bool(thread_data[3]), 'user': get_user_by_id(thread_data[4])[2], 'date': thread_data[5].strftime('%Y-%m-%d %H:%M:%S'), 'message': thread_data[6], 'slug': thread_data[7], 'isDeleted': bool(thread_data[8]), 'dislikes': thread_data[9], 'likes': thread_data[10], 'points': thread_data[11], 'posts': thread_data[12] } else: thread_info = thread_data[0] else: user_info = user_data[2] thread_info = thread_data[0] forum_info = forum_data[4] response.update({ 'id': int(post_id), 'forum': forum_info, 'thread': thread_info, 'user': user_info, 'message': post_data[4], 'date': post_data[5].strftime('%Y-%m-%d %H:%M:%S'), 'parent': post_data[6], 'isApproved': bool(post_data[8]), 'isHighlighted': bool(post_data[9]), 'isSpam': bool(post_data[10]), 'isEdited': bool(post_data[11]), 'isDeleted': bool(post_data[12]), 'likes': post_data[13], 'dislikes': post_data[14], 'points': post_data[15], }) return JsonResponse({ 'code': 0, 'response': response })
def forum_list_posts(request): response = [] if not request.method == "GET": return JsonResponse({"code": 2, "response": "Method in not supported"}) if "forum" not in request.GET: return JsonResponse({"code": 3, "response": "Missing field"}) forum = request.GET.get("forum") cursor = connection.cursor() forum_data = get_forum_by_shortname(cursor, forum) if not forum_data: cursor.close() return JsonResponse({"code": 1, "response": "Forum not found"}) if "since" in request.GET: since = request.GET["since"] try: since = datetime.datetime.strptime(since, "%Y-%m-%d %H:%M:%S") except ValueError: cursor.close() return JsonResponse({"code": 3, "response": "Since id param is wrong"}) else: since = 0 if "limit" in request.GET: limit = request.GET["limit"] try: limit = int(limit) except ValueError: cursor.close() return JsonResponse({"code": 3, "response": "Limit param is wrong"}) else: limit = None if "order" in request.GET: order = request.GET["order"] if order != "asc" and order != "desc": cursor.close() return JsonResponse({"code": 3, "response": "Order param is wrong"}) else: order = "desc" user_related = False forum_related = False thread_related = False if "related" in request.GET: related = request.GET.getlist("related") for r in related: if r != "forum" and r != "user" and r != "thread": cursor.close() return JsonResponse({"code": 3, "response": "Wrong related params"}) if "forum" in related: forum_related = True if "thread" in related: thread_related = True if "user" in related: user_related = True sql = "SELECT * FROM post WHERE forum_id = %s AND date>=%s ORDER BY date " sql += order if limit: sql += " LIMIT %s" cursor.execute(sql, (forum_data[0], since, limit)) else: cursor.execute(sql, (forum_data[0], since)) posts = cursor.fetchall() for p in posts: if forum_related: forum_info = { "id": forum_data[0], "name": forum_data[1], "short_name": forum_data[4], "user": get_user_by_id(forum_data[3])[2], "isDeleted": bool(forum_data[2]), } else: forum_info = forum_data[4] thread_data = get_thread_by_id(p[2]) if thread_related: thread_info = { "id": thread_data[0], "forum": forum_data[4], "title": thread_data[2], "isClosed": bool(thread_data[3]), "user": get_user_by_id(thread_data[4])[2], "date": thread_data[5].strftime("%Y-%m-%d %H:%M:%S"), "message": thread_data[6], "slug": thread_data[7], "isDeleted": bool(thread_data[8]), "dislikes": thread_data[9], "likes": thread_data[10], "points": thread_data[11], "posts": thread_data[12], } else: thread_info = thread_data[0] user_data = get_user_by_id(p[3]) if user_related: followers, following = get_follow_data(user_data[0]) subs = get_subscriptions(user_data[0]) user_info = { "id": user_data[0], "username": user_data[1], "email": user_data[2], "name": user_data[3], "about": user_data[4], "isAnonymous": bool(user_data[5]), "followers": [f[0] for f in followers], "following": [f[0] for f in following], "subscriptions": [s[0] for s in subs], } else: user_info = user_data[2] response.append( { "id": p[0], "forum": forum_info, "thread": thread_info, "user": user_info, "message": p[4], "date": p[5].strftime("%Y-%m-%d %H:%M:%S"), "parent": p[6], "isApproved": bool(p[8]), "isHighlighted": bool(p[9]), "isSpam": bool(p[10]), "isEdited": bool(p[11]), "isDeleted": bool(p[12]), "likes": p[13], "dislikes": p[14], "points": p[15], } ) cursor.close() return JsonResponse({"code": 0, "response": response})