Improve transaction logic

JelteF · JelteF · commit 062e6040025f · 2025-08-04T10:38:57.000+02:00
diff --git a/pgcommitfest/commitfest/views.py b/pgcommitfest/commitfest/views.py
@@ -49,7 +49,13 @@
 )
 
 
+@transaction.atomic
 def home(request):
+    curs = connection.cursor()
+    # Make sure the that all the queries work on the same snapshot. Needs to be
+    # first in the transaction.atomic decorator.
+    curs.execute("SET TRANSACTION ISOLATION LEVEL REPEATABLE READ")
+
     cfs = CommitFest.relevant_commitfests()
 
     context = {
@@ -58,7 +64,7 @@ def home(request):
         "header_activity_link": "/activity/",
     }
 
-    # Add dashboard content for logged-in users (same as me() view)
+    # Add dashboard content for logged-in users
     if request.user.is_authenticated:
         # Check if user is experienced (has been active for a while)
 
@@ -67,8 +73,6 @@ def home(request):
             days=30
         )
 
-        # Exact same logic as me() view
-
         curs = connection.cursor()
         curs.execute("SET TRANSACTION ISOLATION LEVEL REPEATABLE READ")
 
