From e1d2efef2d4a99bb76045270ed63f57481436b93 Mon Sep 17 00:00:00 2001 From: Michael Tremer Date: Mon, 9 Oct 2023 16:27:21 +0000 Subject: [PATCH] wiki: Fix fetching any watched pages Signed-off-by: Michael Tremer --- src/backend/wiki.py | 26 +++++++++++++++++++------- 1 file changed, 19 insertions(+), 7 deletions(-) diff --git a/src/backend/wiki.py b/src/backend/wiki.py index 2a5798be..3ce17944 100644 --- a/src/backend/wiki.py +++ b/src/backend/wiki.py @@ -166,13 +166,25 @@ class Wiki(misc.Object): self.db.execute("REFRESH MATERIALIZED VIEW wiki_search_index") def get_watchlist(self, account): - pages = self._get_pages( - "WITH pages AS (SELECT * FROM wiki_current \ - LEFT JOIN wiki ON wiki_current.id = wiki.id) \ - SELECT * FROM wiki_watchlist watchlist \ - LEFT JOIN pages ON watchlist.page = pages.page \ - WHERE watchlist.uid = %s", - account.uid, + pages = self._get_pages(""" + WITH pages AS ( + SELECT + * + FROM + wiki_current + LEFT JOIN + wiki ON wiki_current.id = wiki.id + ) + + SELECT + * + FROM + wiki_watchlist watchlist + JOIN + pages ON watchlist.page = pages.page + WHERE + watchlist.uid = %s + """, account.uid, ) return sorted(pages) -- 2.47.3