UserRepositoryImplTest.java

/*
 Copyright (c) 2012 GFT Appverse, S.L., Sociedad Unipersonal.

 This Source Code Form is subject to the terms of the Appverse Public License
 Version 2.0 (“APL v2.0”). If a copy of the APL was not distributed with this
 file, You can obtain one at http://www.appverse.mobi/licenses/apl_v2.0.pdf. [^]

 Redistribution and use in source and binary forms, with or without modification,
 are permitted provided that the conditions of the AppVerse Public License v2.0
 are met.

 THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
 ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
 WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
 DISCLAIMED. EXCEPT IN CASE OF WILLFUL MISCONDUCT OR GROSS NEGLIGENCE, IN NO EVENT
 SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
 INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
 PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
 WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT(INCLUDING NEGLIGENCE OR OTHERWISE)
 ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
 POSSIBILITY OF SUCH DAMAGE.
 */
package org.appverse.web.framework.backend.persistence.services.integration.impl.test;

import java.util.Date;
import java.util.List;

import javax.persistence.NoResultException;
import javax.persistence.OptimisticLockException;
import javax.persistence.PersistenceException;
import javax.persistence.TypedQuery;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Root;

import org.appverse.web.framework.backend.api.helpers.test.AbstractTransactionalTest;
import org.appverse.web.framework.backend.api.helpers.test.JPATest;
import org.appverse.web.framework.backend.api.model.integration.IntegrationDataFilter;
import org.appverse.web.framework.backend.persistence.model.integration.UserDTO;
import org.appverse.web.framework.backend.persistence.services.integration.UserRepository;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.transaction.TransactionConfiguration;
import org.springframework.util.Assert;

@TransactionConfiguration(defaultRollback = false)
public class UserRepositoryImplTest extends AbstractTransactionalTest implements
		JPATest {

	private static UserDTO userDTO;

	@Autowired
	UserRepository userRepository;

	@Override
	public void delete() throws Exception {
		UserDTO userDTORetrieved = userRepository.retrieve(userDTO);
		Assert.isNull(userDTORetrieved);
		userRepository.persist(userDTO);
		userDTORetrieved = userRepository.retrieve(userDTO);
		Assert.notNull(userDTORetrieved);
		userRepository.delete(userDTO);
		userDTORetrieved = userRepository.retrieve(userDTO);
		Assert.isNull(userDTORetrieved);
	}

	@Override
	@Test
	public void deleteAll() throws Exception {
		retrieveAll();
		List<UserDTO> list = userRepository.retrieveList();
		Assert.notEmpty(list);
		userRepository.deleteAll();
		list = userRepository.retrieveList();
		Assert.isTrue(list.isEmpty());
	}

	@Override
	@After
	public void finalize() throws Exception {
		userRepository.deleteAll();
	}

	@Override
	@Before
	public void initialize() throws Exception {
		userDTO = new UserDTO();
		userDTO.setName("name");
		userDTO.setLastName("lastName");
		userDTO.setPassword("password");
		userDTO.setEmail("email");
        userDTO.setActive(true);
        userDTO.setStatus("");
        userDTO.setCreated(new Date());
        userDTO.setCreatedBy("");
	}

	@Override
	@Test
	public void persist() throws Exception {
		UserDTO userDTORetrieved = userRepository.retrieve(userDTO);
		Assert.isNull(userDTORetrieved);
		userRepository.persist(userDTO);
		userDTORetrieved = userRepository.retrieve(userDTO);
		Assert.notNull(userDTORetrieved);

	}

	@Override
	@Test
	public void retrieveAll() throws Exception {
		List<UserDTO> list = userRepository.retrieveList();
		Assert.isTrue(list.isEmpty());
		persist();
		list = userRepository.retrieveList();
		Assert.notEmpty(list);
	}

	@Override
	@Test
	public void retrieveByBean() throws Exception {
		UserDTO userDTORetrieved = userRepository.retrieve(userDTO);
		Assert.isNull(userDTORetrieved);
		persist();
		userDTORetrieved = userRepository.retrieve(new UserDTO());
		Assert.isNull(userDTORetrieved);
		userDTORetrieved = userRepository.retrieve(userDTO);
		Assert.notNull(userDTORetrieved);

	}

	@Override
	@Test
	public void retrieveByFilter() throws Exception {
		UserDTO userDTORetrieved = userRepository.retrieve(userDTO);
		Assert.isNull(userDTORetrieved);
		persist();
		IntegrationDataFilter filter = new IntegrationDataFilter();
		filter.addStrictCondition("name", "name1");
		try{
			userDTORetrieved = userRepository.retrieve(filter);
		}catch(PersistenceException e){
			if(!(e.getCause() instanceof NoResultException)){
				throw e;
			}
		}
		Assert.isNull(userDTORetrieved);
		filter = new IntegrationDataFilter();
		filter.addStrictCondition("name", "name");
		userDTORetrieved = userRepository.retrieve(filter);
		Assert.notNull(userDTORetrieved);

	}

	@Override
	@Test
	public void retrieveByPk() throws Exception {
		UserDTO userDTORetrieved = userRepository.retrieve(userDTO);
		Assert.isNull(userDTORetrieved);
		persist();
		userDTORetrieved = userRepository.retrieve(0);
		Assert.isNull(userDTORetrieved);
		userDTORetrieved = userRepository.retrieve(userDTO.getId());
		Assert.notNull(userDTORetrieved);
	}
	
	@Test
	public void testSingleResultWithoutResults() throws Exception {
		UserDTO userDTORetrieved = userRepository.retrieve("select u from UserDTO u");
		Assert.isNull(userDTORetrieved);
	}

	@Test
	public void useCriteriaBuilder() throws Exception {
		persist();
		CriteriaBuilder cb = userRepository.getCriteriaBuilder();		 
		CriteriaQuery<UserDTO> cq = cb.createQuery(UserDTO.class);
		Root<UserDTO> u = cq.from(UserDTO.class);
		cq.select(u);
		TypedQuery<UserDTO> q = userRepository.createQuery(cq);
		List<UserDTO> allUsers = q.getResultList();		
		Assert.notEmpty(allUsers, "allUsers should not be empty or null");
	}
	

    /*  Tests optimistic locking. This can not be uncommented because even though it is possible to assert that
        certain exception is thrown, the transaction fails anyway and the test is flaged as 'failed'.
    @Test
    public void optimisticLocking() throws Exception{

        // We save an user (id = 1)
        UserDTO testDTO = new UserDTO();
        testDTO.setName("name");
        testDTO.setLastName("lastName");
        testDTO.setPassword("password");
        testDTO.setEmail("email");
        testDTO.setActive(true);
        testDTO.setCreated(new Date());
        testDTO.setCreatedBy("");
        testDTO.setStatus("");
        testDTO.setVersion(2);

        userRepository.persist(testDTO);

        // We need to flush here to simulate the first user has updated the object
        userRepository.flush();

        // We simultate that the userDTO has been received (a form, for instance) with old version (1)
        UserDTO staleDTOSimulation = userRepository.retrieve(1);
        staleDTOSimulation.setId(1);
        staleDTOSimulation.setName("");
        staleDTOSimulation.setLastName("");
        staleDTOSimulation.setPassword("");
        staleDTOSimulation.setEmail("");
        staleDTOSimulation.setActive(true);
        staleDTOSimulation.setCreated(new Date());
        staleDTOSimulation.setCreatedBy("");
        staleDTOSimulation.setStatus("");
        staleDTOSimulation.setVersion(1);
        userRepository.persist(staleDTOSimulation);
    }
    */

}