def latest_versions(self, request):
user = self.request.user
max_versions = models.Procedure.objects.raw(
'''
SELECT a.*
FROM api_procedure AS a
LEFT JOIN api_procedure AS b
ON a.uuid = b.uuid AND a.version < b.version
WHERE b.version IS NULL AND a.owner_id = %s
''', [user.id])
serialized = serializer.ProcedureSerializer(max_versions, many=True)
response = Response(serialized.data)
return response
def get_versions(self, request):
user = self.request.user
procedure_id = self.request.GET.get('id')
procedure = models.Procedure.objects.get(id=procedure_id)
versions = models.Procedure.objects.filter(owner=user,
uuid=procedure.uuid)
serialized = serializer.ProcedureSerializer(versions, many=True)
response = Response(serialized.data)
return response