From 13a68f3b21d2081d5f48b95a537e922c4ab4135b Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Wed, 19 Oct 2016 16:35:51 +0300
Subject: protocol: some new commands and fixes

---
 .../main/java/com/juick/server/PrivacyQueries.java | 32 ++++++++++++++++++++++
 1 file changed, 32 insertions(+)
 create mode 100644 juick-core/src/main/java/com/juick/server/PrivacyQueries.java

(limited to 'juick-core/src/main/java/com/juick/server/PrivacyQueries.java')

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;
+        }
+    }
+}
-- 
cgit v1.2.3