commit 514273e539bbe580f142ce96d96972667b779b73
author Matthias Andreas Benkard <code@mail.matthias.benkard.de> Fri Jan 24 19:18:01 2020 +0100
committer Matthias Andreas Benkard <code@mail.matthias.benkard.de> Fri Jan 24 19:18:01 2020 +0100
tree 31d8aaf42edf8bddac7fe76e28600b6de0e25f85
parent 9222efa007b8790852dc761d09367863bf56ddf3

GET /wiki/{pageName}: Optimize HQL query.

Change-Id: I2e1852aa230fed5dc106629fb9b0aa0d85a8a0cf

src/main/java/eu/mulk/mulkcms2/benki/wiki/WikiResource.java

diff --git a/src/main/java/eu/mulk/mulkcms2/benki/wiki/WikiResource.java b/src/main/java/eu/mulk/mulkcms2/benki/wiki/WikiResource.java
index 8f25254..ebed4e2 100644
--- a/src/main/java/eu/mulk/mulkcms2/benki/wiki/WikiResource.java
+++ b/src/main/java/eu/mulk/mulkcms2/benki/wiki/WikiResource.java
@@ -44,7 +44,12 @@
   @Produces(TEXT_HTML)
   public TemplateInstance getPage(@PathParam("pageName") String pageName) {
     Optional<WikiPageRevision> maybePage =
-        WikiPageRevision.find("title = ?1", Sort.by("date").descending(), pageName)
+        WikiPageRevision.find(
+                "from WikiPageRevision rev"
+                    + " join fetch rev.author"
+                    + " where rev.title = ?1",
+                Sort.by("date").descending(),
+                pageName)
             .firstResultOptional();
     if (maybePage.isEmpty()) {
       throw new NotFoundException();