MockUserDAO.java

/*
 *
 * Copyright 2005 AgileTec s.r.l. (http://www.agiletec.it) All rights reserved.
 *
 * This file is part of jAPS software.
 * jAPS is a free software; 
 * you can redistribute it and/or modify it
 * under the terms of the GNU General Public License (GPL) as published by the Free Software Foundation; version 2.
 * 
 * See the file License for the specific language governing permissions   
 * and limitations under the License
 * 
 * 
 * 
 * Copyright 2005 AgileTec s.r.l. (http://www.agiletec.it) All rights reserved.
 *
 */

package test.com.agiletec.aps.system.services.user;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.Date;

import javax.sql.DataSource;

import com.agiletec.aps.system.services.user.UserDAO;

/**
 * This class is used to change some date fields in the 'authuser' table, in order to test the behaviour of the privacy module
 * 
 * @author M. Minnai
 */
public class MockUserDAO extends UserDAO {
	
	public MockUserDAO(DataSource datasource) {
		this.setDataSource(datasource);
	}
	
	/**
	 * Change the last access date of the given user
	 * @param username the user which we want to set the access date
	 * @param accessDate the date to set, if null the current date will be used
	 */
	public void setLastAccessDate(String username, Date accessDate) {
		this.mockDate(username, accessDate, this.MOCK_ACCESS_DATE);
	}
	
	/**
	 * Change the date of the last change of password, for the given user
	 * @param username the user which we want to set the access date
	 * @param accessDate the date to set, if null the current date will be used
	 */
	public void setLastPasswordChange(String username, Date accessDate) {
		this.mockDate(username, accessDate, this.MOCK_LAST_PASSWORD_CHANGE);
	}
	
	/**
	 * Executes the given SQL so to mock some date in the authuser table for a particular user  
	 * @param username the user which we want to set the access date
	 * @param accessDate the date to set, if null the current date will be used
	 * @param the sql provided by the caller method
	 */
	private void mockDate(String username, Date accessDate, String sql) {
		Date date = new Date(); 
		Connection conn = null;
		PreparedStatement stat = null;
		if (null == accessDate) accessDate = date;
		try {
			conn = this.getConnection();
			stat = conn.prepareStatement(sql);
			stat.setDate(1, new java.sql.Date(accessDate.getTime()));
			stat.setString(2, username);
			stat.execute();
		} catch (Throwable t) {
			processDaoException(t, "Errore nel settare data", "mockDate");
		}  finally {
			this.closeDaoResources(null, stat, conn);
		}
	}

	private String MOCK_ACCESS_DATE = 
		"UPDATE authusers SET lastaccess = ? WHERE username = ? ";
	
	private String MOCK_LAST_PASSWORD_CHANGE = 
		"UPDATE authusers SET lastpasswordchange = ? WHERE username = ? ";
	
}