diff options
| author |  Vitaly Takmazov | 2023-02-03 04:22:50 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2023-02-03 04:22:50 +0300 |
| commit | 73b8c2dc544df207d8c7b9e36d20955ff1d88577 (patch) | |
| tree | f5c25f04ca48157dd1ebe6ff7dbd5992a6de9aaa /src/main/java/com/juick/service/UserServiceImpl.java | |
| parent | 26ef36070cb02bb6522a347d8692b6534d550a7c (diff) | |
Make SQL vendor queries private
Diffstat (limited to 'src/main/java/com/juick/service/UserServiceImpl.java')
| -rw-r--r-- | src/main/java/com/juick/service/UserServiceImpl.java | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/main/java/com/juick/service/UserServiceImpl.java b/src/main/java/com/juick/service/UserServiceImpl.java index 8ed8fd96..57fcd399 100644 --- a/src/main/java/com/juick/service/UserServiceImpl.java +++ b/src/main/java/com/juick/service/UserServiceImpl.java @@ -391,7 +391,7 @@ public class UserServiceImpl extends BaseJdbcService implements UserService { @Transactional(readOnly = true) @Override public boolean isReplyToBL(final User user, final Message reply) { - var replies = getNamedParameterJdbcTemplate().queryForList((omitRecursiveKeyword ? "WITH " : "WITH RECURSIVE ") + "banned(reply_id, user_id) AS (" + + var replies = getNamedParameterJdbcTemplate().queryForList(withRecursive() + " banned(reply_id, user_id) AS (" + "SELECT reply_id, user_id FROM replies " + "WHERE replies.message_id = :mid " + "AND EXISTS (SELECT 1 FROM bl_users b WHERE b.user_id = :uid AND b.bl_user_id = replies.user_id) " + |