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

rdmorganiser / rdmo / 19672034171

25 Nov 2025 01:58PM UTC coverage: 94.784% (-0.01%) from 94.796%
19672034171

Pull #1427

github

web-flow
Merge 499177e07 into 79917de8d
Pull Request #1427: RDMO 2.4.0 🎆

2109 of 2214 branches covered (95.26%)

22533 of 23773 relevant lines covered (94.78%)

3.79 hits per line

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

87.67
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_page,
53
    compute_progress,
54
)
55
from .serializers.v1 import (
4✔
56
    IntegrationSerializer,
57
    InviteSerializer,
58
    IssueSerializer,
59
    MembershipSerializer,
60
    ProjectCopySerializer,
61
    ProjectIntegrationSerializer,
62
    ProjectInviteSerializer,
63
    ProjectInviteUpdateSerializer,
64
    ProjectIssueSerializer,
65
    ProjectMembershipSerializer,
66
    ProjectMembershipUpdateSerializer,
67
    ProjectSerializer,
68
    ProjectSnapshotSerializer,
69
    ProjectValueSerializer,
70
    ProjectVisibilitySerializer,
71
    SnapshotSerializer,
72
    UserInviteSerializer,
73
    ValueSearchSerializer,
74
    ValueSerializer,
75
)
76
from .serializers.v1.overview import CatalogSerializer, ProjectOverviewSerializer
4✔
77
from .serializers.v1.page import PageSerializer
4✔
78
from .utils import (
4✔
79
    check_conditions,
80
    check_options,
81
    compute_set_prefix_from_set_value,
82
    copy_project,
83
    get_contact_message,
84
    get_upload_accept,
85
    send_contact_message,
86
    send_invite_email,
87
)
88

89

90
class ProjectPagination(PageNumberPagination):
4✔
91
    page_size = settings.PROJECT_TABLE_PAGE_SIZE
4✔
92

93

94
class ProjectViewSet(ModelViewSet):
4✔
95
    permission_classes = (HasModelPermission | HasProjectsPermission, )
4✔
96
    serializer_class = ProjectSerializer
4✔
97
    pagination_class = ProjectPagination
4✔
98

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

122
    filter_for_user = False  # flag for get_queryset to return only projects like for a regular user
4✔
123

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

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

140
        return queryset
4✔
141

142
    @action(detail=False, methods=['GET'], permission_classes=(HasModelPermission | HasProjectsPermission, ))
4✔
143
    def user(self, request, *args, **kwargs):
4✔
144
        self.filter_for_user = True
4✔
145
        return self.list(request, *args, **kwargs)
4✔
146

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

154
        # update instance
155
        for key, value in serializer.validated_data.items():
4✔
156
            setattr(instance, key, value)
4✔
157

158
        site = get_current_site(self.request)
4✔
159
        owners = [self.request.user]
4✔
160
        project_copy = copy_project(instance, site, owners)
4✔
161

162
        serializer = self.get_serializer(project_copy)
4✔
163
        headers = self.get_success_headers(serializer.data)
4✔
164
        return Response(serializer.data, status=status.HTTP_201_CREATED, headers=headers)
4✔
165

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

172
    @action(detail=True, url_path=r'navigation(?:/(?P<section_id>\d+))?',
4✔
173
            permission_classes=(HasModelPermission | HasProjectPermission, ))
174
    def navigation(self, request, pk=None, section_id=None):
4✔
175
        project = self.get_object()
4✔
176
        project.catalog.prefetch_elements()
4✔
177

178
        # if a section is provided, check if it actually exists in the catalog
179
        if section_id is None:
4✔
180
            section = None
4✔
181
        else:
182
            try:
4✔
183
                section = project.catalog.sections.get(pk=section_id)
4✔
184
            except ObjectDoesNotExist as e:
×
185
                raise NotFound() from e
×
186

187
        # compute navigation from the answer tree
188
        navigation = compute_navigation(project, section)
4✔
189

190
        return Response(navigation)
4✔
191

192
    @action(detail=True, permission_classes=(HasModelPermission | HasProjectPermission, ))
4✔
193
    def resolve(self, request, pk=None):
4✔
194
        snapshot_id = request.GET.get('snapshot')
4✔
195
        set_prefix = request.GET.get('set_prefix')
4✔
196
        set_index = request.GET.get('set_index')
4✔
197

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

200
        page_id = request.GET.get('page')
4✔
201
        if page_id:
4✔
202
            try:
×
203
                page = Page.objects.get(id=page_id)
×
204
                conditions = page.conditions.select_related('source', 'target_option')
×
205
                if check_conditions(conditions, values, set_prefix, set_index):
×
206
                    return Response({'result': True})
×
207
            except Page.DoesNotExist:
×
208
                pass
×
209

210
        questionset_id = request.GET.get('questionset')
4✔
211
        if questionset_id:
4✔
212
            try:
×
213
                questionset = QuestionSet.objects.get(id=questionset_id)
×
214
                conditions = questionset.conditions.select_related('source', 'target_option')
×
215
                if check_conditions(conditions, values, set_prefix, set_index):
×
216
                    return Response({'result': True})
×
217
            except QuestionSet.DoesNotExist:
×
218
                pass
×
219

220
        question_id = request.GET.get('question')
4✔
221
        if question_id:
4✔
222
            try:
×
223
                question = Question.objects.get(id=question_id)
×
224
                conditions = question.conditions.select_related('source', 'target_option')
×
225
                if check_conditions(conditions, values, set_prefix, set_index):
×
226
                    return Response({'result': True})
×
227
            except Question.DoesNotExist:
×
228
                pass
×
229

230
        optionset_id = request.GET.get('optionset')
4✔
231
        if optionset_id:
4✔
232
            try:
×
233
                optionset = OptionSet.objects.get(id=optionset_id)
×
234
                conditions = optionset.conditions.select_related('source', 'target_option')
×
235
                if check_conditions(conditions, values, set_prefix, set_index):
×
236
                    return Response({'result': True})
×
237
            except OptionSet.DoesNotExist:
×
238
                pass
×
239

240
        condition_id = request.GET.get('condition')
4✔
241
        if condition_id:
4✔
242
            try:
4✔
243
                condition = Condition.objects.select_related('source', 'target_option').get(id=condition_id)
4✔
244
                if check_conditions([condition], values, set_prefix, set_index):
4✔
245
                    return Response({'result': True})
4✔
246
            except Condition.DoesNotExist:
×
247
                pass
×
248

249
        return Response({'result': False})
4✔
250

251
    @action(detail=True, permission_classes=(HasModelPermission | HasProjectPermission, ))
4✔
252
    def options(self, request, pk=None):
4✔
253
        project = self.get_object()
4✔
254
        try:
4✔
255
            try:
4✔
256
                optionset_id = request.GET.get('optionset')
4✔
257
                optionset = OptionSet.objects.get(pk=optionset_id)
4✔
258
            except (ValueError, OptionSet.DoesNotExist) as e:
×
259
                raise NotFound() from e
×
260

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

279
                return Response(options)
4✔
280

281
        except OptionSet.DoesNotExist:
×
282
            pass
×
283

284
        # if it didn't work return 404
285
        raise NotFound()
×
286

287
    @action(detail=True, permission_classes=(HasModelPermission | HasProjectPermission, ))
4✔
288
    def answers(self, request, pk=None):
4✔
289
        project = self.get_object()
×
290
        project.catalog.prefetch_elements()
×
291
        return Response(project.get_answer_tree(verbose=request.GET.getlist('verbose')))
×
292

293
    @action(detail=True, methods=['get', 'post'],
4✔
294
            permission_classes=(HasProjectProgressModelPermission | HasProjectProgressObjectPermission, ))
295
    def progress(self, request, pk=None):
4✔
296
        project = self.get_object()
4✔
297

298
        if request.method == 'POST' or project.progress_count is None or project.progress_total is None:
4✔
299
            project.catalog.prefetch_elements()
4✔
300

301
            # compute the progress, but store it only, if it has changed
302
            progress_count, progress_total = compute_progress(project)
4✔
303
            if progress_count != project.progress_count or progress_total != project.progress_total:
4✔
304
                project.progress_count, project.progress_total = progress_count, progress_total
4✔
305
                project.save()
4✔
306

307
        try:
4✔
308
            ratio = project.progress_count / project.progress_total
4✔
309
        except ZeroDivisionError:
×
310
            ratio = 0
×
311

312
        return Response({
4✔
313
            'count': project.progress_count,
314
            'total': project.progress_total,
315
            'ratio': ratio
316
        })
317

318
    @action(detail=True, methods=['get', 'post', 'delete'],
4✔
319
            permission_classes=(HasProjectVisibilityModelPermission | HasProjectVisibilityObjectPermission, ))
320
    def visibility(self, request, pk=None):
4✔
321
        project = self.get_object()
4✔
322

323
        try:
4✔
324
            instance = project.visibility
4✔
325
        except Visibility.DoesNotExist:
4✔
326
            instance = None
4✔
327

328
        if request.method == 'POST':
4✔
329
            data = {'project': project.id}
4✔
330

331
            if settings.MULTISITE:
4✔
332
                if request.user.has_perm('projects.change_visibility'):
4✔
333
                    data['sites'] = request.data.getlist('sites', [])
4✔
334
                else:
335
                    data['sites'] = list({
4✔
336
                        *[site.id for site in instance.sites.all()],
337
                        get_current_site(self.request).id
338
                    })
339

340
            if settings.GROUPS:
4✔
341
                data['groups'] = request.data.getlist('groups', [])
4✔
342

343
            serializer = ProjectVisibilitySerializer(instance, data=data)
4✔
344
            serializer.is_valid(raise_exception=True)
4✔
345
            serializer.save()
4✔
346
            return Response(serializer.data)
4✔
347

348
        elif request.method == 'DELETE':
4✔
349
            if instance is not None:
4✔
350
                if settings.MULTISITE and not request.user.has_perm('projects.delete_visibility'):
4✔
351
                    instance.remove_site(get_current_site(self.request))
4✔
352
                else:
353
                    instance.delete()
4✔
354

355
                return Response(status=status.HTTP_204_NO_CONTENT)
4✔
356
        else:
357
            if instance is not None:
4✔
358
                serializer = ProjectVisibilitySerializer(instance)
4✔
359
                return Response(serializer.data)
4✔
360

361
        # if nothing worked, raise 404
362
        raise Http404
4✔
363

364
    @action(detail=True, methods=['get', 'post'],
4✔
365
            permission_classes=(HasModelPermission | HasProjectPermission, ))
366
    def contact(self, request, pk):
4✔
367
        if settings.PROJECT_CONTACT:
4✔
368
            project = self.get_object()
4✔
369
            if request.method == 'POST':
4✔
370
                subject = request.data.get('subject')
4✔
371
                message = request.data.get('message')
4✔
372

373
                if subject and message:
4✔
374
                    send_contact_message(request, subject, message)
4✔
375
                    return Response(status=status.HTTP_204_NO_CONTENT)
4✔
376
                else:
377
                    raise ValidationError({
4✔
378
                        'subject': [_('This field may not be blank.')] if not subject else [],
379
                        'message': [_('This field may not be blank.')] if not message else []
380
                    })
381
            else:
382
                project.catalog.prefetch_elements()
4✔
383
                return Response(get_contact_message(request, project))
4✔
384
        else:
385
            raise Http404
×
386

387
    @action(detail=False, url_path='upload-accept', permission_classes=(IsAuthenticated, ))
4✔
388
    def upload_accept(self, request):
4✔
389
        return Response(get_upload_accept())
4✔
390

391
    @action(detail=False, permission_classes=(IsAuthenticated, ))
4✔
392
    def imports(self, request):
4✔
393
        return Response([{
4✔
394
            'key': key,
395
            'label': label,
396
            'class_name': class_name,
397
            'href': reverse('project_create_import', args=[key])
398
        } for key, label, class_name in settings.PROJECT_IMPORTS if key in settings.PROJECT_IMPORTS_LIST] )
399

400
    def perform_create(self, serializer):
4✔
401
        project = serializer.save(site=get_current_site(self.request))
4✔
402

403
        # add current user as owner
404
        membership = Membership(project=project, user=self.request.user, role='owner')
4✔
405
        membership.save()
4✔
406

407

408
        # add all tasks to project
409
        if self.request.data.get('tasks') is None:
4✔
410
            if not settings.PROJECT_TASKS_SYNC:
4✔
411
                tasks = Task.objects.filter_for_project(project).filter_availability(self.request.user)
4✔
412
                for task in tasks:
4✔
413
                    project.tasks.add(task)
4✔
414

415
        if self.request.data.get('views') is None:
4✔
416
            # add all views to project
417
            if not settings.PROJECT_VIEWS_SYNC:
4✔
418
                views = View.objects.filter_for_project(project).filter_availability(self.request.user)
4✔
419
                for view in views:
4✔
420
                    project.views.add(view)
4✔
421

422

423
class ProjectNestedViewSetMixin(NestedViewSetMixin):
4✔
424

425
    def initial(self, request, *args, **kwargs):
4✔
426
        self.project = self.get_project_from_parent_viewset()
4✔
427
        super().initial(request, *args, **kwargs)
4✔
428

429
    def get_project_from_parent_viewset(self):
4✔
430
        try:
4✔
431
            return Project.objects.filter_user(self.request.user).get(pk=self.get_parents_query_dict().get('project'))
4✔
432
        except Project.DoesNotExist as e:
4✔
433
            raise Http404 from e
4✔
434

435
    def perform_create(self, serializer):
4✔
436
        # this call provides the nested serializers with the project
437
        serializer.save(project=self.project)
4✔
438

439

440
class ProjectMembershipViewSet(ProjectNestedViewSetMixin, ModelViewSet):
4✔
441
    permission_classes = (HasModelPermission | HasProjectPermission, )
4✔
442

443
    filter_backends = (DjangoFilterBackend, )
4✔
444
    filterset_fields = (
4✔
445
        'user',
446
        'user__username',
447
        'role'
448
    )
449

450
    def get_queryset(self):
4✔
451
        return Membership.objects.filter(project=self.project)
4✔
452

453
    def get_serializer_class(self):
4✔
454
        if self.action == 'update':
4✔
455
            return ProjectMembershipUpdateSerializer
4✔
456
        else:
457
            return ProjectMembershipSerializer
4✔
458

459

460
class ProjectIntegrationViewSet(ProjectNestedViewSetMixin, ModelViewSet):
4✔
461
    permission_classes = (HasModelPermission | HasProjectPermission, )
4✔
462
    serializer_class = ProjectIntegrationSerializer
4✔
463

464
    filter_backends = (DjangoFilterBackend, )
4✔
465
    filterset_fields = (
4✔
466
        'provider_key',
467
    )
468

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

472

473
class ProjectInviteViewSet(ProjectNestedViewSetMixin, ModelViewSet):
4✔
474
    permission_classes = (HasModelPermission | HasProjectPermission, )
4✔
475

476
    filter_backends = (DjangoFilterBackend, )
4✔
477
    filterset_fields = (
4✔
478
        'user',
479
        'user__username',
480
        'email',
481
        'role'
482
    )
483

484
    def get_queryset(self):
4✔
485
        return Invite.objects.filter(project=self.project)
4✔
486

487
    def get_serializer_class(self):
4✔
488
        if self.action == 'update':
4✔
489
            return ProjectInviteUpdateSerializer
4✔
490
        else:
491
            return ProjectInviteSerializer
4✔
492

493
    def perform_create(self, serializer):
4✔
494
        super().perform_create(serializer)
4✔
495
        if settings.PROJECT_SEND_INVITE:
4✔
496
            send_invite_email(self.request, serializer.instance)
4✔
497

498

499
class ProjectIssueViewSet(ProjectNestedViewSetMixin, ListModelMixin, RetrieveModelMixin,
4✔
500
                          UpdateModelMixin, GenericViewSet):
501
    permission_classes = (HasModelPermission | HasProjectPermission, )
4✔
502
    serializer_class = ProjectIssueSerializer
4✔
503

504
    filter_backends = (DjangoFilterBackend, )
4✔
505
    filterset_fields = (
4✔
506
        'task',
507
        'task__uri',
508
        'status'
509
    )
510

511
    def get_queryset(self):
4✔
512
        return Issue.objects.filter(project=self.project).prefetch_related('resources')
4✔
513

514

515
class ProjectSnapshotViewSet(ProjectNestedViewSetMixin, CreateModelMixin, RetrieveModelMixin,
4✔
516
                             UpdateModelMixin, ListModelMixin, GenericViewSet):
517
    permission_classes = (HasModelPermission | HasProjectPermission, )
4✔
518
    serializer_class = ProjectSnapshotSerializer
4✔
519

520
    def get_queryset(self):
4✔
521
        return self.project.snapshots.all()
4✔
522

523

524
class ProjectValueViewSet(ProjectNestedViewSetMixin, ModelViewSet):
4✔
525
    permission_classes = (HasModelPermission | HasProjectPermission, )
4✔
526
    serializer_class = ProjectValueSerializer
4✔
527

528
    filter_backends = (AttributeFilterBackend, DjangoFilterBackend)
4✔
529
    filterset_fields = (
4✔
530
        # attribute is part of AttributeFilterBackend
531
        'attribute__uri',
532
        'option',
533
        'option__uri',
534
    )
535

536
    def get_queryset(self):
4✔
537
        return self.project.values.filter(snapshot=None).select_related('attribute', 'option')
4✔
538

539
    @action(detail=False, methods=['POST'], url_path='set',
4✔
540
            permission_classes=(HasModelPermission | HasProjectPermission, ))
541
    def copy_set(self, request, parent_lookup_project, pk=None):
4✔
542
        # copy all values for questions in questionset collections with the attribute
543
        # for this value and the same set_prefix and set_index
544

545
        # obtain the id of the set value for the set we want to copy
546
        try:
4✔
547
            copy_value_id = int(request.data.pop('copy_set_value'))
4✔
548
        except KeyError as e:
4✔
549
            raise ValidationError({
4✔
550
                'copy_set_value': [_('This field may not be blank.')]
551
            }) from e
552
        except ValueError as e:
4✔
553
            raise NotFound from e
4✔
554

555
        # look for this value in the database, using the users permissions, and
556
        # collect all values for this set and all descendants
557
        try:
4✔
558
            copy_value = Value.objects.filter_user(self.request.user).get(id=copy_value_id)
4✔
559
            copy_values = Value.objects.filter_user(self.request.user).filter_set(copy_value)
4✔
560
        except Value.DoesNotExist as e:
4✔
561
            raise NotFound from e
4✔
562

563
        # init list of values to return
564
        response_values = []
4✔
565

566
        set_value_id = request.data.get('id')
4✔
567
        if set_value_id:
4✔
568
            # if an id is given in the post request, this is an import
569
            try:
4✔
570
                # look for the set value for the set we want to import into
571
                set_value = Value.objects.filter_user(self.request.user).get(id=set_value_id)
4✔
572

573
                # collect all non-empty values for this set and all descendants and convert
574
                # them to a list to compare them later to the new values
575
                set_values = Value.objects.filter_user(self.request.user).filter_set(set_value)
4✔
576
                set_values_list = set_values.exclude_empty().values_list('attribute', 'set_prefix', 'set_index')
4✔
577
                set_empty_values_list = set_values.filter_empty().values_list(
4✔
578
                    'attribute', 'set_prefix', 'set_index', 'collection_index'
579
                )
580
            except Value.DoesNotExist as e:
×
581
                raise NotFound from e
×
582
        else:
583
            # otherwise, we want to create a new set and need to create a new set value
584
            # de-serialize the posted new set value and save it, use the ValueSerializer
585
            # instead of ProjectValueSerializer, since the latter does not include project
586
            set_value_serializer = ValueSerializer(data={
4✔
587
                'project': parent_lookup_project,
588
                **request.data
589
            })
590
            set_value_serializer.is_valid(raise_exception=True)
4✔
591
            set_value = set_value_serializer.save()
4✔
592

593
            set_values = Value.objects.none()
4✔
594
            set_values_list = set_empty_values_list = []
4✔
595

596
            # add the new set value to response_values
597
            response_values.append(set_value_serializer.data)
4✔
598

599
        # create new values for the new set
600
        new_values = []
4✔
601
        updated_values = []
4✔
602
        for value in copy_values:
4✔
603
            value.id = None
4✔
604
            value.project = set_value.project
4✔
605
            value.snapshot = None
4✔
606
            if value.set_prefix == set_value.set_prefix:
4✔
607
                value.set_index = set_value.set_index
4✔
608
            else:
609
                value.set_prefix = compute_set_prefix_from_set_value(set_value, value)
4✔
610

611
            # skip this value if value.option does not match the optionsets of it's question
612
            if not check_options(self.project, value):
4✔
613
                continue
4✔
614

615
            # check if the value already exists, we do not consider collection_index
616
            # since we do not want to import e.g. into partially filled checkboxes
617
            if (value.attribute_id, value.set_prefix, value.set_index) in set_values_list:
4✔
618
                # do not overwrite existing values
619
                pass
×
620
            elif (value.attribute_id, value.set_prefix,
4✔
621
                  value.set_index, value.collection_index) in set_empty_values_list:
622
                # update empty values
623
                updated_value = set_values.get(attribute_id=value.attribute_id, set_prefix=value.set_prefix,
×
624
                                               set_index=value.set_index, collection_index=value.collection_index)
625
                updated_value.text = value.text
×
626
                updated_value.option = value.option
×
627
                updated_value.external_id = value.external_id
×
628
                updated_value.save()
×
629

630
                updated_values.append(updated_value)
×
631
            else:
632
                new_values.append(value)
4✔
633

634
        # bulk create the new values
635
        created_values = Value.objects.bulk_create(new_values)
4✔
636
        response_values += [ValueSerializer(instance=value).data for value in created_values]
4✔
637
        response_values += [ValueSerializer(instance=value).data for value in updated_values]
4✔
638

639
        # return all new values
640
        return Response(response_values, status=status.HTTP_201_CREATED)
4✔
641

642
    @action(detail=True, methods=['DELETE'], url_path='set',
4✔
643
            permission_classes=(HasModelPermission | HasProjectPermission, ))
644
    def delete_set(self, request, parent_lookup_project, pk=None):
4✔
645
        # delete all values for questions in questionset collections with the attribute
646
        # for this value and the same set_prefix and set_index
647
        set_value = self.get_object()
4✔
648
        set_value.delete()
4✔
649

650
        # collect all values for this set and all descendants and delete them
651
        values = self.get_queryset().filter_set(set_value)
4✔
652
        values.delete()
4✔
653

654
        return Response(status=status.HTTP_204_NO_CONTENT)
4✔
655

656
    @action(detail=True, methods=['GET', 'POST'],
4✔
657
            permission_classes=(HasModelPermission | HasProjectPermission, ))
658
    def file(self, request, parent_lookup_project, pk=None):
4✔
659
        value = self.get_object()
4✔
660

661
        if request.method == 'POST':
4✔
662
            value.file = request.FILES.get('file')
4✔
663

664
            # check if the project is reached
665
            if value.file and value.file.size + value.project.file_size > human2bytes(settings.PROJECT_FILE_QUOTA):
4✔
666
                raise serializers.ValidationError({
×
667
                    'value': [_('You reached the file quota for this project.')]
668
                })
669

670
            value.save()
4✔
671
            serializer = self.get_serializer(value)
4✔
672
            return Response(serializer.data)
4✔
673

674
        else:
675
            if value.file:
4✔
676
                return return_file_response(value.file.name, value.file_type)
4✔
677

678
        # if it didn't work return 404
679
        raise NotFound()
4✔
680

681

682
class ProjectPageViewSet(ProjectNestedViewSetMixin, RetrieveModelMixin, GenericViewSet):
4✔
683
    permission_classes = (HasModelPermission | HasProjectPagePermission, )
4✔
684
    serializer_class = PageSerializer
4✔
685

686
    def get_queryset(self):
4✔
687
        self.project.catalog.prefetch_elements()
4✔
688
        page = Page.objects.filter_by_catalog(self.project.catalog).prefetch_related(
4✔
689
            *Page.prefetch_lookups,
690
            'page_questions__question__optionsets__optionset_options__option',
691
            'page_questionsets__questionset__questionset_questions__question__optionsets__optionset_options__option',
692
        )
693
        return page
4✔
694

695
    def get_serializer_context(self):
4✔
696
        context = super().get_serializer_context()
4✔
697
        context['catalog'] = self.project.catalog
4✔
698
        return context
4✔
699

700
    def dispatch(self, *args, **kwargs):
4✔
701
        response = super().dispatch(*args, **kwargs)
4✔
702
        if response.status_code == 200 and kwargs.get('pk'):
4✔
703
            try:
4✔
704
                continuation = Continuation.objects.get(project=self.project, user=self.request.user)
4✔
705
            except Continuation.DoesNotExist:
4✔
706
                continuation = Continuation(project=self.project, user=self.request.user)
4✔
707

708
            continuation.page_id = kwargs.get('pk')
4✔
709
            continuation.save()
4✔
710

711
        return response
4✔
712

713
    def retrieve(self, request, *args, **kwargs):
4✔
714
        page = self.get_object()
4✔
715
        direction = 'prev' if is_truthy(request.GET.get('back')) else 'next'
4✔
716
        computed_page_id = compute_page(self.project, page, direction)
4✔
717

718
        if computed_page_id == page.id:
4✔
719
            serializer = self.get_serializer(page)
4✔
720
            return Response(serializer.data)
4✔
721
        elif computed_page_id is not None:
4✔
722
            url = reverse('v1-projects:project-page-detail', args=[self.project.id, computed_page_id])
4✔
723
            return HttpResponseRedirect(url, status=303)
4✔
724
        else:
725
            # if no page was found, we are probably at the end of the catalog
726
            return Response({
×
727
                'detail': 'No Page matches the given query.',
728
                'done': True
729
            }, status=status.HTTP_404_NOT_FOUND)
730

731

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

740
        try:
4✔
741
            continuation = Continuation.objects.get(project=self.project, user=self.request.user)
4✔
742

743
            try:
4✔
744
                page = Page.objects.filter_by_catalog(self.project.catalog).get(id=continuation.page_id)
4✔
745
            except Page.DoesNotExist:
×
746
                page = self.project.catalog.pages[0]
×
747

748
        except Continuation.DoesNotExist:
4✔
749
            page = self.project.catalog.pages[0]
4✔
750

751
        serializer = self.get_serializer(page)
4✔
752
        return Response(serializer.data)
4✔
753

754

755
class MembershipViewSet(ReadOnlyModelViewSet):
4✔
756
    permission_classes = (HasModelPermission | HasProjectsPermission, )
4✔
757
    serializer_class = MembershipSerializer
4✔
758

759
    filter_backends = (DjangoFilterBackend,)
4✔
760
    filterset_fields = (
4✔
761
        'user',
762
        'user__username',
763
        'role'
764
    )
765

766
    def get_queryset(self):
4✔
767
        return Membership.objects.filter_user(self.request.user)
4✔
768

769

770
class IntegrationViewSet(ReadOnlyModelViewSet):
4✔
771
    permission_classes = (HasModelPermission | HasProjectsPermission, )
4✔
772
    serializer_class = IntegrationSerializer
4✔
773

774
    filter_backends = (DjangoFilterBackend, )
4✔
775
    filterset_fields = (
4✔
776
        'project',
777
        'provider_key'
778
    )
779

780
    def get_queryset(self):
4✔
781
        return Integration.objects.filter_user(self.request.user)
4✔
782

783

784
class InviteViewSet(ReadOnlyModelViewSet):
4✔
785
    permission_classes = (HasModelPermission | HasProjectsPermission, )
4✔
786
    serializer_class = InviteSerializer
4✔
787

788
    filter_backends = (DjangoFilterBackend, )
4✔
789
    filterset_fields = (
4✔
790
        'user',
791
        'user__username',
792
        'email',
793
        'role'
794
    )
795

796
    def get_queryset(self):
4✔
797
        return Invite.objects.filter_user(self.request.user)
4✔
798

799
    def get_detail_permission_object(self, obj):
4✔
800
        return obj.project
×
801

802
    @action(detail=False, permission_classes=(IsAuthenticated, ))
4✔
803
    def user(self, request):
4✔
804
        invites = Invite.objects.filter(user=self.request.user)
4✔
805
        serializer = UserInviteSerializer(invites, many=True)
4✔
806
        return Response(serializer.data)
4✔
807

808
class IssueViewSet(ReadOnlyModelViewSet):
4✔
809
    permission_classes = (HasModelPermission | HasProjectsPermission, )
4✔
810
    serializer_class = IssueSerializer
4✔
811

812
    filter_backends = (DjangoFilterBackend, )
4✔
813
    filterset_fields = (
4✔
814
        'task',
815
        'task__uri',
816
        'status'
817
    )
818

819
    def get_queryset(self):
4✔
820
        return Issue.objects.filter_user(self.request.user).prefetch_related('resources')
4✔
821

822

823
class SnapshotViewSet(ReadOnlyModelViewSet):
4✔
824
    permission_classes = (HasModelPermission | HasProjectsPermission, )
4✔
825
    serializer_class = SnapshotSerializer
4✔
826

827
    filter_backends = (DjangoFilterBackend,)
4✔
828
    filterset_fields = (
4✔
829
        'title',
830
        'project'
831
    )
832

833
    def get_queryset(self):
4✔
834
        return Snapshot.objects.filter_user(self.request.user)
4✔
835

836

837
class ValueViewSet(ReadOnlyModelViewSet):
4✔
838
    permission_classes = (HasModelPermission | HasProjectsPermission, )
4✔
839
    serializer_class = ValueSerializer
4✔
840

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

859
    search_fields = ['text', 'project__title', 'snapshot__title']
4✔
860

861
    def get_queryset(self):
4✔
862
        return Value.objects.filter_user(self.request.user).select_related('attribute', 'option')
4✔
863

864
    @action(detail=False, permission_classes=(HasModelPermission | HasProjectsPermission, ))
4✔
865
    def search(self, request):
4✔
866
        queryset = self.filter_queryset(self.get_queryset()).exclude_empty().select_related('project', 'snapshot')
4✔
867

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

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

895
            q = Q()
4✔
896
            for values_dict in values_list:
4✔
897
                q |= Q(**values_dict)
×
898

899
            queryset = queryset.filter(q).order_by(*Value._meta.ordering)
4✔
900
        else:
901
            queryset = queryset.order_by(*Value._meta.ordering)[:settings.PROJECT_VALUES_SEARCH_LIMIT]
4✔
902

903
        serializer = ValueSearchSerializer(queryset, many=True)
4✔
904
        return Response(serializer.data)
4✔
905

906
    @action(detail=True, permission_classes=(HasModelPermission | HasProjectsPermission, ))
4✔
907
    def file(self, request, pk=None):
4✔
908
        value = self.get_object()
4✔
909

910
        if value.file:
4✔
911
            return return_file_response(value.file.name, value.file_type)
4✔
912

913
        # if it didn't work return 404
914
        raise NotFound()
4✔
915

916

917
class CatalogViewSet(ListModelMixin, GenericViewSet):
4✔
918
    permission_classes = (IsAuthenticated, )
4✔
919

920
    serializer_class = CatalogSerializer
4✔
921

922
    def get_queryset(self):
4✔
923
        return Catalog.objects.filter_current_site() \
4✔
924
                              .filter_group(self.request.user) \
925
                              .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