def listPostsForum(request): cursor = connection.cursor() #обязательные GET shortName = request.GET['forum'] #опциональные GET limit = request.GET.get('limit', None) orderDate = request.GET.get('order', 'desc') since = request.GET.get('since', None) related = request.GET.getlist('related', []) query = '''select postId from Post where forumShortName = '%s' ''' % (shortName) if since is not None: query += " and datePost >= '%s' " % (since) query += " order by datePost %s " % (orderDate) if limit is not None: query += " limit %s " % (limit) try: #выдаст исключение, если такого нет # getInfoForumTest(shortName, [], cursor); cursor.execute(query) rowsPost = cursor.fetchall() d = []; for row in rowsPost: from views.Post import getInfoPost d.append(getInfoPost(row[0], related, cursor)) del getInfoPost code = 0 responseMessage = d except: code = 1 responseMessage = "Forum not found" response = { "code": code, "response": responseMessage} return JsonResponse(response)
def listPostsThread(request): cursor = connection.cursor() #обязательные GET threadId = request.GET['thread'] #опциональные GET limit = request.GET.get('limit', None) orderDate = request.GET.get('order', 'desc') since = request.GET.get('since', None) sort = request.GET.get('sort', 'flat') query = '''select postId from Post where threadId = %s ''' % (threadId) if since is not None: query += " and datePost >= '%s' " % (since) query += " order by datePost %s " % (orderDate) if limit is not None: query += " limit %s " % (limit) try: # getInfoThreadTest(threadId, [], cursor) cursor.execute(query) rowsPost = cursor.fetchall() d = []; for row in rowsPost: from views.Post import getInfoPost d.append(getInfoPost(row[0], [], cursor)) del getInfoPost code = 0 responseMessage = d except: code = 1 responseMessage = "Thread not found" response = { "code": code, "response": responseMessage} return JsonResponse(response)
def listPostsUser(request): cursor = connection.cursor() #обязательные GET userEmail = request.GET['user'] #опциональные GET limit = request.GET.get('limit', None) orderDate = request.GET.get('order', 'desc') since = request.GET.get('since', None) query = '''select postId from Post where userEmail = '%s' ''' % (userEmail) if since is not None: query += " and datePost >= '%s' " % (since) query += " order by datePost %s " % (orderDate) if limit is not None: query += " limit %s " % (limit) try: # getInfoUserTest(userEmail, [], cursor) cursor.execute(query) rowsPost = cursor.fetchall() d = []; for row in rowsPost: d.append(getInfoPost(row[0], [], cursor)) code = 0 responseMessage = d except: code = 1 responseMessage = "User not found" response = { "code": code, "response": responseMessage} return JsonResponse(response)