Search in sources :

Example 11 with Filter

use of com.epam.ta.reportportal.commons.querygen.Filter in project commons-dao by reportportal.

the class WidgetContentRepositoryTest method launchesTableStatisticsSorting.

@Test
void launchesTableStatisticsSorting() {
    String sortingColumn = "statistics$defects$no_defect$nd001";
    Filter filter = buildDefaultFilter(1L);
    List<Sort.Order> orders = filter.getTarget().getCriteriaHolders().stream().map(ch -> new Sort.Order(Sort.Direction.ASC, ch.getFilterCriteria())).collect(Collectors.toList());
    orders.add(new Sort.Order(Sort.Direction.DESC, sortingColumn));
    Sort sort = Sort.by(orders);
    List<String> contentFields = buildLaunchesTableContentFields();
    List<LaunchesTableContent> launchStatisticsContents = widgetContentRepository.launchesTableStatistics(filter, contentFields, sort, 3);
    assertNotNull(launchStatisticsContents);
    assertEquals(3, launchStatisticsContents.size());
}
Also used : com.epam.ta.reportportal.entity.widget.content.healthcheck(com.epam.ta.reportportal.entity.widget.content.healthcheck) StatusEnum(com.epam.ta.reportportal.entity.enums.StatusEnum) CRITERIA_STATUS(com.epam.ta.reportportal.commons.querygen.constant.TestItemCriteriaConstant.CRITERIA_STATUS) DSL(org.jooq.impl.DSL) TestItem(com.epam.ta.reportportal.entity.item.TestItem) Activity(com.epam.ta.reportportal.entity.activity.Activity) Autowired(org.springframework.beans.factory.annotation.Autowired) com.epam.ta.reportportal.entity.widget.content(com.epam.ta.reportportal.entity.widget.content) CRITERIA_COMPOSITE_ATTRIBUTE(com.epam.ta.reportportal.commons.querygen.constant.ItemAttributeConstant.CRITERIA_COMPOSITE_ATTRIBUTE) CRITERIA_ACTION(com.epam.ta.reportportal.commons.querygen.constant.ActivityCriteriaConstant.CRITERIA_ACTION) ArrayList(java.util.ArrayList) LinkedHashMap(java.util.LinkedHashMap) BigDecimal(java.math.BigDecimal) Condition(com.epam.ta.reportportal.commons.querygen.Condition) Map(java.util.Map) DSLContext(org.jooq.DSLContext) Sort(org.springframework.data.domain.Sort) CRITERIA_LAUNCH_MODE(com.epam.ta.reportportal.commons.querygen.constant.LaunchCriteriaConstant.CRITERIA_LAUNCH_MODE) RoundingMode(java.math.RoundingMode) Record(org.jooq.Record) BaseTest(com.epam.ta.reportportal.BaseTest) Launch(com.epam.ta.reportportal.entity.launch.Launch) ImmutableMap(com.google.common.collect.ImmutableMap) JTestItemTypeEnum(com.epam.ta.reportportal.jooq.enums.JTestItemTypeEnum) Filter(com.epam.ta.reportportal.commons.querygen.Filter) Timestamp(java.sql.Timestamp) WidgetContentRepositoryConstants(com.epam.ta.reportportal.dao.constant.WidgetContentRepositoryConstants) GeneralCriteriaConstant(com.epam.ta.reportportal.commons.querygen.constant.GeneralCriteriaConstant) ConvertibleCondition(com.epam.ta.reportportal.commons.querygen.ConvertibleCondition) FilterCondition(com.epam.ta.reportportal.commons.querygen.FilterCondition) Result(org.jooq.Result) Maps(com.google.common.collect.Maps) Sql(org.springframework.test.context.jdbc.Sql) Collectors(java.util.stream.Collectors) CRITERIA_CREATION_DATE(com.epam.ta.reportportal.commons.querygen.constant.ActivityCriteriaConstant.CRITERIA_CREATION_DATE) Test(org.junit.jupiter.api.Test) List(java.util.List) CRITERIA_USER(com.epam.ta.reportportal.commons.querygen.constant.UserCriteriaConstant.CRITERIA_USER) Lists(org.assertj.core.util.Lists) Assertions(org.junit.jupiter.api.Assertions) JStatusEnum(com.epam.ta.reportportal.jooq.enums.JStatusEnum) CRITERIA_ITEM_ATTRIBUTE_KEY(com.epam.ta.reportportal.commons.querygen.constant.ItemAttributeConstant.CRITERIA_ITEM_ATTRIBUTE_KEY) Mode(com.epam.ta.reportportal.ws.model.launch.Mode) ActivityResource(com.epam.ta.reportportal.ws.model.ActivityResource) Filter(com.epam.ta.reportportal.commons.querygen.Filter) Sort(org.springframework.data.domain.Sort) BaseTest(com.epam.ta.reportportal.BaseTest) Test(org.junit.jupiter.api.Test)

Example 12 with Filter

use of com.epam.ta.reportportal.commons.querygen.Filter in project commons-dao by reportportal.

the class WidgetContentRepositoryTest method summaryPassStatistics.

@Test
void summaryPassStatistics() {
    Filter filter = buildDefaultFilter(1L);
    Sort sort = Sort.by(Lists.newArrayList(new Sort.Order(Sort.Direction.ASC, CRITERIA_START_TIME)));
    PassingRateStatisticsResult passStatisticsResult = widgetContentRepository.summaryPassingRateStatistics(filter, sort, 4);
    assertNotNull(passStatisticsResult);
    assertEquals(4, passStatisticsResult.getNumber());
    assertEquals(13, passStatisticsResult.getPassed());
    assertEquals(48, passStatisticsResult.getTotal());
}
Also used : Filter(com.epam.ta.reportportal.commons.querygen.Filter) Sort(org.springframework.data.domain.Sort) BaseTest(com.epam.ta.reportportal.BaseTest) Test(org.junit.jupiter.api.Test)

Example 13 with Filter

use of com.epam.ta.reportportal.commons.querygen.Filter in project commons-dao by reportportal.

the class WidgetContentRepositoryTest method activityStatisticsSorting.

@Test
void activityStatisticsSorting() {
    Filter filter = buildDefaultActivityFilter(1L);
    List<Sort.Order> orders = filter.getTarget().getCriteriaHolders().stream().map(ch -> new Sort.Order(Sort.Direction.ASC, ch.getFilterCriteria())).collect(Collectors.toList());
    Sort sort = Sort.by(orders);
    List<String> contentFields = buildActivityContentFields();
    filter.withCondition(new FilterCondition(Condition.EQUALS, false, "superadmin", CRITERIA_USER)).withCondition(new FilterCondition(Condition.IN, false, String.join(",", contentFields), CRITERIA_ACTION));
    List<ActivityResource> activityContentList = widgetContentRepository.activityStatistics(filter, sort, 4);
    assertNotNull(activityContentList);
    assertEquals(4, activityContentList.size());
}
Also used : com.epam.ta.reportportal.entity.widget.content.healthcheck(com.epam.ta.reportportal.entity.widget.content.healthcheck) StatusEnum(com.epam.ta.reportportal.entity.enums.StatusEnum) CRITERIA_STATUS(com.epam.ta.reportportal.commons.querygen.constant.TestItemCriteriaConstant.CRITERIA_STATUS) DSL(org.jooq.impl.DSL) TestItem(com.epam.ta.reportportal.entity.item.TestItem) Activity(com.epam.ta.reportportal.entity.activity.Activity) Autowired(org.springframework.beans.factory.annotation.Autowired) com.epam.ta.reportportal.entity.widget.content(com.epam.ta.reportportal.entity.widget.content) CRITERIA_COMPOSITE_ATTRIBUTE(com.epam.ta.reportportal.commons.querygen.constant.ItemAttributeConstant.CRITERIA_COMPOSITE_ATTRIBUTE) CRITERIA_ACTION(com.epam.ta.reportportal.commons.querygen.constant.ActivityCriteriaConstant.CRITERIA_ACTION) ArrayList(java.util.ArrayList) LinkedHashMap(java.util.LinkedHashMap) BigDecimal(java.math.BigDecimal) Condition(com.epam.ta.reportportal.commons.querygen.Condition) Map(java.util.Map) DSLContext(org.jooq.DSLContext) Sort(org.springframework.data.domain.Sort) CRITERIA_LAUNCH_MODE(com.epam.ta.reportportal.commons.querygen.constant.LaunchCriteriaConstant.CRITERIA_LAUNCH_MODE) RoundingMode(java.math.RoundingMode) Record(org.jooq.Record) BaseTest(com.epam.ta.reportportal.BaseTest) Launch(com.epam.ta.reportportal.entity.launch.Launch) ImmutableMap(com.google.common.collect.ImmutableMap) JTestItemTypeEnum(com.epam.ta.reportportal.jooq.enums.JTestItemTypeEnum) Filter(com.epam.ta.reportportal.commons.querygen.Filter) Timestamp(java.sql.Timestamp) WidgetContentRepositoryConstants(com.epam.ta.reportportal.dao.constant.WidgetContentRepositoryConstants) GeneralCriteriaConstant(com.epam.ta.reportportal.commons.querygen.constant.GeneralCriteriaConstant) ConvertibleCondition(com.epam.ta.reportportal.commons.querygen.ConvertibleCondition) FilterCondition(com.epam.ta.reportportal.commons.querygen.FilterCondition) Result(org.jooq.Result) Maps(com.google.common.collect.Maps) Sql(org.springframework.test.context.jdbc.Sql) Collectors(java.util.stream.Collectors) CRITERIA_CREATION_DATE(com.epam.ta.reportportal.commons.querygen.constant.ActivityCriteriaConstant.CRITERIA_CREATION_DATE) Test(org.junit.jupiter.api.Test) List(java.util.List) CRITERIA_USER(com.epam.ta.reportportal.commons.querygen.constant.UserCriteriaConstant.CRITERIA_USER) Lists(org.assertj.core.util.Lists) Assertions(org.junit.jupiter.api.Assertions) JStatusEnum(com.epam.ta.reportportal.jooq.enums.JStatusEnum) CRITERIA_ITEM_ATTRIBUTE_KEY(com.epam.ta.reportportal.commons.querygen.constant.ItemAttributeConstant.CRITERIA_ITEM_ATTRIBUTE_KEY) Mode(com.epam.ta.reportportal.ws.model.launch.Mode) ActivityResource(com.epam.ta.reportportal.ws.model.ActivityResource) Filter(com.epam.ta.reportportal.commons.querygen.Filter) FilterCondition(com.epam.ta.reportportal.commons.querygen.FilterCondition) ActivityResource(com.epam.ta.reportportal.ws.model.ActivityResource) Sort(org.springframework.data.domain.Sort) BaseTest(com.epam.ta.reportportal.BaseTest) Test(org.junit.jupiter.api.Test)

Example 14 with Filter

use of com.epam.ta.reportportal.commons.querygen.Filter in project commons-dao by reportportal.

the class WidgetContentRepositoryTest method productStatusLaunchGroupedWidget.

@Test
void productStatusLaunchGroupedWidget() {
    Filter filter = buildDefaultTestFilter(1L);
    Sort sort = Sort.by(Lists.newArrayList(new Sort.Order(Sort.Direction.DESC, CRITERIA_START_TIME)));
    Map<String, String> tags = new LinkedHashMap<>();
    tags.put("firstColumn", "build");
    tags.put("secondColumn", "hello");
    List<ProductStatusStatisticsContent> result = widgetContentRepository.productStatusGroupedByLaunchesStatistics(filter, buildProductStatusContentFields(), tags, sort, false, 10);
    assertNotNull(result);
}
Also used : Filter(com.epam.ta.reportportal.commons.querygen.Filter) Sort(org.springframework.data.domain.Sort) LinkedHashMap(java.util.LinkedHashMap) BaseTest(com.epam.ta.reportportal.BaseTest) Test(org.junit.jupiter.api.Test)

Example 15 with Filter

use of com.epam.ta.reportportal.commons.querygen.Filter in project commons-dao by reportportal.

the class LogRepositoryTest method updateLaunchIdByLaunchId.

@Test
void updateLaunchIdByLaunchId() {
    final Filter firstLaunchFilter = Filter.builder().withTarget(Log.class).withCondition(FilterCondition.builder().eq(CRITERIA_LOG_LAUNCH_ID, String.valueOf(1L)).build()).build();
    final Filter secondLaunchFilter = Filter.builder().withTarget(Log.class).withCondition(FilterCondition.builder().eq(CRITERIA_LOG_LAUNCH_ID, String.valueOf(2L)).build()).build();
    final List<Long> firstLaunchLogIds = logRepository.findIdsByFilter(firstLaunchFilter);
    Assertions.assertFalse(firstLaunchLogIds.isEmpty());
    logRepository.updateLaunchIdByLaunchId(1L, 2L);
    final List<Long> secondLaunchLogIds = logRepository.findIdsByFilter(secondLaunchFilter);
    Assertions.assertFalse(secondLaunchLogIds.isEmpty());
    Assertions.assertTrue(secondLaunchLogIds.containsAll(firstLaunchLogIds));
    Assertions.assertTrue(logRepository.findIdsByFilter(firstLaunchFilter).isEmpty());
}
Also used : Filter(com.epam.ta.reportportal.commons.querygen.Filter) BaseTest(com.epam.ta.reportportal.BaseTest) Test(org.junit.jupiter.api.Test)

Aggregations

Filter (com.epam.ta.reportportal.commons.querygen.Filter)63 BaseTest (com.epam.ta.reportportal.BaseTest)59 Test (org.junit.jupiter.api.Test)59 Sort (org.springframework.data.domain.Sort)38 FilterCondition (com.epam.ta.reportportal.commons.querygen.FilterCondition)29 Activity (com.epam.ta.reportportal.entity.activity.Activity)24 Timestamp (java.sql.Timestamp)23 Autowired (org.springframework.beans.factory.annotation.Autowired)23 StatusEnum (com.epam.ta.reportportal.entity.enums.StatusEnum)22 JStatusEnum (com.epam.ta.reportportal.jooq.enums.JStatusEnum)22 BigDecimal (java.math.BigDecimal)22 RoundingMode (java.math.RoundingMode)22 LinkedHashMap (java.util.LinkedHashMap)22 DSL (org.jooq.impl.DSL)22 CRITERIA_STATUS (com.epam.ta.reportportal.commons.querygen.constant.TestItemCriteriaConstant.CRITERIA_STATUS)21 ActivityResource (com.epam.ta.reportportal.ws.model.ActivityResource)20 ImmutableMap (com.google.common.collect.ImmutableMap)20 ArrayList (java.util.ArrayList)20 Map (java.util.Map)20 Condition (com.epam.ta.reportportal.commons.querygen.Condition)19