diff options
author | 2016-07-11 10:16:36 +0300 | |
---|---|---|
committer | 2016-07-11 10:16:36 +0300 | |
commit | 7eb3b141e5e4e719e1ef77ea06b6bac7610ae913 (patch) | |
tree | 1573abb9b47f5001053ed07b8ba9164c8fc5a188 /juick-core/src/main/java/com/juick/server/PushQueries.java | |
parent | f0a60dd95eff153c022bca0c71fed39b901dd547 (diff) |
cleanup sql
Diffstat (limited to 'juick-core/src/main/java/com/juick/server/PushQueries.java')
-rw-r--r-- | juick-core/src/main/java/com/juick/server/PushQueries.java | 14 |
1 files changed, 0 insertions, 14 deletions
diff --git a/juick-core/src/main/java/com/juick/server/PushQueries.java b/juick-core/src/main/java/com/juick/server/PushQueries.java index 54528993..f4c98fcf 100644 --- a/juick-core/src/main/java/com/juick/server/PushQueries.java +++ b/juick-core/src/main/java/com/juick/server/PushQueries.java @@ -26,11 +26,6 @@ public class PushQueries { } - public static List<String> getAndroidSubscribers(JdbcTemplate sql, int uid) { - return sql.queryForList("SELECT regid FROM android INNER JOIN subscr_users " + - "ON (subscr_users.user_id=? AND android.user_id=subscr_users.suser_id)", String.class, uid); - } - public static List<String> getAndroidTokens(JdbcTemplate sql, List<Integer> uids) { return sql.queryForList("SELECT regid FROM android INNER JOIN users " + "ON (users.id=android.user_id) WHERE users.id IN (" + StringUtils.collectionToCommaDelimitedString(uids) + ")", String.class); @@ -44,11 +39,6 @@ public class PushQueries { } } - public static List<String> getWinPhoneSubscribers(JdbcTemplate sql, int uid) { - return sql.queryForList("SELECT url FROM winphone INNER JOIN subscr_users " + - "ON (subscr_users.user_id=? AND winphone.user_id=subscr_users.suser_id)", String.class, uid); - } - public static List<String> getWindowsTokens(JdbcTemplate sql, List<Integer> uids) { return sql.queryForList("SELECT url FROM winphone INNER JOIN users " + "ON (users.id=winphone.user_id) WHERE users.id IN (" + StringUtils.collectionToCommaDelimitedString(uids) + ")", String.class); @@ -62,10 +52,6 @@ public class PushQueries { } } - public static List<String> getAPNSSubscribers(JdbcTemplate sql, int uid) { - return sql.queryForList("SELECT token FROM ios INNER JOIN subscr_users " + - "ON (subscr_users.user_id=? AND ios.user_id=subscr_users.suser_id)", String.class, uid); - } public static List<String> getAPNSTokens(JdbcTemplate sql, List<Integer> uids) { 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); |