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') 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