From a11541eb58df7336e54b98b6292b7db50369b0f4 Mon Sep 17 00:00:00 2001 From: Philip Sargent Date: Tue, 5 Jul 2022 14:14:03 +0300 Subject: prefetch_related initial attempts --- core/views/scans.py | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'core/views/scans.py') diff --git a/core/views/scans.py b/core/views/scans.py index 4b35377..097c69f 100644 --- a/core/views/scans.py +++ b/core/views/scans.py @@ -58,5 +58,11 @@ def scansingle(request, path, file): def allwallets(request): + '''Returns all the wallets in the system, we would like to use + the Django queryset SQL optimisation https://docs.djangoproject.com/en/3.2/ref/models/querysets/#prefetch-related + to get the related singlescan and survexblock objects but that requires rewriting this to do the query on those, not on + the wallets + ''' manywallets = Wallet.objects.all() + # manywallets = Wallet.objects.all().prefetch_related('singlescan') fails as the link is defined on 'singlescan' not on 'wallet' return render(request, 'manywallets.html', { 'manywallets':manywallets, 'settings': settings }) -- cgit v1.2.3