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

rdmorganiser / rdmo / 20164756478

12 Dec 2025 11:04AM UTC coverage: 94.814% (+0.02%) from 94.796%
20164756478

Pull #1427

github

web-flow
Merge 0c7b64b9d into 79917de8d
Pull Request #1427: RDMO 2.4.0 🎆

2124 of 2229 branches covered (95.29%)

22688 of 23929 relevant lines covered (94.81%)

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
    filter_tasks_or_views_for_project,
84
    get_contact_message,
85
    get_upload_accept,
86
    send_contact_message,
87
    send_invite_email,
88
)
89

90

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

94

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

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

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

125
    def get_queryset(self):
4✔
126
        queryset = Project.objects.filter_user(self.request.user, self.filter_for_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=False, methods=['GET'], permission_classes=(HasModelPermission | HasProjectsPermission, ))
4✔
144
    def user(self, request, *args, **kwargs):
4✔
145
        self.filter_for_user = True
4✔
146
        return self.list(request, *args, **kwargs)
4✔
147

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

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

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

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

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

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

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

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

191
        return Response(navigation)
4✔
192

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

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

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

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

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

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

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

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

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

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

280
                return Response(options)
4✔
281

282
        except OptionSet.DoesNotExist:
×
283
            pass
×
284

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

408

409
        # add all tasks to project
410
        if self.request.data.get('tasks') is None:
4✔
411
            if not settings.PROJECT_TASKS_SYNC:
4✔
412
                for task in filter_tasks_or_views_for_project(Task, project).filter_availability(self.request.user):
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
                for view in filter_tasks_or_views_for_project(View, project).filter_availability(self.request.user):
4✔
419
                    project.views.add(view)
4✔
420

421

422
class ProjectNestedViewSetMixin(NestedViewSetMixin):
4✔
423

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

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

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

438

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

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

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

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

458

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

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

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

471

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

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

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

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

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

497

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

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

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

513

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

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

522

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

680

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

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

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

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

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

710
        return response
4✔
711

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

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

730

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

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

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

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

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

753

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

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

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

768

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

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

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

782

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

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

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

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

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

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

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

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

821

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

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

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

835

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

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

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

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

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

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

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

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

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

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

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

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

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

915

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

919
    serializer_class = CatalogSerializer
4✔
920

921
    def get_queryset(self):
4✔
922
        queryset = (
4✔
923
            Catalog.objects.filter_current_site().filter_group(self.request.user)
924
        )
925
        availability_subquery = Subquery(
4✔
926
            queryset.filter_availability(self.request.user).values('pk')
927
        )
928
        return (
4✔
929
            queryset.filter(Q(pk__in=availability_subquery) | Q(projects__user=self.request.user))
930
            .order_by('-available', 'order', 'id').distinct()
931
        )
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