From 5c11e3e85b70a3789c3e330209122723f1b38121 Mon Sep 17 00:00:00 2001 From: Vitaly Takmazov Date: Sun, 15 Jan 2023 09:47:06 +0300 Subject: PushQueriesService -> UserService --- .../com/juick/service/PushQueriesServiceImpl.java | 91 ---------------------- 1 file changed, 91 deletions(-) delete mode 100644 src/main/java/com/juick/service/PushQueriesServiceImpl.java (limited to 'src/main/java/com/juick/service/PushQueriesServiceImpl.java') 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 . - */ - -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 { - - @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 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 getTokens(final Collection 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; - } -} -- cgit v1.2.3