• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

rdmorganiser / rdmo / 14404330126

11 Apr 2025 01:31PM UTC coverage: 90.789% (+0.3%) from 90.478%
14404330126

push

github

web-flow
Merge pull request #1195 from rdmorganiser/2.3.0

RDMO 2.3.0 ⭐

989 of 1076 branches covered (91.91%)

9176 of 10107 relevant lines covered (90.79%)

3.63 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

88.13
rdmo/projects/viewsets.py
1
from django.conf import settings
4✔
2
from django.contrib.sites.shortcuts import get_current_site
4✔
3
from django.core.exceptions import ObjectDoesNotExist
4✔
4
from django.db.models import OuterRef, Prefetch, Q, Subquery
4✔
5
from django.db.models.functions import Coalesce, Greatest
4✔
6
from django.http import Http404, HttpResponseRedirect
4✔
7
from django.utils.translation import gettext_lazy as _
4✔
8

9
from rest_framework import serializers, status
4✔
10
from rest_framework.decorators import action
4✔
11
from rest_framework.exceptions import NotFound, ValidationError
4✔
12
from rest_framework.filters import SearchFilter
4✔
13
from rest_framework.mixins import CreateModelMixin, ListModelMixin, RetrieveModelMixin, UpdateModelMixin
4✔
14
from rest_framework.pagination import PageNumberPagination
4✔
15
from rest_framework.permissions import IsAuthenticated
4✔
16
from rest_framework.response import Response
4✔
17
from rest_framework.reverse import reverse
4✔
18
from rest_framework.viewsets import GenericViewSet, ModelViewSet, ReadOnlyModelViewSet
4✔
19

20
from django_filters.rest_framework import DjangoFilterBackend
4✔
21
from rest_framework_extensions.mixins import NestedViewSetMixin
4✔
22

23
from rdmo.conditions.models import Condition
4✔
24
from rdmo.core.permissions import HasModelPermission
4✔
25
from rdmo.core.utils import human2bytes, is_truthy, return_file_response
4✔
26
from rdmo.options.models import OptionSet
4✔
27
from rdmo.questions.models import Catalog, Page, Question, QuestionSet
4✔
28
from rdmo.tasks.models import Task
4✔
29
from rdmo.views.models import View
4✔
30

31
from .filters import (
4✔
32
    AttributeFilterBackend,
33
    OptionFilterBackend,
34
    ProjectDateFilterBackend,
35
    ProjectOrderingFilter,
36
    ProjectSearchFilterBackend,
37
    ProjectUserFilterBackend,
38
    SnapshotFilterBackend,
39
)
40
from .models import Continuation, Integration, Invite, Issue, Membership, Project, Snapshot, Value, Visibility
4✔
41
from .permissions import (
4✔
42
    HasProjectPagePermission,
43
    HasProjectPermission,
44
    HasProjectProgressModelPermission,
45
    HasProjectProgressObjectPermission,
46
    HasProjectsPermission,
47
    HasProjectVisibilityModelPermission,
48
    HasProjectVisibilityObjectPermission,
49
)
50
from .progress import (
4✔
51
    compute_navigation,
52
    compute_next_relevant_page,
53
    compute_progress,
54
    compute_sets,
55
    compute_show_page,
56
    resolve_conditions,
57
)
58
from .serializers.v1 import (
4✔
59
    IntegrationSerializer,
60
    InviteSerializer,
61
    IssueSerializer,
62
    MembershipSerializer,
63
    ProjectCopySerializer,
64
    ProjectIntegrationSerializer,
65
    ProjectInviteSerializer,
66
    ProjectInviteUpdateSerializer,
67
    ProjectIssueSerializer,
68
    ProjectMembershipSerializer,
69
    ProjectMembershipUpdateSerializer,
70
    ProjectSerializer,
71
    ProjectSnapshotSerializer,
72
    ProjectValueSerializer,
73
    ProjectVisibilitySerializer,
74
    SnapshotSerializer,
75
    UserInviteSerializer,
76
    ValueSearchSerializer,
77
    ValueSerializer,
78
)
79
from .serializers.v1.overview import CatalogSerializer, ProjectOverviewSerializer
4✔
80
from .serializers.v1.page import PageSerializer
4✔
81
from .utils import (
4✔
82
    check_conditions,
83
    check_options,
84
    compute_set_prefix_from_set_value,
85
    copy_project,
86
    get_contact_message,
87
    get_upload_accept,
88
    send_contact_message,
89
    send_invite_email,
90
)
91

92

93
class ProjectPagination(PageNumberPagination):
4✔
94
    page_size = settings.PROJECT_TABLE_PAGE_SIZE
4✔
95

96

97
class ProjectViewSet(ModelViewSet):
4✔
98
    permission_classes = (HasModelPermission | HasProjectsPermission, )
4✔
99
    serializer_class = ProjectSerializer
4✔
100
    pagination_class = ProjectPagination
4✔
101

102
    filter_backends = (
4✔
103
        DjangoFilterBackend,
104
        ProjectUserFilterBackend,
105
        ProjectDateFilterBackend,
106
        ProjectOrderingFilter,
107
        ProjectSearchFilterBackend,
108
    )
109
    filterset_fields = (
4✔
110
        'title',
111
        # user is part of ProjectUserFilterBackend
112
        'catalog',
113
        'catalog__uri'
114
    )
115
    ordering_fields = (
4✔
116
        'title',
117
        'progress',
118
        'role',
119
        'owner',
120
        'updated',
121
        'created',
122
        'last_changed'
123
    )
124

125
    def get_queryset(self):
4✔
126
        queryset = Project.objects.filter_user(self.request.user).distinct().prefetch_related(
4✔
127
            'snapshots',
128
            'views',
129
            Prefetch('memberships', queryset=Membership.objects.select_related('user'), to_attr='memberships_list')
130
        ).select_related('catalog', 'visibility')
131

132
        # prepare subquery for last_changed
133
        last_changed_subquery = Subquery(
4✔
134
            Value.objects.filter(project=OuterRef('pk')).order_by('-updated').values('updated')[:1]
135
        )
136
        # the 'updated' field from a Project always returns a valid DateTime value
137
        # when Greatest returns null, then Coalesce will return the value for 'updated' as a fall-back
138
        # when Greatest returns a value, then Coalesce will return this value
139
        queryset = queryset.annotate(last_changed=Coalesce(Greatest(last_changed_subquery, 'updated'), 'updated'))
4✔
140

141
        return queryset
4✔
142

143
    @action(detail=True, methods=['POST'],
4✔
144
            permission_classes=(HasModelPermission | HasProjectPermission, ))
145
    def copy(self, request, pk=None):
4✔
146
        instance = self.get_object()
4✔
147
        serializer = ProjectCopySerializer(instance, data=request.data, context=self.get_serializer_context())
4✔
148
        serializer.is_valid(raise_exception=True)
4✔
149

150
        # update instance
151
        for key, value in serializer.validated_data.items():
4✔
152
            setattr(instance, key, value)
4✔
153

154
        site = get_current_site(self.request)
4✔
155
        owners = [self.request.user]
4✔
156
        project_copy = copy_project(instance, site, owners)
4✔
157

158
        serializer = self.get_serializer(project_copy)
4✔
159
        headers = self.get_success_headers(serializer.data)
4✔
160
        return Response(serializer.data, status=status.HTTP_201_CREATED, headers=headers)
4✔
161

162
    @action(detail=True, permission_classes=(HasModelPermission | HasProjectPermission, ))
4✔
163
    def overview(self, request, pk=None):
4✔
164
        project = self.get_object()
4✔
165
        serializer = ProjectOverviewSerializer(project, context={'request': request})
4✔
166
        return Response(serializer.data)
4✔
167

168
    @action(detail=True, url_path=r'navigation(?:/(?P<section_id>\d+))?',
4✔
169
            permission_classes=(HasModelPermission | HasProjectPermission, ))
170
    def navigation(self, request, pk=None, section_id=None):
4✔
171
        project = self.get_object()
4✔
172

173
        section = None
4✔
174
        if section_id is not None:
4✔
175
            try:
4✔
176
                section = project.catalog.sections.get(pk=section_id)
4✔
177
            except ObjectDoesNotExist as e:
×
178
                raise NotFound() from e
×
179

180
        project.catalog.prefetch_elements()
4✔
181

182
        navigation = compute_navigation(section, project)
4✔
183
        return Response(navigation)
4✔
184

185
    @action(detail=True, permission_classes=(HasModelPermission | HasProjectPermission, ))
4✔
186
    def resolve(self, request, pk=None):
4✔
187
        snapshot_id = request.GET.get('snapshot')
4✔
188
        set_prefix = request.GET.get('set_prefix')
4✔
189
        set_index = request.GET.get('set_index')
4✔
190

191
        values = self.get_object().values.filter(snapshot_id=snapshot_id).select_related('attribute', 'option')
4✔
192

193
        page_id = request.GET.get('page')
4✔
194
        if page_id:
4✔
195
            try:
×
196
                page = Page.objects.get(id=page_id)
×
197
                conditions = page.conditions.select_related('source', 'target_option')
×
198
                if check_conditions(conditions, values, set_prefix, set_index):
×
199
                    return Response({'result': True})
×
200
            except Page.DoesNotExist:
×
201
                pass
×
202

203
        questionset_id = request.GET.get('questionset')
4✔
204
        if questionset_id:
4✔
205
            try:
×
206
                questionset = QuestionSet.objects.get(id=questionset_id)
×
207
                conditions = questionset.conditions.select_related('source', 'target_option')
×
208
                if check_conditions(conditions, values, set_prefix, set_index):
×
209
                    return Response({'result': True})
×
210
            except QuestionSet.DoesNotExist:
×
211
                pass
×
212

213
        question_id = request.GET.get('question')
4✔
214
        if question_id:
4✔
215
            try:
×
216
                question = Question.objects.get(id=question_id)
×
217
                conditions = question.conditions.select_related('source', 'target_option')
×
218
                if check_conditions(conditions, values, set_prefix, set_index):
×
219
                    return Response({'result': True})
×
220
            except Question.DoesNotExist:
×
221
                pass
×
222

223
        optionset_id = request.GET.get('optionset')
4✔
224
        if optionset_id:
4✔
225
            try:
×
226
                optionset = OptionSet.objects.get(id=optionset_id)
×
227
                conditions = optionset.conditions.select_related('source', 'target_option')
×
228
                if check_conditions(conditions, values, set_prefix, set_index):
×
229
                    return Response({'result': True})
×
230
            except OptionSet.DoesNotExist:
×
231
                pass
×
232

233
        condition_id = request.GET.get('condition')
4✔
234
        if condition_id:
4✔
235
            try:
4✔
236
                condition = Condition.objects.select_related('source', 'target_option').get(id=condition_id)
4✔
237
                if check_conditions([condition], values, set_prefix, set_index):
4✔
238
                    return Response({'result': True})
4✔
239
            except Condition.DoesNotExist:
×
240
                pass
×
241

242
        return Response({'result': False})
4✔
243

244
    @action(detail=True, permission_classes=(HasModelPermission | HasProjectPermission, ))
4✔
245
    def options(self, request, pk=None):
4✔
246
        project = self.get_object()
4✔
247
        try:
4✔
248
            try:
4✔
249
                optionset_id = request.GET.get('optionset')
4✔
250
                optionset = OptionSet.objects.get(pk=optionset_id)
4✔
251
            except (ValueError, OptionSet.DoesNotExist) as e:
×
252
                raise NotFound() from e
×
253

254
            # check if the optionset belongs to this catalog and if it has a provider
255
            project.catalog.prefetch_elements()
4✔
256
            if Question.objects.filter_by_catalog(project.catalog).filter(optionsets=optionset) and \
4✔
257
                    optionset.provider is not None:
258
                options = []
4✔
259
                for option in optionset.provider.get_options(project, search=request.GET.get('search'),
4✔
260
                                                             user=request.user, site=request.site):
261
                    if 'id' not in option:
4✔
262
                        raise RuntimeError(f"'id' is missing in options of '{optionset.provider.class_name}'")
×
263
                    elif 'text' not in option:
4✔
264
                        raise RuntimeError(f"'text' is missing in options of '{optionset.provider.class_name}'")
×
265
                    if 'text_and_help' not in option:
4✔
266
                        if 'help' in option:
4✔
267
                            option['text_and_help'] = '{text} [{help}]'.format(**option)
4✔
268
                        else:
269
                            option['text_and_help'] = '{text}'.format(**option)
4✔
270
                    options.append(option)
4✔
271

272
                return Response(options)
4✔
273

274
        except OptionSet.DoesNotExist:
×
275
            pass
×
276

277
        # if it didn't work return 404
278
        raise NotFound()
×
279

280
    @action(detail=True, methods=['get', 'post'],
4✔
281
            permission_classes=(HasProjectProgressModelPermission | HasProjectProgressObjectPermission, ))
282
    def progress(self, request, pk=None):
4✔
283
        project = self.get_object()
4✔
284

285
        if request.method == 'POST' or project.progress_count is None or project.progress_total is None:
4✔
286
            # compute the progress, but store it only, if it has changed
287
            project.catalog.prefetch_elements()
4✔
288
            progress_count, progress_total = compute_progress(project)
4✔
289
            if progress_count != project.progress_count or progress_total != project.progress_total:
4✔
290
                project.progress_count, project.progress_total = progress_count, progress_total
4✔
291
                project.save()
4✔
292
        try:
4✔
293
            ratio = project.progress_count / project.progress_total
4✔
294
        except ZeroDivisionError:
×
295
            ratio = 0
×
296

297
        return Response({
4✔
298
            'count': project.progress_count,
299
            'total': project.progress_total,
300
            'ratio': ratio
301
        })
302

303
    @action(detail=True, methods=['get', 'post', 'delete'],
4✔
304
            permission_classes=(HasProjectVisibilityModelPermission | HasProjectVisibilityObjectPermission, ))
305
    def visibility(self, request, pk=None):
4✔
306
        project = self.get_object()
4✔
307

308
        try:
4✔
309
            instance = project.visibility
4✔
310
        except Visibility.DoesNotExist:
4✔
311
            instance = None
4✔
312

313
        if request.method == 'POST':
4✔
314
            data = {'project': project.id}
4✔
315

316
            if settings.MULTISITE:
4✔
317
                if request.user.has_perm('projects.change_visibility'):
4✔
318
                    data['sites'] = request.data.getlist('sites', [])
4✔
319
                else:
320
                    data['sites'] = list({
4✔
321
                        *[site.id for site in instance.sites.all()],
322
                        get_current_site(self.request).id
323
                    })
324

325
            if settings.GROUPS:
4✔
326
                data['groups'] = request.data.getlist('groups', [])
4✔
327

328
            serializer = ProjectVisibilitySerializer(instance, data=data)
4✔
329
            serializer.is_valid(raise_exception=True)
4✔
330
            serializer.save()
4✔
331
            return Response(serializer.data)
4✔
332

333
        elif request.method == 'DELETE':
4✔
334
            if instance is not None:
4✔
335
                if settings.MULTISITE and not request.user.has_perm('projects.delete_visibility'):
4✔
336
                    instance.remove_site(get_current_site(self.request))
4✔
337
                else:
338
                    instance.delete()
4✔
339

340
                return Response(status=status.HTTP_204_NO_CONTENT)
4✔
341
        else:
342
            if instance is not None:
4✔
343
                serializer = ProjectVisibilitySerializer(instance)
4✔
344
                return Response(serializer.data)
4✔
345

346
        # if nothing worked, raise 404
347
        raise Http404
4✔
348

349
    @action(detail=True, methods=['get', 'post'],
4✔
350
            permission_classes=(HasModelPermission | HasProjectPermission, ))
351
    def contact(self, request, pk):
4✔
352
        if settings.PROJECT_CONTACT:
4✔
353
            project = self.get_object()
4✔
354
            if request.method == 'POST':
4✔
355
                subject = request.data.get('subject')
4✔
356
                message = request.data.get('message')
4✔
357

358
                if subject and message:
4✔
359
                    send_contact_message(request, subject, message)
4✔
360
                    return Response(status=status.HTTP_204_NO_CONTENT)
4✔
361
                else:
362
                    raise ValidationError({
4✔
363
                        'subject': [_('This field may not be blank.')] if not subject else [],
364
                        'message': [_('This field may not be blank.')] if not message else []
365
                    })
366
            else:
367
                project.catalog.prefetch_elements()
4✔
368
                return Response(get_contact_message(request, project))
4✔
369
        else:
370
            raise Http404
×
371

372
    @action(detail=False, url_path='upload-accept', permission_classes=(IsAuthenticated, ))
4✔
373
    def upload_accept(self, request):
4✔
374
        return Response(get_upload_accept())
4✔
375

376
    @action(detail=False, permission_classes=(IsAuthenticated, ))
4✔
377
    def imports(self, request):
4✔
378
        return Response([{
4✔
379
            'key': key,
380
            'label': label,
381
            'class_name': class_name,
382
            'href': reverse('project_create_import', args=[key])
383
        } for key, label, class_name in settings.PROJECT_IMPORTS if key in settings.PROJECT_IMPORTS_LIST] )
384

385
    def perform_create(self, serializer):
4✔
386
        project = serializer.save(site=get_current_site(self.request))
4✔
387

388
        # add current user as owner
389
        membership = Membership(project=project, user=self.request.user, role='owner')
4✔
390
        membership.save()
4✔
391

392

393
        # add all tasks to project
394
        if self.request.data.get('tasks') is None:
4✔
395
            if not settings.PROJECT_TASKS_SYNC:
4✔
396
                tasks = Task.objects.filter_for_project(project).filter_availability(self.request.user)
4✔
397
                for task in tasks:
4✔
398
                    project.tasks.add(task)
4✔
399

400
        if self.request.data.get('views') is None:
4✔
401
            # add all views to project
402
            if not settings.PROJECT_VIEWS_SYNC:
4✔
403
                views = View.objects.filter_for_project(project).filter_availability(self.request.user)
4✔
404
                for view in views:
4✔
405
                    project.views.add(view)
4✔
406

407

408
class ProjectNestedViewSetMixin(NestedViewSetMixin):
4✔
409

410
    def initial(self, request, *args, **kwargs):
4✔
411
        self.project = self.get_project_from_parent_viewset()
4✔
412
        super().initial(request, *args, **kwargs)
4✔
413

414
    def get_project_from_parent_viewset(self):
4✔
415
        try:
4✔
416
            return Project.objects.filter_user(self.request.user).get(pk=self.get_parents_query_dict().get('project'))
4✔
417
        except Project.DoesNotExist as e:
4✔
418
            raise Http404 from e
4✔
419

420
    def perform_create(self, serializer):
4✔
421
        # this call provides the nested serializers with the project
422
        serializer.save(project=self.project)
4✔
423

424

425
class ProjectMembershipViewSet(ProjectNestedViewSetMixin, ModelViewSet):
4✔
426
    permission_classes = (HasModelPermission | HasProjectPermission, )
4✔
427

428
    filter_backends = (DjangoFilterBackend, )
4✔
429
    filterset_fields = (
4✔
430
        'user',
431
        'user__username',
432
        'role'
433
    )
434

435
    def get_queryset(self):
4✔
436
        return Membership.objects.filter(project=self.project)
4✔
437

438
    def get_serializer_class(self):
4✔
439
        if self.action == 'update':
4✔
440
            return ProjectMembershipUpdateSerializer
4✔
441
        else:
442
            return ProjectMembershipSerializer
4✔
443

444

445
class ProjectIntegrationViewSet(ProjectNestedViewSetMixin, ModelViewSet):
4✔
446
    permission_classes = (HasModelPermission | HasProjectPermission, )
4✔
447
    serializer_class = ProjectIntegrationSerializer
4✔
448

449
    filter_backends = (DjangoFilterBackend, )
4✔
450
    filterset_fields = (
4✔
451
        'provider_key',
452
    )
453

454
    def get_queryset(self):
4✔
455
        return Integration.objects.filter(project=self.project)
4✔
456

457

458
class ProjectInviteViewSet(ProjectNestedViewSetMixin, ModelViewSet):
4✔
459
    permission_classes = (HasModelPermission | HasProjectPermission, )
4✔
460

461
    filter_backends = (DjangoFilterBackend, )
4✔
462
    filterset_fields = (
4✔
463
        'user',
464
        'user__username',
465
        'email',
466
        'role'
467
    )
468

469
    def get_queryset(self):
4✔
470
        return Invite.objects.filter(project=self.project)
4✔
471

472
    def get_serializer_class(self):
4✔
473
        if self.action == 'update':
4✔
474
            return ProjectInviteUpdateSerializer
4✔
475
        else:
476
            return ProjectInviteSerializer
4✔
477

478
    def perform_create(self, serializer):
4✔
479
        super().perform_create(serializer)
4✔
480
        if settings.PROJECT_SEND_INVITE:
4✔
481
            send_invite_email(self.request, serializer.instance)
4✔
482

483

484
class ProjectIssueViewSet(ProjectNestedViewSetMixin, ListModelMixin, RetrieveModelMixin,
4✔
485
                          UpdateModelMixin, GenericViewSet):
486
    permission_classes = (HasModelPermission | HasProjectPermission, )
4✔
487
    serializer_class = ProjectIssueSerializer
4✔
488

489
    filter_backends = (DjangoFilterBackend, )
4✔
490
    filterset_fields = (
4✔
491
        'task',
492
        'task__uri',
493
        'status'
494
    )
495

496
    def get_queryset(self):
4✔
497
        return Issue.objects.filter(project=self.project).prefetch_related('resources')
4✔
498

499

500
class ProjectSnapshotViewSet(ProjectNestedViewSetMixin, CreateModelMixin, RetrieveModelMixin,
4✔
501
                             UpdateModelMixin, ListModelMixin, GenericViewSet):
502
    permission_classes = (HasModelPermission | HasProjectPermission, )
4✔
503
    serializer_class = ProjectSnapshotSerializer
4✔
504

505
    def get_queryset(self):
4✔
506
        return self.project.snapshots.all()
4✔
507

508

509
class ProjectValueViewSet(ProjectNestedViewSetMixin, ModelViewSet):
4✔
510
    permission_classes = (HasModelPermission | HasProjectPermission, )
4✔
511
    serializer_class = ProjectValueSerializer
4✔
512

513
    filter_backends = (AttributeFilterBackend, DjangoFilterBackend)
4✔
514
    filterset_fields = (
4✔
515
        # attribute is part of AttributeFilterBackend
516
        'attribute__uri',
517
        'option',
518
        'option__uri',
519
    )
520

521
    def get_queryset(self):
4✔
522
        return self.project.values.filter(snapshot=None).select_related('attribute', 'option')
4✔
523

524
    @action(detail=False, methods=['POST'], url_path='set',
4✔
525
            permission_classes=(HasModelPermission | HasProjectPermission, ))
526
    def copy_set(self, request, parent_lookup_project, pk=None):
4✔
527
        # copy all values for questions in questionset collections with the attribute
528
        # for this value and the same set_prefix and set_index
529

530
        # obtain the id of the set value for the set we want to copy
531
        try:
4✔
532
            copy_value_id = int(request.data.pop('copy_set_value'))
4✔
533
        except KeyError as e:
4✔
534
            raise ValidationError({
4✔
535
                'copy_set_value': [_('This field may not be blank.')]
536
            }) from e
537
        except ValueError as e:
4✔
538
            raise NotFound from e
4✔
539

540
        # look for this value in the database, using the users permissions, and
541
        # collect all values for this set and all descendants
542
        try:
4✔
543
            copy_value = Value.objects.filter_user(self.request.user).get(id=copy_value_id)
4✔
544
            copy_values = Value.objects.filter_user(self.request.user).filter_set(copy_value)
4✔
545
        except Value.DoesNotExist as e:
4✔
546
            raise NotFound from e
4✔
547

548
        # init list of values to return
549
        response_values = []
4✔
550

551
        set_value_id = request.data.get('id')
4✔
552
        if set_value_id:
4✔
553
            # if an id is given in the post request, this is an import
554
            try:
4✔
555
                # look for the set value for the set we want to import into
556
                set_value = Value.objects.filter_user(self.request.user).get(id=set_value_id)
4✔
557

558
                # collect all non-empty values for this set and all descendants and convert
559
                # them to a list to compare them later to the new values
560
                set_values = Value.objects.filter_user(self.request.user).filter_set(set_value)
4✔
561
                set_values_list = set_values.exclude_empty().values_list('attribute', 'set_prefix', 'set_index')
4✔
562
                set_empty_values_list = set_values.filter_empty().values_list(
4✔
563
                    'attribute', 'set_prefix', 'set_index', 'collection_index'
564
                )
565
            except Value.DoesNotExist as e:
×
566
                raise NotFound from e
×
567
        else:
568
            # otherwise, we want to create a new set and need to create a new set value
569
            # de-serialize the posted new set value and save it, use the ValueSerializer
570
            # instead of ProjectValueSerializer, since the latter does not include project
571
            set_value_serializer = ValueSerializer(data={
4✔
572
                'project': parent_lookup_project,
573
                **request.data
574
            })
575
            set_value_serializer.is_valid(raise_exception=True)
4✔
576
            set_value = set_value_serializer.save()
4✔
577

578
            set_values = Value.objects.none()
4✔
579
            set_values_list = set_empty_values_list = []
4✔
580

581
            # add the new set value to response_values
582
            response_values.append(set_value_serializer.data)
4✔
583

584
        # create new values for the new set
585
        new_values = []
4✔
586
        updated_values = []
4✔
587
        for value in copy_values:
4✔
588
            value.id = None
4✔
589
            value.project = set_value.project
4✔
590
            value.snapshot = None
4✔
591
            if value.set_prefix == set_value.set_prefix:
4✔
592
                value.set_index = set_value.set_index
4✔
593
            else:
594
                value.set_prefix = compute_set_prefix_from_set_value(set_value, value)
4✔
595

596
            # skip this value if value.option does not match the optionsets of it's question
597
            if not check_options(self.project, value):
4✔
598
                continue
4✔
599

600
            # check if the value already exists, we do not consider collection_index
601
            # since we do not want to import e.g. into partially filled checkboxes
602
            if (value.attribute_id, value.set_prefix, value.set_index) in set_values_list:
4✔
603
                # do not overwrite existing values
604
                pass
×
605
            elif (value.attribute_id, value.set_prefix,
4✔
606
                  value.set_index, value.collection_index) in set_empty_values_list:
607
                # update empty values
608
                updated_value = set_values.get(attribute_id=value.attribute_id, set_prefix=value.set_prefix,
×
609
                                               set_index=value.set_index, collection_index=value.collection_index)
610
                updated_value.text = value.text
×
611
                updated_value.option = value.option
×
612
                updated_value.external_id = value.external_id
×
613
                updated_value.save()
×
614

615
                updated_values.append(updated_value)
×
616
            else:
617
                new_values.append(value)
4✔
618

619
        # bulk create the new values
620
        created_values = Value.objects.bulk_create(new_values)
4✔
621
        response_values += [ValueSerializer(instance=value).data for value in created_values]
4✔
622
        response_values += [ValueSerializer(instance=value).data for value in updated_values]
4✔
623

624
        # return all new values
625
        return Response(response_values, status=status.HTTP_201_CREATED)
4✔
626

627
    @action(detail=True, methods=['DELETE'], url_path='set',
4✔
628
            permission_classes=(HasModelPermission | HasProjectPermission, ))
629
    def delete_set(self, request, parent_lookup_project, pk=None):
4✔
630
        # delete all values for questions in questionset collections with the attribute
631
        # for this value and the same set_prefix and set_index
632
        set_value = self.get_object()
4✔
633
        set_value.delete()
4✔
634

635
        # collect all values for this set and all descendants and delete them
636
        values = self.get_queryset().filter_set(set_value)
4✔
637
        values.delete()
4✔
638

639
        return Response(status=status.HTTP_204_NO_CONTENT)
4✔
640

641
    @action(detail=True, methods=['GET', 'POST'],
4✔
642
            permission_classes=(HasModelPermission | HasProjectPermission, ))
643
    def file(self, request, parent_lookup_project, pk=None):
4✔
644
        value = self.get_object()
4✔
645

646
        if request.method == 'POST':
4✔
647
            value.file = request.FILES.get('file')
4✔
648

649
            # check if the project is reached
650
            if value.file and value.file.size + value.project.file_size > human2bytes(settings.PROJECT_FILE_QUOTA):
4✔
651
                raise serializers.ValidationError({
×
652
                    'value': [_('You reached the file quota for this project.')]
653
                })
654

655
            value.save()
4✔
656
            serializer = self.get_serializer(value)
4✔
657
            return Response(serializer.data)
4✔
658

659
        else:
660
            if value.file:
4✔
661
                return return_file_response(value.file.name, value.file_type)
4✔
662

663
        # if it didn't work return 404
664
        raise NotFound()
4✔
665

666

667
class ProjectPageViewSet(ProjectNestedViewSetMixin, RetrieveModelMixin, GenericViewSet):
4✔
668
    permission_classes = (HasModelPermission | HasProjectPagePermission, )
4✔
669
    serializer_class = PageSerializer
4✔
670

671
    def get_queryset(self):
4✔
672
        self.project.catalog.prefetch_elements()
4✔
673
        page = Page.objects.filter_by_catalog(self.project.catalog).prefetch_related(
4✔
674
            *Page.prefetch_lookups,
675
            'page_questions__question__optionsets__optionset_options__option',
676
            'page_questionsets__questionset__questionset_questions__question__optionsets__optionset_options__option',
677
        )
678
        return page
4✔
679

680
    def get_serializer_context(self):
4✔
681
        context = super().get_serializer_context()
4✔
682
        context['catalog'] = self.project.catalog
4✔
683
        return context
4✔
684

685
    def dispatch(self, *args, **kwargs):
4✔
686
        response = super().dispatch(*args, **kwargs)
4✔
687
        if response.status_code == 200 and kwargs.get('pk'):
4✔
688
            try:
4✔
689
                continuation = Continuation.objects.get(project=self.project, user=self.request.user)
4✔
690
            except Continuation.DoesNotExist:
4✔
691
                continuation = Continuation(project=self.project, user=self.request.user)
4✔
692

693
            continuation.page_id = kwargs.get('pk')
4✔
694
            continuation.save()
4✔
695

696
        return response
4✔
697

698
    def retrieve(self, request, *args, **kwargs):
4✔
699
        page = self.get_object()
4✔
700
        catalog = self.project.catalog
4✔
701
        values = self.project.values.filter(snapshot=None).select_related('attribute', 'option')
4✔
702

703
        sets = compute_sets(values)
4✔
704
        resolved_conditions = resolve_conditions(catalog, values, sets)
4✔
705

706
        # check if the current page meets conditions
707
        if compute_show_page(page, resolved_conditions):
4✔
708
            serializer = self.get_serializer(page)
4✔
709
            return Response(serializer.data)
4✔
710
        else:
711
            # determine the direction of navigation (previous or next)
712
            direction = 'prev' if is_truthy(request.GET.get('back')) else 'next'
4✔
713

714
            # find the next relevant page with from pages and resolved conditions
715
            next_relevant_page = compute_next_relevant_page(page, direction, catalog, resolved_conditions)
4✔
716

717
            if next_relevant_page is not None:
4✔
718
                url = reverse('v1-projects:project-page-detail', args=[self.project.id, next_relevant_page.id])
4✔
719
                return HttpResponseRedirect(url, status=303)
4✔
720

721
            # end of catalog, if no next relevant page is found
722
            return Response({
×
723
                'detail': 'No Page matches the given query.',
724
                'done': True
725
            }, status=status.HTTP_404_NOT_FOUND)
726

727

728
    @action(detail=False, url_path='continue', permission_classes=(HasModelPermission | HasProjectPagePermission, ))
4✔
729
    def get_continue(self, request, pk=None, parent_lookup_project=None):
4✔
730
        if not self.project.catalog.pages:
4✔
731
            return Response({
4✔
732
                'detail': 'No Page matches the given query.',
733
                'done': True
734
            }, status=status.HTTP_404_NOT_FOUND)
735

736
        try:
4✔
737
            continuation = Continuation.objects.get(project=self.project, user=self.request.user)
4✔
738

739
            try:
4✔
740
                page = Page.objects.filter_by_catalog(self.project.catalog).get(id=continuation.page_id)
4✔
741
            except Page.DoesNotExist:
×
742
                page = self.project.catalog.pages[0]
×
743

744
        except Continuation.DoesNotExist:
4✔
745
            page = self.project.catalog.pages[0]
4✔
746

747
        serializer = self.get_serializer(page)
4✔
748
        return Response(serializer.data)
4✔
749

750

751
class MembershipViewSet(ReadOnlyModelViewSet):
4✔
752
    permission_classes = (HasModelPermission | HasProjectsPermission, )
4✔
753
    serializer_class = MembershipSerializer
4✔
754

755
    filter_backends = (DjangoFilterBackend,)
4✔
756
    filterset_fields = (
4✔
757
        'user',
758
        'user__username',
759
        'role'
760
    )
761

762
    def get_queryset(self):
4✔
763
        return Membership.objects.filter_user(self.request.user)
4✔
764

765

766
class IntegrationViewSet(ReadOnlyModelViewSet):
4✔
767
    permission_classes = (HasModelPermission | HasProjectsPermission, )
4✔
768
    serializer_class = IntegrationSerializer
4✔
769

770
    filter_backends = (DjangoFilterBackend, )
4✔
771
    filterset_fields = (
4✔
772
        'project',
773
        'provider_key'
774
    )
775

776
    def get_queryset(self):
4✔
777
        return Integration.objects.filter_user(self.request.user)
4✔
778

779

780
class InviteViewSet(ReadOnlyModelViewSet):
4✔
781
    permission_classes = (HasModelPermission | HasProjectsPermission, )
4✔
782
    serializer_class = InviteSerializer
4✔
783

784
    filter_backends = (DjangoFilterBackend, )
4✔
785
    filterset_fields = (
4✔
786
        'user',
787
        'user__username',
788
        'email',
789
        'role'
790
    )
791

792
    def get_queryset(self):
4✔
793
        return Invite.objects.filter_user(self.request.user)
4✔
794

795
    def get_detail_permission_object(self, obj):
4✔
796
        return obj.project
×
797

798
    @action(detail=False, permission_classes=(IsAuthenticated, ))
4✔
799
    def user(self, request):
4✔
800
        invites = Invite.objects.filter(user=self.request.user)
4✔
801
        serializer = UserInviteSerializer(invites, many=True)
4✔
802
        return Response(serializer.data)
4✔
803

804
class IssueViewSet(ReadOnlyModelViewSet):
4✔
805
    permission_classes = (HasModelPermission | HasProjectsPermission, )
4✔
806
    serializer_class = IssueSerializer
4✔
807

808
    filter_backends = (DjangoFilterBackend, )
4✔
809
    filterset_fields = (
4✔
810
        'task',
811
        'task__uri',
812
        'status'
813
    )
814

815
    def get_queryset(self):
4✔
816
        return Issue.objects.filter_user(self.request.user).prefetch_related('resources')
4✔
817

818

819
class SnapshotViewSet(ReadOnlyModelViewSet):
4✔
820
    permission_classes = (HasModelPermission | HasProjectsPermission, )
4✔
821
    serializer_class = SnapshotSerializer
4✔
822

823
    filter_backends = (DjangoFilterBackend,)
4✔
824
    filterset_fields = (
4✔
825
        'title',
826
        'project'
827
    )
828

829
    def get_queryset(self):
4✔
830
        return Snapshot.objects.filter_user(self.request.user)
4✔
831

832

833
class ValueViewSet(ReadOnlyModelViewSet):
4✔
834
    permission_classes = (HasModelPermission | HasProjectsPermission, )
4✔
835
    serializer_class = ValueSerializer
4✔
836

837
    filter_backends = (
4✔
838
        AttributeFilterBackend,
839
        SnapshotFilterBackend,
840
        OptionFilterBackend,
841
        DjangoFilterBackend,
842
        SearchFilter
843
    )
844
    filterset_fields = (
4✔
845
        'project',
846
        # snapshot is part of SnapshotFilterBackend
847
        # attribute is part of AttributeFilterBackend
848
        'attribute__uri',
849
        'attribute__path',
850
        # option is part of OptionFilterBackend
851
        'option__uri',
852
        'option__uri_path',
853
    )
854

855
    search_fields = ['text', 'project__title', 'snapshot__title']
4✔
856

857
    def get_queryset(self):
4✔
858
        return Value.objects.filter_user(self.request.user).select_related('attribute', 'option')
4✔
859

860
    @action(detail=False, permission_classes=(HasModelPermission | HasProjectsPermission, ))
4✔
861
    def search(self, request):
4✔
862
        queryset = self.filter_queryset(self.get_queryset()).exclude_empty().select_related('project', 'snapshot')
4✔
863

864
        # add a subquery to get the label for the set the value is part in
865
        try:
4✔
866
            set_attribute = int(request.GET.get('set_attribute'))
4✔
867
            set_label_subquery = Subquery(
×
868
                Value.objects.filter(attribute=set_attribute, set_prefix='', set_index=OuterRef('set_index'))
869
                             .values('text')[:1]
870
            )
871
            queryset = queryset.annotate(set_label=set_label_subquery)
×
872
        except (ValueError, TypeError):
4✔
873
            pass
4✔
874

875
        if is_truthy(request.GET.get('collection')):
4✔
876
            # if collection is set (for checkboxes), we first select each distinct set and create a Q object with it
877
            # by doing so we can select an undetermined number of values which belong to an exact number of sets
878
            # given by settings.PROJECT_VALUES_SEARCH_LIMIT
879
            #
880
            # DISTINCT ON is not available on sqlite so we just apply the limit like for all other questions, this
881
            # will display the last set of checked values incomplete
882
            fields = ('project_id', 'snapshot_id', 'attribute_id', 'set_prefix', 'set_index')
4✔
883
            values_list = (
4✔
884
                queryset
885
                    .values(*fields)
886
                    .order_by(*fields)
887
                    .distinct()
888
                    [:settings.PROJECT_VALUES_SEARCH_LIMIT]
889
            )
890

891
            q = Q()
4✔
892
            for values_dict in values_list:
4✔
893
                q |= Q(**values_dict)
×
894

895
            queryset = queryset.filter(q)
4✔
896
        else:
897
            queryset = queryset[:settings.PROJECT_VALUES_SEARCH_LIMIT]
4✔
898

899
        serializer = ValueSearchSerializer(queryset, many=True)
4✔
900
        return Response(serializer.data)
4✔
901

902
    @action(detail=True, permission_classes=(HasModelPermission | HasProjectsPermission, ))
4✔
903
    def file(self, request, pk=None):
4✔
904
        value = self.get_object()
4✔
905

906
        if value.file:
4✔
907
            return return_file_response(value.file.name, value.file_type)
4✔
908

909
        # if it didn't work return 404
910
        raise NotFound()
4✔
911

912

913
class CatalogViewSet(ListModelMixin, GenericViewSet):
4✔
914
    permission_classes = (IsAuthenticated, )
4✔
915

916
    serializer_class = CatalogSerializer
4✔
917

918
    def get_queryset(self):
4✔
919
        return Catalog.objects.filter_current_site() \
4✔
920
                              .filter_group(self.request.user) \
921
                              .order_by('-available', 'order')
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc