@Test
public void should_select_by_user_with_only_favorite_filters() {
setupData("should_select_by_user_with_only_favorite_filters");
List<IssueFilterDto> results = dao.selectByUserWithOnlyFavoriteFilters("michael");
assertThat(results).hasSize(1);
IssueFilterDto issueFilterDto = results.get(0);
assertThat(issueFilterDto.getId()).isEqualTo(2L);
}
@Test
public void should_select_by_name_and_user() {
setupData("shared");
IssueFilterDto filter = dao.selectByNameAndUser("Sonar Issues", "stephane", null);
assertThat(filter.getId()).isEqualTo(1L);
filter = dao.selectByNameAndUser("Sonar Issues", "stephane", 1L);
assertThat(filter).isNull();
}
@Test
public void should_select_by_id() {
setupData("shared");
IssueFilterDto filter = dao.selectById(1L);
assertThat(filter.getId()).isEqualTo(1L);
assertThat(filter.getName()).isEqualTo("Sonar Issues");
assertThat(filter.isShared()).isTrue();
assertThat(dao.selectById(123L)).isNull();
}
@Test
public void should_select_shared_by_name() {
setupData("should_select_shared_by_name");
IssueFilterDto result =
dao.selectSharedWithoutUserFiltersByName("Open issues", "stephane", null);
assertThat(result).isNotNull();
assertThat(result.getId()).isEqualTo(3L);
assertThat(result.getUserLogin()).isEqualTo("michael");
assertThat(result.isShared()).isTrue();
assertThat(dao.selectSharedWithoutUserFiltersByName("Open issues", "stephane", 3L)).isNull();
assertThat(dao.selectSharedWithoutUserFiltersByName("Open issues", "michael", null)).isNull();
assertThat(dao.selectSharedWithoutUserFiltersByName("Sonar issues", "stephane", null)).isNull();
}
@Test
public void should_update() {
setupData("shared");
IssueFilterDto filterDto = new IssueFilterDto();
filterDto.setId(2L);
filterDto.setName("Closed issues");
filterDto.setShared(false);
filterDto.setDescription("All closed issues");
filterDto.setData("statuses=CLOSED");
filterDto.setUserLogin("bernard");
dao.update(filterDto);
checkTables("should_update", new String[] {"created_at", "updated_at"}, "issue_filters");
}
@Test
public void should_insert() {
setupData("shared");
IssueFilterDto filterDto = new IssueFilterDto();
filterDto.setName("Sonar Open issues");
filterDto.setUserLogin("michael");
filterDto.setShared(true);
filterDto.setDescription("All open issues on Sonar");
filterDto.setData("statuses=OPEN|componentRoots=org.codehaus.sonar");
dao.insert(filterDto);
checkTables("should_insert", new String[] {"created_at", "updated_at"}, "issue_filters");
}
