From a28f045836c1f0cadbbfcbaf85cb03b7ed643039 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Fri, 22 Dec 2017 12:35:19 +0300
Subject: jdbc: write last reply time to message

---
 .../src/main/java/com/juick/service/MessagesServiceImpl.java           | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'juick-server-jdbc/src/main/java/com/juick')

diff --git a/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java b/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java
index 721bfb4e..f579577f 100644
--- a/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java
+++ b/juick-server-jdbc/src/main/java/com/juick/service/MessagesServiceImpl.java
@@ -190,7 +190,8 @@ public class MessagesServiceImpl extends BaseJdbcService implements MessagesServ
 
         if (ridnew > 0)
             getJdbcTemplate().update(
-                    "UPDATE messages SET replies = replies + 1 WHERE message_id = ?",
+                    "UPDATE messages, (SELECT ts FROM replies) as r " +
+                            "SET messages.replies = messages.replies + 1, messages.updated = r.ts WHERE message_id = ?",
                     mid);
         return ridnew;
     }
-- 
cgit v1.2.3