1 /* 2 * Copyright (c) 2002-2021, City of Paris 3 * All rights reserved. 4 * 5 * Redistribution and use in source and binary forms, with or without 6 * modification, are permitted provided that the following conditions 7 * are met: 8 * 9 * 1. Redistributions of source code must retain the above copyright notice 10 * and the following disclaimer. 11 * 12 * 2. Redistributions in binary form must reproduce the above copyright notice 13 * and the following disclaimer in the documentation and/or other materials 14 * provided with the distribution. 15 * 16 * 3. Neither the name of 'Mairie de Paris' nor 'Lutece' nor the names of its 17 * contributors may be used to endorse or promote products derived from 18 * this software without specific prior written permission. 19 * 20 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" 21 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE 22 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE 23 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDERS OR CONTRIBUTORS BE 24 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR 25 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF 26 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS 27 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN 28 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) 29 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE 30 * POSSIBILITY OF SUCH DAMAGE. 31 * 32 * License 1.0 33 */ 34 package fr.paris.lutece.plugins.newsletter.business; 35 36 import fr.paris.lutece.portal.service.plugin.Plugin; 37 import fr.paris.lutece.util.sql.DAOUtil; 38 39 /** 40 * 41 * AwaitingActivationDAO provides newsletter_awaiting_confirmation table management 42 */ 43 public class AwaitingActivationDAO implements IAwaitingActivationDAO 44 { 45 private static final String SQL_QUERY_INSERT = "INSERT INTO newsletter_awaiting_confirmation(id_user, generated_key) VALUES (?, ?)"; 46 private static final String SQL_QUERY_EXISTS = "SELECT id_user, generated_key FROM newsletter_awaiting_confirmation WHERE id_user = ? AND generated_key = ?"; 47 private static final String SQL_QUERY_DELETE = "DELETE FROM newsletter_awaiting_confirmation WHERE id_user = ? AND generated_key = ?"; 48 49 /** 50 * Removes the entry 51 * 52 * @param nIdUser 53 * the user id 54 * @param nKey 55 * the key 56 * @param plugin 57 * the plugin 58 */ 59 public void delete( int nIdUser, int nKey, Plugin plugin ) 60 { 61 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE, plugin ); 62 daoUtil.setInt( 1, nIdUser ); 63 daoUtil.setInt( 2, nKey ); 64 65 daoUtil.executeUpdate( ); 66 67 daoUtil.free( ); 68 } 69 70 /** 71 * Checks if the pair user/key already exists. 72 * 73 * @param nIdUser 74 * the user id 75 * @param nKey 76 * the generated key 77 * @param plugin 78 * the plugin 79 * @return <b>true</b> if the pair already exists, <b>false</b> otherwise. 80 */ 81 public boolean exists( int nIdUser, int nKey, Plugin plugin ) 82 { 83 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_EXISTS, plugin ); 84 daoUtil.setInt( 1, nIdUser ); 85 daoUtil.setInt( 2, nKey ); 86 87 daoUtil.executeQuery( ); 88 89 boolean bExists = daoUtil.next( ); 90 91 daoUtil.free( ); 92 93 return bExists; 94 } 95 96 /** 97 * Adds a new pair user/key entry 98 * 99 * @param nIdUser 100 * the user id 101 * @param nKey 102 * the generated key 103 * @param plugin 104 * the plugin 105 */ 106 public void insert( int nIdUser, int nKey, Plugin plugin ) 107 { 108 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, plugin ); 109 daoUtil.setInt( 1, nIdUser ); 110 daoUtil.setInt( 2, nKey ); 111 112 daoUtil.executeUpdate( ); 113 114 daoUtil.free( ); 115 } 116 }