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)
