public Object getSelectedMax() { if (selectedMax == -1) { return new Date((long) rangeMax); } if (ColumnType.DATE.equals(dataColumnMax.getColumnType())) { return new Date((long) selectedMax); } else if (ColumnType.NUMBER.equals(dataColumnMax.getColumnType())) { return (long) selectedMax; } else { return null; } }
public Object getSelectedMin() { if (selectedMin == -1) { return new Date((long) rangeMin); } if (ColumnType.DATE.equals(dataColumnMin.getColumnType())) { return new Date((long) selectedMin); } else if (ColumnType.NUMBER.equals(dataColumnMin.getColumnType())) { return (long) selectedMin; } else { return null; } }
String formatValue(double val, DataColumn dataColumn) { if (ColumnType.DATE.equals(dataColumn.getColumnType())) { Date date = new Date((long) val); return super.formatValue(date, dataColumn); } else if (ColumnType.NUMBER.equals(dataColumn.getColumnType())) { return super.formatValue(val, dataColumn); } else { return Double.toString(val); } } }
String formatValue(double val, DataColumn dataColumn) { if (ColumnType.DATE.equals(dataColumn.getColumnType())) { Date date = new Date((long) val); return super.formatValue(date, dataColumn); } else if (ColumnType.NUMBER.equals(dataColumn.getColumnType())) { return super.formatValue(val, dataColumn); } else { return Double.toString(val); } } }
protected void _setEmptyRowAt(int row, boolean insert) { for (int i = 0; i < columns.size(); i++) { DataColumn column = columns.get(i); if (ColumnType.DATE.equals(column.getColumnType())) { _setValueAt(row, i, new Date(), insert); } else if (ColumnType.NUMBER.equals(column.getColumnType())) { _setValueAt(row, i, 0d, insert); } else { _setValueAt(row, i, "", insert); } } }
protected void _setEmptyRowAt(int row, boolean insert) { for (int i = 0; i < columns.size(); i++) { DataColumn column = columns.get(i); if (ColumnType.DATE.equals(column.getColumnType())) { _setValueAt(row, i, new Date(), insert); } else if (ColumnType.NUMBER.equals(column.getColumnType())) { _setValueAt(row, i, 0d, insert); } else { _setValueAt(row, i, "", insert); } } }
public Object convert(DataColumn column, Object value) { if (ColumnType.NUMBER.equals(column.getColumnType())) { return convertToDouble(value); } if (ColumnType.DATE.equals(column.getColumnType())) { return convertToDate(value); } return convertToString(value); }
public Object convert(DataColumn column, Object value) { if (ColumnType.NUMBER.equals(column.getColumnType())) { return convertToDouble(value); } if (ColumnType.DATE.equals(column.getColumnType())) { return convertToDate(value); } return convertToString(value); }
private ValidationError checkTypes(DataSet dataSet, ColumnType[] types) { for (int i = 0; i < dataSet.getColumns().size(); i++) { ColumnType columnType = dataSet.getColumnByIndex(i).getColumnType(); if (i < types.length && !columnType.equals(types[i])) { return createValidationError(ERROR_COLUMN_TYPE, i, types[i], columnType); } } return null; }
private ValidationError checkTypes(DataSet dataSet, ColumnType[] types) { for (int i = 0; i < dataSet.getColumns().size(); i++) { ColumnType columnType = dataSet.getColumnByIndex(i).getColumnType(); if (i < types.length && !columnType.equals(types[i])) { return createValidationError(ERROR_COLUMN_TYPE, i, types[i], columnType); } } return null; }
public DataSetMetadataImpl(DataSetImpl dataSet) { this.definition = dataSet.getDefinition(); this.uuid = dataSet.uuid; this.numberOfRows = dataSet.getRowCount(); this.estimatedSize = (int) dataSet.getEstimatedSize(); this.numberOfColumns = dataSet.getColumns().size(); for (DataColumn column : dataSet.getColumns()) { columnIds.add(column.getId()); columnTypes.add(column.getColumnType()); } }
public DataSetMetadataImpl(DataSetImpl dataSet) { this.definition = dataSet.getDefinition(); this.uuid = dataSet.uuid; this.numberOfRows = dataSet.getRowCount(); this.estimatedSize = (int) dataSet.getEstimatedSize(); this.numberOfColumns = dataSet.getColumns().size(); for (DataColumn column : dataSet.getColumns()) { columnIds.add(column.getId()); columnTypes.add(column.getColumnType()); } }
public String formatValueAt(DataSet dataSet, int row, int col) { Object val = dataSet.getValueAt(row, col); if (val == null) { return ""; } DataColumn column = dataSet.getColumnByIndex(col); if (ColumnType.DATE.equals(column.getColumnType())) { return dateFormat.format(val); } if (ColumnType.NUMBER.equals(column.getColumnType())) { return numberFormat.format(val); } return val.toString(); }
private void assertColumnIdAndType(DataSet result, String columnId, ColumnType columnType) { DataColumn amountCol = result.getColumnById(columnId); Assert.assertNotNull(amountCol); Assert.assertEquals(amountCol.getColumnType(), columnType); }
private JsonObject formatDataColumn(DataColumn dataColumn) throws JsonException { JsonObject columnJson = Json.createObject(); if (dataColumn != null) { columnJson.put(DATASET_COLUMN_ID, dataColumn.getId()); columnJson.put(DATASET_COLUMN_TYPE, dataColumn.getColumnType().toString()); columnJson.put(DATASET_COLUMN_VALUES, formatColumnValues(dataColumn, dataColumn.getValues())); } return columnJson; }
private JsonObject formatDataColumn(DataColumn dataColumn) throws JsonException { JsonObject columnJson = Json.createObject(); if (dataColumn != null) { columnJson.put(DATASET_COLUMN_ID, dataColumn.getId()); columnJson.put(DATASET_COLUMN_TYPE, dataColumn.getColumnType().toString()); columnJson.put(DATASET_COLUMN_VALUES, formatColumnValues(dataColumn, dataColumn.getValues())); } return columnJson; }
@Test public void dataSetCreated_whenCsvDataValid() throws Exception { final String CSV_DATA = "'Name','Weight','Date of birth'\n'Jan','75.64','1950-01-20'"; CSVFileStorage mockStorage = new MockCSVFileStorage(CSV_DATA); CSVParser testedParser = new CSVParser(csvDataSet, mockStorage); DataSet dset = testedParser.load(); assertEquals(1, dset.getRowCount()); assertEquals(ColumnType.LABEL, dset.getColumnById("Name").getColumnType()); assertEquals(ColumnType.NUMBER, dset.getColumnById("Weight").getColumnType()); assertEquals(ColumnType.DATE, dset.getColumnById("Date of birth").getColumnType()); }
@Test public void dataSetCreated_whenCsvDataValid() throws Exception { final String CSV_DATA = "'Name','Weight','Date of birth'\n'Jan','75.64','1950-01-20'"; CSVFileStorage mockStorage = new MockCSVFileStorage(CSV_DATA); CSVParser testedParser = new CSVParser(csvDataSet, mockStorage); DataSet dset = testedParser.load(); assertEquals(1, dset.getRowCount()); assertEquals(ColumnType.LABEL, dset.getColumnById("Name").getColumnType()); assertEquals(ColumnType.NUMBER, dset.getColumnById("Weight").getColumnType()); assertEquals(ColumnType.DATE, dset.getColumnById("Date of birth").getColumnType()); }
@Test public void stringFieldStartingWithNumber_shouldBeParsedAsLabel() throws Exception { final String CSV_DATA = "Age,Address\n" + "25,12 Downing street\n" + "75,White House 52"; CSVFileStorage mockStorage = new MockCSVFileStorage(CSV_DATA); CSVParser testedParser = new CSVParser(csvDataSet, mockStorage); DataSet dset = testedParser.load(); assertEquals(2, dset.getRowCount()); assertEquals(ColumnType.NUMBER, dset.getColumnById("Age").getColumnType()); assertEquals(ColumnType.LABEL, dset.getColumnById("Address").getColumnType()); }
@Test public void stringFieldStartingWithNumber_shouldBeParsedAsLabel() throws Exception { final String CSV_DATA = "Age,Address\n" + "25,12 Downing street\n" + "75,White House 52"; CSVFileStorage mockStorage = new MockCSVFileStorage(CSV_DATA); CSVParser testedParser = new CSVParser(csvDataSet, mockStorage); DataSet dset = testedParser.load(); assertEquals(2, dset.getRowCount()); assertEquals(ColumnType.NUMBER, dset.getColumnById("Age").getColumnType()); assertEquals(ColumnType.LABEL, dset.getColumnById("Address").getColumnType()); }