def bioactivities_list(request):
"""
List all code snippets, or create a new Bioactivity.
"""
if request.method == 'GET':
# data = Bioactivity.objects.all().select_related("compound")
data = Bioactivity.objects.raw(
'SELECT id,compound_id,bioactivity_type,value,'
'units FROM bioactivities_bioactivity;'
)
serializer = BioactivitiesSerializer(data, many=True)
return JSONResponse(serializer.data)
elif request.method == 'POST':
data = JSONParser().parse(request)
serializer = BioactivitiesSerializer(data=data)
if serializer.is_valid():
# serializer.save() # do not save anything yet
return JSONResponse(serializer.data, status=201)
return JSONResponse(serializer.errors, status=400)
def bioactivities_detail(request, pk):
"""
Retrieve, update or delete a Bioactivity.
"""
try:
snippet = Bioactivity.objects.get(pk=pk)
except Bioactivity.DoesNotExist:
return HttpResponse(status=404)
if request.method == 'GET':
serializer = BioactivitiesSerializer(snippet)
return JSONResponse(serializer.data)
elif request.method == 'PUT':
data = JSONParser().parse(request)
serializer = BioactivitiesSerializer(snippet, data=data)
if serializer.is_valid():
serializer.save()
return JSONResponse(serializer.data)
return JSONResponse(serializer.errors, status=400)
elif request.method == 'DELETE':
snippet.delete()
return HttpResponse(status=204)