From 514273e539bbe580f142ce96d96972667b779b73 Mon Sep 17 00:00:00 2001
From: Matthias Andreas Benkard <code@mail.matthias.benkard.de>
Date: Fri, 24 Jan 2020 19:18:01 +0100
Subject: GET /wiki/{pageName}: Optimize HQL query.

Change-Id: I2e1852aa230fed5dc106629fb9b0aa0d85a8a0cf
---
 src/main/java/eu/mulk/mulkcms2/benki/wiki/WikiResource.java | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

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 @@ public class WikiResource {
   @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();
-- 
cgit v1.2.3