def create(request): statusCode = 200 result = "bad" content_type = None if "Authorization" in request.headers: auth = universal.decode_token(request.headers["Authorization"]) if auth[0] == False: return HttpResponse (result, content_type, 401) else: return HttpResponse (result, content_type, 401) input = universal.getText(request.body) body = input[1] if input[0] == False: return HttpResponse ("ErrorA", status = 400) if "name" not in body: return HttpResponse ("ErrorB", status = 400) scope = request.headers["scope"] scope = int(scope) if scope != 2: return HttpResponse("Not admin", content_type, 403) statusCode = 201 with connection.cursor() as cursor: cursor.execute("INSERT INTO public.category(name) VALUES (%s) RETURNING id, name", [body["name"]]) returnedId = universal.dictfetchall(cursor) result = universal.dumpJson(returnedId) return HttpResponse (result, status = statusCode, content_type = "application/json")
def create(request, index1): statusCode = 200 result = "bad" content_type = None if "Authorization" in request.headers: auth = universal.decode_token(request.headers["Authorization"]) if auth[0] == False: return HttpResponse(result, content_type, 401) else: return HttpResponse(result, content_type, 401) input = universal.getText(request.body) body = input[1] if input[0] == False: return HttpResponse("ErrorA", status=400) if "content" not in body: return HttpResponse("ErrorB", status=400) statusCode = 201 with connection.cursor() as cursor: cursor.execute( "INSERT INTO public.review(game_id,user_id,content) VALUES (%s,%s,%s) RETURNING id, content", [index1, body["user_id"], body["content"]]) returnedId = universal.dictfetchall(cursor) result = universal.dumpJson(returnedId) return HttpResponse(result, status=statusCode, content_type="application/json")
def getList(request): statusCode = 200 result = "bad" content_type = None if "Authorization" in request.headers: auth = universal.decode_token(request.headers["Authorization"]) if auth[0] == False: return HttpResponse (result, content_type, 401) else: return HttpResponse (result, content_type, 401) with connection.cursor() as cursor: cursor.execute("SELECT * FROM public.category") row = universal.dictfetchall(cursor) result = universal.dumpJson(row) return HttpResponse (result, status = statusCode, content_type = "application/json")