diff options
author | 2016-10-19 16:35:51 +0300 | |
---|---|---|
committer | 2016-10-19 16:35:51 +0300 | |
commit | 13a68f3b21d2081d5f48b95a537e922c4ab4135b (patch) | |
tree | b03d8bbd8ad63cc1ff95761fd3f8704dd9596be2 /juick-core/src/main/java/com/juick/server/PrivacyQueries.java | |
parent | fabdccb6f9da49058a72ce69674ffcfe51f53002 (diff) |
protocol: some new commands and fixes
Diffstat (limited to 'juick-core/src/main/java/com/juick/server/PrivacyQueries.java')
-rw-r--r-- | juick-core/src/main/java/com/juick/server/PrivacyQueries.java | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/juick-core/src/main/java/com/juick/server/PrivacyQueries.java b/juick-core/src/main/java/com/juick/server/PrivacyQueries.java new file mode 100644 index 00000000..53b13505 --- /dev/null +++ b/juick-core/src/main/java/com/juick/server/PrivacyQueries.java @@ -0,0 +1,32 @@ +package com.juick.server; + +import com.juick.Tag; +import com.juick.User; +import org.springframework.jdbc.core.JdbcTemplate; + +/** + * Created by vitalyster on 19.10.2016. + */ +public class PrivacyQueries { + public enum PrivacyResult { + Removed, Added + } + public static PrivacyResult blacklistUser(JdbcTemplate jdbc, User user, User target) { + int result = jdbc.update("DELETE FROM bl_users WHERE user_id=? AND bl_user_id=?", user.getUID(), target.getUID()); + if (result > 0) { + return PrivacyResult.Removed; + } else { + jdbc.update("INSERT INTO bl_users(user_id,bl_user_id) VALUES (?,?)", user.getUID(), target.getUID()); + return PrivacyResult.Added; + } + } + public static PrivacyResult blacklistTag(JdbcTemplate jdbc, User user, Tag tag) { + int result = jdbc.update("DELETE FROM bl_tags WHERE user_id=? AND tag_id=?", user.getUID(), tag.TID); + if (result > 0) { + return PrivacyResult.Removed; + } else { + jdbc.update("INSERT INTO bl_tags(user_id,tag_id) VALUES (?,?)", user.getUID(), tag.TID); + return PrivacyResult.Added; + } + } +} |