@Test public void testSortByNumber() { // Sort by amount and check the expected results. DataSetComparator comp = new DataSetComparator(); comp.addSortCriteria("5", DataSetComparator.ORDER_DESCENDING); DataSet result = dataSet.sort(comp); assertDataSetValue(result, 0, 0, "2"); assertDataSetValue(result, 1, 0, "15"); assertDataSetValue(result, 2, 0, "20"); }
public void assertKPIValues(KPI kpi, String[][] values) throws Exception { DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, values, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30251353675275870() throws Exception { KPI kpi = getKPIByCode("kpi_30251353675275870"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"EARLY","7,524,909.475"}, {"STANDBY","6,654,928.048"}, {"ADVANCED","6,424,734.889"}}, 0); } }
@Test public void testFilterBySingleString() throws Exception { DefaultDataSetFilter filter = new DefaultDataSetFilter(dataSet); filter.addProperty("employee", null, false, null, false, Arrays.asList("Jerri Preble"), DataFilter.ALLOW_ANY); DataSet result = dataSet.filter(filter); assertDataSetValue(result, 0, 0, "27"); assertDataSetValue(result, 1, 0, "28"); }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_63931223772633377() throws Exception { KPI kpi = getKPIByCode("kpi_63931223772633377"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"Engineering","7,650.162"}, {"Management","6,017.47"}, {"Support","3,345.6"}, {"Sales","3,213.53"}, {"Services","2,504.5"}}, 0); } }
@Test public void testFilterBySingleDate() throws Exception { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yy HH:mm"); Date date = df.parse("07/23/11 12:00"); DefaultDataSetFilter filter = new DefaultDataSetFilter(dataSet); filter.addProperty("date", null, false, null, false, Arrays.asList(date), DataFilter.ALLOW_ANY); DataSet result = dataSet.filter(filter); assertDataSetValue(result, 0, 0, "19"); }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_63901223772516707() throws Exception { KPI kpi = getKPIByCode("kpi_63901223772516707"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"Barcelona","2,913.14"}, {"Madrid","2,453.36"}, {"Brno","4,659.24"}, {"Westford","3,594.972"}, {"Raleigh","4,970.78"}, {"London","4,139.77"}}, 0); } }
@Test public void testFilterBySingleNumber() throws Exception { DefaultDataSetFilter filter = new DefaultDataSetFilter(dataSet); filter.addProperty("id", null, false, null, false, Arrays.asList(25), DataFilter.ALLOW_ANY); DataSet result = dataSet.filter(filter); assertDataSetValue(result, 0, 0, "25"); }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30441353507392054() throws Exception { KPI kpi = getKPIByCode("kpi_30441353507392054"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"2010","2,906,030.224"}, {"2011","4,122,965.423"}, {"2012","4,075,631.39"}, {"2013","4,095,320.587"}, {"2014","4,197,797.742"}, {"2015","1,206,827.046"}}, 0); } }
@Test public void testFilterByDateInterval() throws Exception { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yy HH:mm"); Date from = df.parse("01/01/11 00:00"); Date to = df.parse("12/31/11 23:59"); DefaultDataSetFilter filter = new DefaultDataSetFilter(dataSet); filter.addProperty("date", from, true, to, true, null, DataFilter.ALLOW_ANY); DataSet result = dataSet.filter(filter); assertThat(result.getRowCount()).isEqualTo(11); assertDataSetValue(result, 0, 0, "16"); }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30011353503663716() throws Exception { KPI kpi = getKPIByCode("kpi_30011353503663716"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"WIN","2,467,342.049"}, {"VERBAL COMMITMENT","2,704,337.45"}, {"STANDBY","2,692,343.835"}, {"SHORT LISTED","2,720,890.442"}, {"QUALIFIED","2,614,849.549"}, {"LOST","2,614,342.545"}, {"DEMO","2,336,241.648"}, {"CONTACTED","2,454,224.894"}}, 0); } }
@Test public void testSortByDate() { // Sort by date and check the expected results. DataSetComparator comp = new DataSetComparator(); comp.addSortCriteria("4", DataSetComparator.ORDER_ASCENDING); DataSet result = dataSet.sort(comp); assertDataSetValue(result, 0, 0, "50"); }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30651353683614640() throws Exception { KPI kpi = getKPIByCode("kpi_30651353683614640"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"Darryl Innes","2,669,089.546"}, {"Nita Marling","2,342,011.583"}, {"Roxie Foraker","2,659,589.977"}, {"Neva Hunger","2,485,446.724"}, {"Jamie Gilbeau","2,617,395.494"}, {"Jerri Preble","2,521,398.184"}, {"Kathrine Janas","2,435,833.788"}, {"Julio Burdge","2,873,807.116"}}, 0); } }
@Test public void testFilterByDateInterval2() throws Exception { SimpleDateFormat df = new SimpleDateFormat("MM/dd/yy HH:mm"); DefaultDataSetFilter filter = new DefaultDataSetFilter(dataSet); filter.addProperty("date", "*/11 *"); DataSet result = dataSet.filter(filter); assertThat(result.getRowCount()).isEqualTo(11); assertDataSetValue(result, 0, 0, "16"); }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30041353504912610() throws Exception { KPI kpi = getKPIByCode("kpi_30041353504912610"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"Julio Burdge","2,873,807.116"}, {"Darryl Innes","2,669,089.546"}, {"Roxie Foraker","2,659,589.977"}, {"Jamie Gilbeau","2,617,395.494"}, {"Jerri Preble","2,521,398.184"}, {"Neva Hunger","2,485,446.724"}, {"Kathrine Janas","2,435,833.788"}, {"Nita Marling","2,342,011.583"}}, 0); } }
@Test public void testSortCombined() { // Sort by dept, author, amount and check the expected results. DataSetComparator comp = new DataSetComparator(); comp.addSortCriteria("2", DataSetComparator.ORDER_ASCENDING); comp.addSortCriteria("3", DataSetComparator.ORDER_ASCENDING); comp.addSortCriteria("5", DataSetComparator.ORDER_ASCENDING); DataSet result = dataSet.sort(comp); assertDataSetValue(result, 0, 0, "46"); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30361353506582145() throws Exception { KPI kpi = getKPIByCode("kpi_30361353506582145"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"WIN","2,467,342.049"}, {"VERBAL COMMITMENT","2,704,337.45"}, {"STANDBY","2,692,343.835"}, {"SHORT LISTED","2,720,890.442"}, {"QUALIFIED","2,614,849.549"}, {"LOST","2,614,342.545"}, {"DEMO","2,336,241.648"}, {"CONTACTED","2,454,224.894"}}, 0); } }
@Test public void testFilterByNumberInterval() throws Exception { DefaultDataSetFilter filter = new DefaultDataSetFilter(dataSet); filter.addProperty("amount", 1000, false, null, false, null, DataFilter.ALLOW_ANY); DataSet result = dataSet.filter(filter); assertThat(result.getRowCount()).isEqualTo(2); assertDataSetValue(result, 0, 0, "2"); }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_21591363786594721() throws Exception { KPI kpi = getKPIByCode("kpi_21591363786594721"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"VERBAL COMMITMENT","2,704,337.45"}, {"LOST","2,614,342.545"}, {"STANDBY","2,692,343.835"}, {"QUALIFIED","2,614,849.549"}, {"CONTACTED","2,454,224.894"}, {"WIN","2,467,342.049"}, {"SHORT LISTED","2,720,890.442"}, {"DEMO","2,336,241.648"}}, 0); } }
@Test public void testFilterByWildcard() throws Exception { DefaultDataSetFilter filter = new DefaultDataSetFilter(dataSet); filter.addProperty("city", "B*"); filter.addProperty("department", "*Services*"); DataSet result = dataSet.filter(filter); assertThat(result.getRowCount()).isEqualTo(3); assertDataSetValue(result, 0, 0, "4"); }