@Test public void testAllColumns() throws Exception { URL fileURL = Thread.currentThread().getContextClassLoader().getResource("expenseReports_allcolumns.dset"); String json = IOUtils.toString(fileURL, StandardCharsets.UTF_8); SQLDataSetDef def = (SQLDataSetDef) jsonMarshaller.fromJson(json); dataSetDefRegistry.registerDataSetDef(def); DataSetMetadata metadata = dataSetManager.getDataSetMetadata("expense_reports_allcolumns"); assertThat(metadata.getNumberOfColumns()).isEqualTo(6); assertThat(metadata.getEstimatedSize()).isEqualTo(6350); }
@Test public void testColumnSet() throws Exception { URL fileURL = Thread.currentThread().getContextClassLoader().getResource("expenseReports_columnset.dset"); String json = IOUtils.toString(fileURL, StandardCharsets.UTF_8); SQLDataSetDef def = (SQLDataSetDef) jsonMarshaller.fromJson(json); dataSetDefRegistry.registerDataSetDef(def); DataSetMetadata metadata = dataSetManager.getDataSetMetadata("expense_reports_columnset"); assertThat(metadata.getNumberOfColumns()).isEqualTo(4); if (!testSettings.isMonetDB()) { assertThat(metadata.getEstimatedSize()).isEqualTo(4300); } final String uuid = "expense_reports_columnset"; DataSet dataSet = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(uuid) .buildLookup()); assertThat(dataSet.getColumns().size()).isEqualTo(4); assertThat(dataSet.getValueAt(0, 0)).isEqualTo("Engineering"); assertThat(dataSet.getValueAt(0, 1)).isEqualTo("Roxie Foraker"); assertThat(dataSet.getValueAt(0, 2)).isEqualTo(120.35d); assertThat(dataSetFormatter.formatValueAt(dataSet, 0, 3)).isEqualTo("12/11/15 12:00"); assertDataSetDefinition(dataSet, uuid); }
@Test public void testAllColumns() throws Exception { URL fileURL = Thread.currentThread().getContextClassLoader().getResource("expenseReports_allcolumns.dset"); String json = IOUtils.toString(fileURL); SQLDataSetDef def = (SQLDataSetDef) jsonMarshaller.fromJson(json); dataSetDefRegistry.registerDataSetDef(def); DataSetMetadata metadata = dataSetManager.getDataSetMetadata("expense_reports_allcolumns"); assertThat(metadata.getNumberOfColumns()).isEqualTo(6); assertThat(metadata.getEstimatedSize()).isEqualTo(6350); }
@Test public void testMetadata() throws Exception { DataSetMetadata medatata = dataSetManager.getDataSetMetadata("test"); verify(customProvider).getDataSetMetadata(customDef); assertEquals(medatata.getNumberOfColumns(), 1); assertEquals(medatata.getColumnId(0), "name"); }
@Test public void testMetadata() throws Exception { DataSetMetadata medatata = dataSetManager.getDataSetMetadata("test"); verify(customProvider).getDataSetMetadata(customDef); assertEquals(medatata.getNumberOfColumns(), 1); assertEquals(medatata.getColumnId(0), "name"); }
@Test public void testColumnAlias() throws Exception { URL fileURL = Thread.currentThread().getContextClassLoader().getResource("expenseReports_columnalias.dset"); String json = IOUtils.toString(fileURL, StandardCharsets.UTF_8); SQLDataSetDef def = (SQLDataSetDef) jsonMarshaller.fromJson(json); dataSetDefRegistry.registerDataSetDef(def); String uuid = "expense_reports_columnalias"; DataSetMetadata metadata = dataSetManager.getDataSetMetadata(uuid); assertThat(metadata.getNumberOfColumns()).isEqualTo(3); assertThat(metadata.getColumnId(0)).isEqualTo("Id"); assertThat(metadata.getColumnId(1)).isEqualTo("Employee"); assertThat(metadata.getColumnId(2)).isEqualTo("Amount"); DataSet dataSet = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(uuid) .filter("id", FilterFactory.notNull()) .filter("amount", OR(greaterThan(0), lowerThan(1000))) .group("employee") .column("EMPLOYEE", "employee") .column("id", AggregateFunctionType.COUNT, "id") .column("AMOUNT", AggregateFunctionType.SUM, "amount") .sort("id", SortOrder.ASCENDING) .buildLookup()); assertThat(dataSet.getColumns().size()).isEqualTo(3); assertNotNull(dataSet.getColumnById("ID")); assertNotNull(dataSet.getColumnById("EMPLOYEE")); assertNotNull(dataSet.getColumnById("AMOUNT")); }
@Test public void testFilters() throws Exception { URL fileURL = Thread.currentThread().getContextClassLoader().getResource("expenseReports_filtered.dset"); String json = IOUtils.toString(fileURL, StandardCharsets.UTF_8); SQLDataSetDef def = (SQLDataSetDef) jsonMarshaller.fromJson(json); dataSetDefRegistry.registerDataSetDef(def); final String uuid = "expense_reports_filtered"; DataSetMetadata metadata = dataSetManager.getDataSetMetadata(uuid); assertThat(metadata.getNumberOfColumns()).isEqualTo(5); if (!testSettings.isMonetDB()) { assertThat(metadata.getEstimatedSize()).isEqualTo(666); } DataSet dataSet = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(uuid) .group(COLUMN_DEPARTMENT) .column(COLUMN_DEPARTMENT) .column(COLUMN_EMPLOYEE) .column(COLUMN_AMOUNT, AggregateFunctionType.SUM) .sort(COLUMN_DEPARTMENT, SortOrder.DESCENDING) .buildLookup()); assertDataSetDefinition(dataSet, uuid); assertDataSetValues(dataSet, dataSetFormatter, new String[][]{ {"Services", "Jamie Gilbeau", "792.59"}, {"Engineering", "Roxie Foraker", "2,120.55"} }, 0); }
@Test public void testSQLDataSet() throws Exception { String testDsetFile = testSettings.getExpenseReportsSqlDsetFile(); URL fileURL = Thread.currentThread().getContextClassLoader().getResource(testDsetFile); String json = IOUtils.toString(fileURL, StandardCharsets.UTF_8); SQLDataSetDef def = (SQLDataSetDef) jsonMarshaller.fromJson(json); dataSetDefRegistry.registerDataSetDef(def); DataSetMetadata metadata = dataSetManager.getDataSetMetadata("expense_reports_sql"); assertThat(metadata.getNumberOfColumns()).isEqualTo(3); assertThat(metadata.getNumberOfRows()).isEqualTo(6); final String uuid = "expense_reports_sql"; DataSet dataSet = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(uuid) .filter(COLUMN_AMOUNT, FilterFactory.lowerThan(1000)) .group(COLUMN_EMPLOYEE) .column(COLUMN_EMPLOYEE) .column(COLUMN_AMOUNT, AggregateFunctionType.SUM) .sort(COLUMN_EMPLOYEE, SortOrder.ASCENDING) .buildLookup()); assertDataSetDefinition(dataSet, uuid); assertDataSetValues(dataSet, dataSetFormatter, new String[][]{ {"Jamie Gilbeau", "792.59"}, {"Roxie Foraker", "1,020.45"} }, 0); }
@Test public void testSQLDataSet() throws Exception { String testDsetFile = testSettings.getExpenseReportsSqlDsetFile(); URL fileURL = Thread.currentThread().getContextClassLoader().getResource(testDsetFile); String json = IOUtils.toString(fileURL); SQLDataSetDef def = (SQLDataSetDef) jsonMarshaller.fromJson(json); dataSetDefRegistry.registerDataSetDef(def); DataSetMetadata metadata = dataSetManager.getDataSetMetadata("expense_reports_sql"); assertThat(metadata.getNumberOfColumns()).isEqualTo(3); assertThat(metadata.getNumberOfRows()).isEqualTo(6); final String uuid = "expense_reports_sql"; DataSet dataSet = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(uuid) .filter(COLUMN_AMOUNT, FilterFactory.lowerThan(1000)) .group(COLUMN_EMPLOYEE) .column(COLUMN_EMPLOYEE) .column(COLUMN_AMOUNT, AggregateFunctionType.SUM) .sort(COLUMN_EMPLOYEE, SortOrder.ASCENDING) .buildLookup()); assertDataSetDefinition(dataSet, uuid); assertDataSetValues(dataSet, dataSetFormatter, new String[][]{ {"Jamie Gilbeau", "792.59"}, {"Roxie Foraker", "1,020.45"} }, 0); }
@Test public void testFilters() throws Exception { URL fileURL = Thread.currentThread().getContextClassLoader().getResource("expenseReports_filtered.dset"); String json = IOUtils.toString(fileURL); SQLDataSetDef def = (SQLDataSetDef) jsonMarshaller.fromJson(json); dataSetDefRegistry.registerDataSetDef(def); final String uuid = "expense_reports_filtered"; DataSetMetadata metadata = dataSetManager.getDataSetMetadata(uuid); assertThat(metadata.getNumberOfColumns()).isEqualTo(5); if (!testSettings.isMonetDB()) { assertThat(metadata.getEstimatedSize()).isEqualTo(666); } DataSet dataSet = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(uuid) .group(COLUMN_DEPARTMENT) .column(COLUMN_DEPARTMENT) .column(COLUMN_EMPLOYEE) .column(COLUMN_AMOUNT, AggregateFunctionType.SUM) .sort(COLUMN_DEPARTMENT, SortOrder.DESCENDING) .buildLookup()); assertDataSetDefinition(dataSet, uuid); assertDataSetValues(dataSet, dataSetFormatter, new String[][]{ {"Services", "Jamie Gilbeau", "792.59"}, {"Engineering", "Roxie Foraker", "2,120.55"} }, 0); }
@Test public void testColumnSet() throws Exception { URL fileURL = Thread.currentThread().getContextClassLoader().getResource("expenseReports_columnset.dset"); String json = IOUtils.toString(fileURL); SQLDataSetDef def = (SQLDataSetDef) jsonMarshaller.fromJson(json); dataSetDefRegistry.registerDataSetDef(def); DataSetMetadata metadata = dataSetManager.getDataSetMetadata("expense_reports_columnset"); assertThat(metadata.getNumberOfColumns()).isEqualTo(4); if (!testSettings.isMonetDB()) { assertThat(metadata.getEstimatedSize()).isEqualTo(4300); } final String uuid = "expense_reports_columnset"; DataSet dataSet = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(uuid) .buildLookup()); assertThat(dataSet.getColumns().size()).isEqualTo(4); assertThat(dataSet.getValueAt(0, 0)).isEqualTo("Engineering"); assertThat(dataSet.getValueAt(0, 1)).isEqualTo("Roxie Foraker"); assertThat(dataSet.getValueAt(0, 2)).isEqualTo(120.35d); assertThat(dataSetFormatter.formatValueAt(dataSet, 0, 3)).isEqualTo("12/11/15 12:00"); assertDataSetDefinition(dataSet, uuid); }
@Test public void testColumnAlias() throws Exception { URL fileURL = Thread.currentThread().getContextClassLoader().getResource("expenseReports_columnalias.dset"); String json = IOUtils.toString(fileURL); SQLDataSetDef def = (SQLDataSetDef) jsonMarshaller.fromJson(json); dataSetDefRegistry.registerDataSetDef(def); String uuid = "expense_reports_columnalias"; DataSetMetadata metadata = dataSetManager.getDataSetMetadata(uuid); assertThat(metadata.getNumberOfColumns()).isEqualTo(3); assertThat(metadata.getColumnId(0)).isEqualTo("Id"); assertThat(metadata.getColumnId(1)).isEqualTo("Employee"); assertThat(metadata.getColumnId(2)).isEqualTo("Amount"); DataSet dataSet = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(uuid) .filter("id", FilterFactory.notNull()) .filter("amount", OR(greaterThan(0), lowerThan(1000))) .group("employee") .column("EMPLOYEE", "employee") .column("id", AggregateFunctionType.COUNT, "id") .column("AMOUNT", AggregateFunctionType.SUM, "amount") .sort("id", SortOrder.ASCENDING) .buildLookup()); assertThat(dataSet.getColumns().size()).isEqualTo(3); assertNotNull(dataSet.getColumnById("ID")); assertNotNull(dataSet.getColumnById("EMPLOYEE")); assertNotNull(dataSet.getColumnById("AMOUNT")); }
@Test public void testDataSetMetadataColumns() throws Exception { DataSetMetadata result = dataSetManager.getDataSetMetadata(EXPENSE_REPORTS);
@Test public void testDataSetMetadataColumns() throws Exception { DataSetMetadata result = dataSetManager.getDataSetMetadata(EXPENSE_REPORTS);