From aedd466c0caf6a95bfebc2de10371bc944bec2c3 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Fri, 22 Dec 2017 12:50:05 +0300
Subject: jdbc: split updates

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

(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 f579577f..0c53740d 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
@@ -188,11 +188,15 @@ public class MessagesServiceImpl extends BaseJdbcService implements MessagesServ
                 new Object[]{mid, ridnew, uid, rid, attachment, txt},
                 new int[]{Types.INTEGER, Types.SMALLINT, Types.INTEGER, Types.SMALLINT, Types.CHAR, Types.VARCHAR});
 
-        if (ridnew > 0)
+        if (ridnew > 0) {
+            getJdbcTemplate().update(
+                    "UPDATE messages SET replies = replies + 1 WHERE message_id = ?",
+                    mid);
             getJdbcTemplate().update(
                     "UPDATE messages, (SELECT ts FROM replies) as r " +
-                            "SET messages.replies = messages.replies + 1, messages.updated = r.ts WHERE message_id = ?",
+                            "SET messages.updated = r.ts WHERE message_id = ?",
                     mid);
+        }
         return ridnew;
     }
 
-- 
cgit v1.2.3