fixed query to include patches where user is either a reviewer or has subscribed to

destrex271 · destrex271 · commit c8482b52f20d · 2025-03-05T23:58:54.000+05:30
diff --git a/pgcommitfest/commitfest/views.py b/pgcommitfest/commitfest/views.py
@@ -89,7 +89,20 @@ def me(request):
     # Get stats related to user for current commitfest
     curs = connection.cursor()
     curs.execute(
-        "SELECT ps.status, ps.statusstring, count(*) FROM commitfest_patchoncommitfest poc INNER JOIN commitfest_patchstatus ps ON ps.status=poc.status INNER JOIN commitfest_patch_authors pa ON pa.patch_id=poc.patch_id WHERE commitfest_id=%(id)s AND pa.user_id=%(user_id)s GROUP BY ps.status ORDER BY ps.sortkey",
+        '''SELECT
+            ps.status, ps.statusstring, count(*)
+        FROM commitfest_patchoncommitfest poc
+        INNER JOIN commitfest_patchstatus ps ON ps.status=poc.status
+        LEFT JOIN commitfest_patch_authors pa ON pa.patch_id=poc.patch_id
+        LEFT JOIN commitfest_patch_reviewers pr ON pr.patch_id=poc.patch_id
+        LEFT JOIN commitfest_patch_subscribers psubs ON psubs.patch_id=poc.patch_id
+        WHERE commitfest_id=%(id)s 
+        AND (
+            pa.user_id=%(user_id)s 
+            OR pr.user_id=%(user_id)s
+            OR psubs.user_id=%(user_id)s
+        )
+        GROUP BY ps.status ORDER BY ps.sortkey''',
         {
             "id": cf.id,
             "user_id": request.user.id
