@Test public void testTrim() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(EXPENSE_REPORTS) .rowNumber(10) .buildLookup()); assertThat(result.getColumns().size()).isEqualTo(6); assertThat(result.getRowCount()).isEqualTo(10); }
@Test public void testTrimGroup() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(EXPENSE_REPORTS) .group(COLUMN_DEPARTMENT) .column(COLUMN_CITY) .column(COLUMN_DEPARTMENT) .column(COLUMN_AMOUNT, AggregateFunctionType.SUM) .rowNumber(10) .buildLookup()); assertThat(result.getColumns().size()).isEqualTo(3); assertThat(result.getRowCount()).isEqualTo(5); assertThat(result.getRowCountNonTrimmed()).isEqualTo(5); }
@Test public void testDuplicatedColumns() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(EXPENSE_REPORTS) .column(COLUMN_CITY, "city1") .column(COLUMN_CITY, "city2") .rowNumber(10) .sort(COLUMN_CITY, SortOrder.ASCENDING) .buildLookup()); assertThat(result.getColumns().size()).isEqualTo(2); assertThat(result.getRowCount()).isEqualTo(10); } }
DataSetLookupFactory.newDataSetLookupBuilder() .dataset(DataSetGroupTest.EXPENSE_REPORTS) .rowNumber(10) .buildLookup()); DataSetLookupFactory.newDataSetLookupBuilder() .dataset(DataSetGroupTest.EXPENSE_REPORTS) .rowNumber(10) .rowOffset(40) .buildLookup()); .column(DEPT.getName()) .column(AMOUNT.getName(), SUM) .rowNumber(3) .rowOffset(0) .buildLookup()); .dataset(DataSetGroupTest.EXPENSE_REPORTS) .filter(CITY.getName(), equalsTo("Barcelona")) .rowNumber(3) .rowOffset(0) .buildLookup());
@Test public void testTrim() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(EXPENSE_REPORTS) .rowNumber(10) .buildLookup()); assertThat(result.getColumns().size()).isEqualTo(6); assertThat(result.getRowCount()).isEqualTo(10); }
@Test public void testAvoidDuplicatedGroupColumn() throws Exception { // In some DBs (MonetDB for instance), duplicated columns in "group by" fails dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(DataSetGroupTest.EXPENSE_REPORTS) .group(COLUMN_DEPARTMENT) .column("Department") .column(COLUMN_AMOUNT, SUM) .rowNumber(3) .rowOffset(0) .buildLookup()); }
@Test public void testAvoidDuplicatedGroupColumn() throws Exception { // In some DBs (MonetDB for instance), duplicated columns in "group by" fails dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(DataSetGroupTest.EXPENSE_REPORTS) .group(COLUMN_DEPARTMENT) .column("Department") .column(COLUMN_AMOUNT, SUM) .rowNumber(3) .rowOffset(0) .buildLookup()); }
@Test public void testDuplicatedColumns() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(EXPENSE_REPORTS) .column(COLUMN_CITY, "city1") .column(COLUMN_CITY, "city2") .rowNumber(10) .sort(COLUMN_CITY, SortOrder.ASCENDING) .buildLookup()); assertThat(result.getColumns().size()).isEqualTo(2); assertThat(result.getRowCount()).isEqualTo(10); } }
@Test public void testGroupByFixedTrim() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(EXPENSE_REPORTS) .filter(COLUMN_ID, FilterFactory.equalsTo(1)) .group(COLUMN_DATE).fixed(MONTH, true) .column(COLUMN_DATE, "Period") .column(COUNT, "Occurrences") .column(COLUMN_AMOUNT, SUM, "totalAmount") .rowNumber(8) .buildLookup()); assertThat(result.getRowCountNonTrimmed()).isEqualTo(12); assertDataSetValues(result, dataSetFormatter, new String[][]{ {"1", "0.00", "0.00"}, {"2", "0.00", "0.00"}, {"3", "0.00", "0.00"}, {"4", "0.00", "0.00"}, {"5", "0.00", "0.00"}, {"6", "0.00", "0.00"}, {"7", "0.00", "0.00"}, {"8", "0.00", "0.00"}, }, 0); }
@Test public void testTrimGroup() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(EXPENSE_REPORTS) .group(COLUMN_DEPARTMENT) .column(COLUMN_CITY) .column(COLUMN_DEPARTMENT) .column(COLUMN_AMOUNT, AggregateFunctionType.SUM) .rowNumber(10) .buildLookup()); assertThat(result.getColumns().size()).isEqualTo(3); assertThat(result.getRowCount()).isEqualTo(5); assertThat(result.getRowCountNonTrimmed()).isEqualTo(5); }
.dataset(dataSetDef.getUUID()) .rowOffset(0) .rowNumber(6) .buildLookup();
.dataset(dataSetDef.getUUID()) .rowOffset(0) .rowNumber(6) .buildLookup();
.dataset(dataSetDef.getUUID()) .rowOffset(0) .rowNumber(10) .buildLookup();
.dataset(dataSetDef.getUUID()) .rowOffset(0) .rowNumber(10) .buildLookup();
@Test public void testTableGroupBy() throws Exception { try { createTestTable(); DataSet dataSet = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset("test") .group(NAME.getName()) .column(ID.getName()) .column(NAME.getName()) .rowNumber(8) .buildLookup()); assertEquals(dataSet.getRowCount(), 2); assertEquals(dataSet.getRowCountNonTrimmed(), 2); } finally { dropTestTable(); } } }
@Test public void testTableGroupBy() throws Exception { try { createTestTable(); DataSet dataSet = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset("test") .group(NAME.getName()) .column(ID.getName()) .column(NAME.getName()) .rowNumber(8) .buildLookup()); assertEquals(dataSet.getRowCount(), 2); assertEquals(dataSet.getRowCountNonTrimmed(), 2); } finally { dropTestTable(); } } }
@Test public void testGroupByFixedTrim() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(EXPENSE_REPORTS) .filter(COLUMN_ID, FilterFactory.equalsTo(1)) .group(COLUMN_DATE).fixed(MONTH, true) .column(COLUMN_DATE, "Period") .column(COUNT, "Occurrences") .column(COLUMN_AMOUNT, SUM, "totalAmount") .rowNumber(8) .buildLookup()); assertThat(result.getRowCountNonTrimmed()).isEqualTo(12); assertDataSetValues(result, dataSetFormatter, new String[][]{ {"1", "0.00", "0.00"}, {"2", "0.00", "0.00"}, {"3", "0.00", "0.00"}, {"4", "0.00", "0.00"}, {"5", "0.00", "0.00"}, {"6", "0.00", "0.00"}, {"7", "0.00", "0.00"}, {"8", "0.00", "0.00"}, }, 0); }
/** * Test trimming. */ @Test public void testLookupTrim() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetFactory.newDataSetLookupBuilder() .dataset(EL_DATASET_UUID) .sort(ExpenseReportsData.COLUMN_ID, SortOrder.ASCENDING) .rowNumber(10) .rowOffset(40) .buildLookup()); assertThat(result.getRowCount()).isEqualTo(10); assertThat(result.getValueAt(0, 0)).isEqualTo(41d); assertThat(result.getValueAt(9, 0)).isEqualTo(50d); // Test row 6 values. assertThat(result.getValueAt(6, 0)).isEqualTo(47d); assertThat(result.getValueAt(6, 1)).isEqualTo(565.56); assertThat(result.getValueAt(6, 2)).isEqualTo(EL_EXAMPLE_DEPT_MANAGEMENT); assertThat(result.getValueAt(6, 3)).isEqualTo(EL_EXAMPLE_EMP_PATRICIA); Date date = new SimpleDateFormat(DATE_FORMAT).parse("2012-04-14 -0900"); assertThat(result.getValueAt(6, 4)).isEqualTo(date); assertThat(result.getValueAt(6, 5)).isEqualTo(EL_EXAMPLE_CITY_LONDON); }
DataSetLookupFactory.newDataSetLookupBuilder() .dataset(DataSetGroupTest.EXPENSE_REPORTS) .rowNumber(10) .buildLookup()); DataSetLookupFactory.newDataSetLookupBuilder() .dataset(DataSetGroupTest.EXPENSE_REPORTS) .rowNumber(10) .rowOffset(40) .buildLookup()); .column(DEPT.getName()) .column(AMOUNT.getName(), SUM) .rowNumber(3) .rowOffset(0) .buildLookup()); .dataset(DataSetGroupTest.EXPENSE_REPORTS) .filter(CITY.getName(), equalsTo("Barcelona")) .rowNumber(3) .rowOffset(0) .buildLookup());