From a0101b9a7566b5296c3490ce3592984976553807 Mon Sep 17 00:00:00 2001
From: Alban Gruin
Date: Sat, 20 Jan 2018 22:28:21 +0100
Subject: On cache les groupes qui n’ont plus de cours La requête est assez
 longue à s’effectuer sur SQLite, mais pas sur PostgreSQL

---
 views.py | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'views.py')

diff --git a/views.py b/views.py
index 10dcfa2..9b53f3a 100644
--- a/views.py
+++ b/views.py
@@ -15,7 +15,7 @@
 
 import datetime
 
-from django.db.models import Count, Max
+from django.db.models import Max
 from django.db.models.functions import ExtractWeek, ExtractYear, Length
 from django.http import Http404
 from django.shortcuts import get_object_or_404, render
@@ -39,11 +39,11 @@ def mention_list(request, year_slug):
 
 def group_list(request, year_slug, timetable_slug):
     timetable = get_object_or_404(Timetable, year__slug=year_slug, slug=timetable_slug)
-    groups = Group.objects.filter(source=timetable.source, hidden=False).order_by("name")
 
     start, _ = get_week(*get_current_week())
     end = start + datetime.timedelta(weeks=4)
 
+    groups = Group.objects.get_relevant_groups(start, source=timetable.source, hidden=False)
     groups_weeks = Course.objects.get_weeks(begin__gte=start, begin__lt=end, groups__in=groups)
 
     for group in groups:
-- 
cgit v1.2.1