@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()); }
.column(COLUMN_AMOUNT) .rowNumber(10) .rowOffset(0) .buildLookup()); assertThat(result.getRowCount()).isEqualTo(5); .column(COLUMN_AMOUNT) .rowNumber(3) .rowOffset(0) .buildLookup()); assertThat(result.getRowCount()).isEqualTo(3); .column(COLUMN_AMOUNT) .rowNumber(5) .rowOffset(5) .buildLookup()); assertThat(result.getRowCount()).isEqualTo(0);
.rowOffset(0) .rowNumber(6) .buildLookup();
.rowOffset(0) .rowNumber(6) .buildLookup();
.rowOffset(0) .rowNumber(10) .buildLookup();
.rowOffset(0) .rowNumber(10) .buildLookup();
/** * 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); }