def listFollowers(isFollowing): qs = get_json(request) email = qs.get('user') if not email: return json.dumps({"code": 2, "response": "No 'user' key"}, indent=4) # Since part since_id = qs.get('since_id', -1) if since_id != -1: sinceSql = """AND User.user >= {}""".format(since_id) else: sinceSql = "" # Order part order_sql = """ORDER BY User.name {}""".format(qs.get('order', 'desc')) # Limit part limit = qs.get('limit', -1) if limit != -1: try: limit = int(limit) except ValueError: return json.dumps({"code": 3, "response": "Wrong limit value"}, indent=4) if limit < 0: return json.dumps({"code": 3, "response": "Wrong limit value"}, indent=4) limit_sql = """LIMIT {}""".format(limit) else: limit_sql = "" sql = """SELECT about, email, user, isAnonymous, name, username FROM User JOIN Follower ON """ if not isFollowing: sql += """Follower.follower = User.email WHERE Follower.following""" else: sql += """Follower.following = User.email WHERE Follower.follower""" sql += """ = %(email)s {since_value} {order_value} {limit_value};""".format( since_value=sinceSql, order_value=order_sql, limit_value=limit_sql) userListSql = db.execute(sql, {'email': email}) if not userListSql: return json.dumps({"code": 1, "response": "Empty set"}, indent=4) user_list = list() for userSql in userListSql: followerEmail = str_to_json(userSql[1]) user_list.append({'about': str_to_json(userSql[0]), 'email': followerEmail, 'id': str_to_json(userSql[2]), 'isAnonymous': str_to_json(userSql[3]), 'name': str_to_json(userSql[4]), 'username': str_to_json(userSql[5]), 'followers': get_followers_list(followerEmail), 'following': get_following_list(followerEmail), 'subscriptions': get_subscribed_threads_list(followerEmail)}) return json.dumps({"code": 0, "response": user_list}, indent=4)
def listUsers(): qs = get_json(request) if not qs.get('forum'): return json.dumps({"code": 2, "response": "No 'forum' key"}, indent=4) # Since id part since_id = qs.get('since_id') if since_id: try: since_id = int(since_id) except ValueError: return json.dumps({"code": 3, "response": "Wrong since_id value"}, indent=4) since_id_sql = """AND User.user >= {}""".format(since_id) else: since_id_sql = '' # Limit part if qs.get('limit'): limit = qs.get('limit')[0] try: limit = int(limit) except ValueError: return json.dumps({"code": 3, "response": "Wrong limit value"}, indent=4) if limit < 0: return json.dumps({"code": 3, "response": "Wrong limit value"}, indent=4) limit_sql = """LIMIT {}""".format(limit) else: limit_sql = '' # Order part order = qs.get('order', 'desc') order_sql = """ORDER BY User.name {}""".format(order) sql = """SELECT User.user, User.email, User.name, User.username, User.isAnonymous, User.about FROM User \ WHERE User.email IN (SELECT DISTINCT user FROM Post WHERE forum = %(forum)s) {snc_sql} {ord_sql} \ {lim_sql};""".format(snc_sql=since_id_sql, lim_sql=limit_sql, ord_sql=order_sql) userListSql = db.execute(sql, {'forum': qs.get('forum')}) userList = list() for userSql in userListSql: email = str_to_json(userSql[1]) userList.append({'id': str_to_json(userSql[0]), 'email': email, 'name': str_to_json(userSql[2]), 'username': str_to_json(userSql[3]), 'isAnonymous': str_to_json(userSql[4]), 'about': str_to_json(userSql[5]), 'subscriptions': get_subscribed_threads_list(email)}) return json.dumps({"code": 0, "response": userList}, indent=4)
def details(): qs = get_json(request) email = qs.get('user') if not email: return json.dumps({"code": 2, "response": "No 'user' key"}, indent=4) user = get_user_dict(email) user['followers'] = get_followers_list(email) user['following'] = get_following_list(email) user['subscriptions'] = get_subscribed_threads_list(email) return json.dumps({"code": 0, "response": user}, indent=4)
def details(): qs = get_json(request) email = qs.get('user') if not email: return json.dumps({"code": 2, "response": "No 'user' key"}, indent=4) user = get_user_dict(email) user['followers'] = get_followers_list(email) user['following'] = get_following_list(email) user['subscriptions'] = get_subscribed_threads_list(email) return json.dumps({"code": 0, "response": user}, indent=4)
def listThreads(): qs = get_json(request) forum = qs.get('forum') if not forum: return json.dumps({"code": 2, "response": "No 'forum' key"}, indent=4) since = qs.get('since', '') order = qs.get('order', '') limit = qs.get('limit', -1) threadList = get_thread_list(forum=forum, since=since, order=order, limit=limit) # Related part 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) for thread in threadList: if userRelated: thread['user'] = get_user_dict(thread['user']) thread['user']['subscriptions'] = get_subscribed_threads_list( thread['user']['email']) if forumRelated: thread['forum'] = get_forum_dict(short_name=thread['forum']) return json.dumps({"code": 0, "response": threadList}, indent=4)
def listThreads(): qs = get_json(request) forum = qs.get('forum') if not forum: return json.dumps({"code": 2, "response": "No 'forum' key"}, indent=4) since = qs.get('since', '') order = qs.get('order', '') limit = qs.get('limit', -1) threadList = get_thread_list(forum=forum, since=since, order=order, limit=limit) # Related part 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) for thread in threadList: if userRelated: thread['user'] = get_user_dict(thread['user']) thread['user']['subscriptions'] = get_subscribed_threads_list(thread['user']['email']) if forumRelated: thread['forum'] = get_forum_dict(short_name=thread['forum']) return json.dumps({"code": 0, "response": threadList}, indent=4)
def listFollowers(isFollowing): qs = get_json(request) email = qs.get('user') if not email: return json.dumps({"code": 2, "response": "No 'user' key"}, indent=4) # Since part since_id = qs.get('since_id', -1) if since_id != -1: sinceSql = """AND User.user >= {}""".format(since_id) else: sinceSql = "" # Order part order_sql = """ORDER BY User.name {}""".format(qs.get('order', 'desc')) # Limit part limit = qs.get('limit', -1) if limit != -1: try: limit = int(limit) except ValueError: return json.dumps({ "code": 3, "response": "Wrong limit value" }, indent=4) if limit < 0: return json.dumps({ "code": 3, "response": "Wrong limit value" }, indent=4) limit_sql = """LIMIT {}""".format(limit) else: limit_sql = "" sql = """SELECT about, email, user, isAnonymous, name, username FROM User JOIN Follower ON """ if not isFollowing: sql += """Follower.follower = User.email WHERE Follower.following""" else: sql += """Follower.following = User.email WHERE Follower.follower""" sql += """ = %(email)s {since_value} {order_value} {limit_value};""".format( since_value=sinceSql, order_value=order_sql, limit_value=limit_sql) userListSql = db.execute(sql, {'email': email}) if not userListSql: return json.dumps({"code": 1, "response": "Empty set"}, indent=4) user_list = list() for userSql in userListSql: followerEmail = str_to_json(userSql[1]) user_list.append({ 'about': str_to_json(userSql[0]), 'email': followerEmail, 'id': str_to_json(userSql[2]), 'isAnonymous': str_to_json(userSql[3]), 'name': str_to_json(userSql[4]), 'username': str_to_json(userSql[5]), 'followers': get_followers_list(followerEmail), 'following': get_following_list(followerEmail), 'subscriptions': get_subscribed_threads_list(followerEmail) }) return json.dumps({"code": 0, "response": user_list}, indent=4)
def listUsers(): qs = get_json(request) if not qs.get('forum'): return json.dumps({"code": 2, "response": "No 'forum' key"}, indent=4) # Since id part since_id = qs.get('since_id') if since_id: try: since_id = int(since_id) except ValueError: return json.dumps({ "code": 3, "response": "Wrong since_id value" }, indent=4) since_id_sql = """AND User.user >= {}""".format(since_id) else: since_id_sql = '' # Limit part if qs.get('limit'): limit = qs.get('limit')[0] try: limit = int(limit) except ValueError: return json.dumps({ "code": 3, "response": "Wrong limit value" }, indent=4) if limit < 0: return json.dumps({ "code": 3, "response": "Wrong limit value" }, indent=4) limit_sql = """LIMIT {}""".format(limit) else: limit_sql = '' # Order part order = qs.get('order', 'desc') order_sql = """ORDER BY User.name {}""".format(order) sql = """SELECT User.user, User.email, User.name, User.username, User.isAnonymous, User.about FROM User \ WHERE User.email IN (SELECT DISTINCT user FROM Post WHERE forum = %(forum)s) {snc_sql} {ord_sql} \ {lim_sql};""".format(snc_sql=since_id_sql, lim_sql=limit_sql, ord_sql=order_sql) userListSql = db.execute(sql, {'forum': qs.get('forum')}) userList = list() for userSql in userListSql: email = str_to_json(userSql[1]) userList.append({ 'id': str_to_json(userSql[0]), 'email': email, 'name': str_to_json(userSql[2]), 'username': str_to_json(userSql[3]), 'isAnonymous': str_to_json(userSql[4]), 'about': str_to_json(userSql[5]), 'subscriptions': get_subscribed_threads_list(email) }) return json.dumps({"code": 0, "response": userList}, indent=4)