@Test
public void testMySql_filterAggregated() {

    /**
     * id=2701,
     * timestamp=1517203757814,
     * key=172.16.10.110,
     * strategy_name=IP相同UA大量请求单个页面,
     * scene_name=VISITOR,
     * checkpoints=,*
     * check_type=IP,*
     * decision=review,*
     * risk_score=0,*
     * expire=1517204057814,*
     * remark=>50, *
     * 1 页面, *
     * 1UA, *
     * last_modified=null,*
     * variable_values=null,*
     * geo_province=内网, *
     * geo_city=内网, *
     * test=1,*
     * tip=IP相同UA大量请求单个页面, *
     * uri_stem=wiki.threathunter.net/rest/mywork/latest/task, *
     * trigger_event=null
     */
    SqlSessionFactory sqlSessionFactory = (SqlSessionFactory) applicationContext.getBean("sqlSessionFactory");
    SqlSession sqlSession = SqlSessionUtils.getSqlSession(sqlSessionFactory);
    SlotNoticeService.Criteria criteria = new SlotNoticeService.Criteria();
    criteria.setTest(1L);
    criteria.setCheckTypes(Arrays.asList(new String[]{"IP"}));
    criteria.setKey("172.16.10.110");
    criteria.setStrategies(Arrays.asList(new String[]{"IP相同UA大量请求单个页面"}));
    List<SlotNotice> slotNotices = mysqlService.querySlotNoticeAtAggregate(criteria, 20, 20);
    assertThat(slotNotices.size()).isNotEqualTo(0);
}