add APNS feedback component

1 files changed, 4 insertions, 0 deletions

diff --git a/juick-server/src/main/java/com/juick/server/PushQueries.java b/juick-server/src/main/java/com/juick/server/PushQueries.java
index 904b3c0d..5ee3cef3 100644
--- a/juick-server/src/main/java/com/juick/server/PushQueries.java
+++ b/juick-server/src/main/java/com/juick/server/PushQueries.java
@@ -41,4 +41,8 @@ public class PushQueries {
         return sql.queryForList("SELECT token FROM ios INNER JOIN users " +
                 "ON (users.id=ios.user_id) WHERE users.id IN (" + StringUtils.collectionToCommaDelimitedString(uids) + ")", String.class);
     }
+
+    public static boolean deleteAPNSToken(JdbcTemplate sql, String token) {
+        return sql.update("DELETE FROM ios WHERE token=?", token) > 0;
+    }
 }