aboutsummaryrefslogtreecommitdiff
path: root/src/main/java/com/juick/service/PushQueriesServiceImpl.java
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/java/com/juick/service/PushQueriesServiceImpl.java')
-rw-r--r--src/main/java/com/juick/service/PushQueriesServiceImpl.java91
1 files changed, 0 insertions, 91 deletions
diff --git a/src/main/java/com/juick/service/PushQueriesServiceImpl.java b/src/main/java/com/juick/service/PushQueriesServiceImpl.java
deleted file mode 100644
index 18a14bd6..00000000
--- a/src/main/java/com/juick/service/PushQueriesServiceImpl.java
+++ /dev/null
@@ -1,91 +0,0 @@
-/*
- * Copyright (C) 2008-2023, Juick
- *
- * This program is free software: you can redistribute it and/or modify
- * it under the terms of the GNU Affero General Public License as
- * published by the Free Software Foundation, either version 3 of the
- * License, or (at your option) any later version.
- *
- * This program is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- * GNU Affero General Public License for more details.
- *
- * You should have received a copy of the GNU Affero General Public License
- * along with this program. If not, see <http://www.gnu.org/licenses/>.
- */
-
-package com.juick.service;
-
-import com.juick.model.ExternalToken;
-import org.apache.commons.collections4.CollectionUtils;
-import org.springframework.dao.DataIntegrityViolationException;
-import org.springframework.jdbc.core.RowMapper;
-import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
-import org.springframework.stereotype.Repository;
-import org.springframework.transaction.annotation.Transactional;
-
-import java.sql.ResultSet;
-import java.sql.SQLException;
-import java.util.Collection;
-import java.util.Collections;
-
-/**
- * Created by aalexeev on 11/13/16.
- */
-@Repository
-public class PushQueriesServiceImpl extends BaseJdbcService implements PushQueriesService {
-
- private class TokenMapper implements RowMapper<ExternalToken> {
-
- @Override
- public ExternalToken mapRow(ResultSet rs, int rowNum) throws SQLException {
- return new ExternalToken(
- null,
- rs.getString("service_type"),
- rs.getString("regid"),
- null
- );
- }
- }
-
- @Transactional(readOnly = true)
- @Override
- public Collection<ExternalToken> getToken(final int uid, final String serviceType) {
- return getJdbcTemplate().query(
- "SELECT regid, service_type FROM user_services WHERE user_id=? AND service_type=?",
- new TokenMapper(),
- uid, serviceType);
- }
-
- @Transactional(readOnly = true)
- @Override
- public Collection<ExternalToken> getTokens(final Collection<Integer> uids) {
- if (CollectionUtils.isEmpty(uids))
- return Collections.emptyList();
- return getNamedParameterJdbcTemplate().query(
- """
- SELECT regid, service_type FROM user_services INNER JOIN users
- ON (users.id = user_services.user_id) WHERE users.id IN (:ids)""",
- new MapSqlParameterSource("ids", uids),
- new TokenMapper());
- }
-
- @Transactional
- @Override
- public boolean addToken(final Integer uid, final String serviceType, final String token) {
- try {
- return getJdbcTemplate().update(
- "INSERT INTO user_services(user_id, regid, service_type) VALUES (?, ?, ?)",
- uid, token, serviceType) > 0;
- } catch (DataIntegrityViolationException e) {
- return false;
- }
- }
-
- @Transactional
- @Override
- public boolean deleteToken(final String serviceType, final String token) {
- return getJdbcTemplate().update("DELETE FROM user_services WHERE regid=? AND service_type=?", token, serviceType) > 0;
- }
-}