UserRepositoryTest.java

package net.sf.gazpachoquest.repository;

import static org.fest.assertions.api.Assertions.assertThat;

import java.util.List;
import java.util.Set;

import net.sf.gazpachoquest.domain.permission.QuestionnaireDefinitionPermission;
import net.sf.gazpachoquest.domain.user.Role;
import net.sf.gazpachoquest.repository.user.UserRepository;
import net.sf.gazpachoquest.test.dbunit.support.ColumnDetectorXmlDataSetLoader;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.TestExecutionListeners;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.test.context.support.DependencyInjectionTestExecutionListener;

import com.github.springtestdbunit.DbUnitTestExecutionListener;
import com.github.springtestdbunit.annotation.DatabaseSetup;
import com.github.springtestdbunit.annotation.DatabaseTearDown;
import com.github.springtestdbunit.annotation.DbUnitConfiguration;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = { "classpath:/jpa-test-context.xml", "classpath:/datasource-test-context.xml" })
@TestExecutionListeners({ DependencyInjectionTestExecutionListener.class, DbUnitTestExecutionListener.class })
@DatabaseSetup("UserRepository-dataset.xml")
@DatabaseTearDown("UserRepository-dataset.xml")
@DbUnitConfiguration(dataSetLoader = ColumnDetectorXmlDataSetLoader.class)
public class UserRepositoryTest {

    @Autowired
    private UserRepository repository;

    @Test
    public void getRolesTest() {
        Integer userId = 1;
        Set<Role> roles = repository.getRoles(userId);
        assertThat(roles).contains(Role.with().id(1).build());
    }

    @Test
    public void getQuestionnairDefinitionPermissionsTest() {
        Integer userId = 1;
        List<QuestionnaireDefinitionPermission> permissions = repository.getQuestionnairDefinitionPermissions(userId);
        assertThat(permissions).contains(QuestionnaireDefinitionPermission.with().id(5).build());
    }
}