@Bindable public AggregationType getDefaultAggregation() { if ( logicalColumn == null ) { return null; } if ( defaultAggregation == null ) { switch ( logicalColumn.getDataType() ) { case NUMERIC: defaultAggregation = AggregationType.SUM; break; default: defaultAggregation = AggregationType.COUNT; } } return defaultAggregation; }
/** * This is a utility method that looks into an old domain for the same column ids, and then copies over the old * metadata into the new. * * @param oldDomain * @param newDomain */ public void copyOverMetadata( Domain oldDomain, Domain newDomain ) { Category category = newDomain.getLogicalModels().get( 0 ).getCategories().get( 0 ); LogicalModel oldModel = oldDomain.getLogicalModels().get( 0 ); for ( LogicalColumn column : category.getLogicalColumns() ) { LogicalColumn oldColumn = oldModel.findLogicalColumn( column.getId() ); if ( oldColumn != null ) { column.setDataType( oldColumn.getDataType() ); column.setName( oldColumn.getName() ); column.setAggregationList( oldColumn.getAggregationList() ); column.setAggregationType( oldColumn.getAggregationType() ); } } }
DataType previousDataType = null; if ( logicalColumn != null ) { previousDataType = logicalColumn.getDataType(); DataType newDataType = logicalColumn.getDataType(); if ( previousDataType == null || previousDataType != newDataType ) { if ( logicalColumn.getDataType() == DataType.NUMERIC ) { setPossibleAggregations( getNumericAggregationTypes() ); setDefaultAggregation( AggregationType.SUM );
DataType dataTypeLevel = olapHierarchyLevel.getReferenceColumn().getDataType(); String typeDescLevel = null; switch ( dataTypeLevel ) { xml.append( "\"" ); //$NON-NLS-1$ DataType dataType = businessColumn.getDataType(); String typeDesc = null; switch ( dataType ) {
public FieldMetaData createFieldForParentWithNode( CategoryMetaData parent, AvailableField selectedField ) { FieldMetaData field = new FieldMetaData( parent, selectedField.getName(), "", selectedField.getDisplayName(), workspaceHelper .getLocale() ); //$NON-NLS-1$ ColumnBackedNode node = createColumnBackedNode( selectedField, ModelerPerspective.REPORTING ); field.setLogicalColumn( node.getLogicalColumn() ); field.setFieldTypeDesc( node.getLogicalColumn().getDataType().getName() ); switch ( node.getLogicalColumn().getDataType() ) { case DATE: field.setFormatstring( DataFormatHolder.DATE_FORMATS ); break; case NUMERIC: field.setFormatstring( DataFormatHolder.NUMBER_FORMATS ); break; case STRING: field.setFormatstring( DataFormatHolder.CONVERSION_FORMATS ); break; case BOOLEAN: case URL: case BINARY: case UNKNOWN: case IMAGE: default: break; } field.setFormat( "" ); return field; }
protected void doInputWiring( Query query, TransMeta transMeta ) { // // CSV FILE LOCATION AND FIELDS // InlineEtlPhysicalModel physicalModel = (InlineEtlPhysicalModel) query.getLogicalModel().getPhysicalModel(); CsvInputMeta csvinput = (CsvInputMeta) getStepMeta( transMeta, "CSV file input" ).getStepMetaInterface(); //$NON-NLS-1$ // the file name might need to be translated to the correct location here if ( csvFileLoc != null ) { csvinput.setFilename( csvFileLoc + physicalModel.getFileLocation() ); } else { csvinput.setFilename( physicalModel.getFileLocation() ); } csvinput.setDelimiter( physicalModel.getDelimiter() ); csvinput.setEnclosure( physicalModel.getEnclosure() ); csvinput.setHeaderPresent( physicalModel.getHeaderPresent() ); // update fields LogicalTable table = query.getLogicalModel().getLogicalTables().get( 0 ); csvinput.allocate( table.getLogicalColumns().size() ); for ( int i = 0; i < csvinput.getInputFields().length; i++ ) { // Update csv input LogicalColumn col = table.getLogicalColumns().get( i ); csvinput.getInputFields()[i] = new TextFileInputField(); String fieldName = (String) col.getProperty( InlineEtlPhysicalColumn.FIELD_NAME ); if ( logger.isDebugEnabled() ) { logger.debug( "FROM CSV: " + fieldName ); //$NON-NLS-1$ } csvinput.getInputFields()[i].setName( fieldName ); csvinput.getInputFields()[i].setType( convertType( col.getDataType() ) ); } }
col.setType( c.getDataType().getName().toUpperCase() ); col.setCategory( category.getId() ); DataType dataType = c.getDataType(); FieldType fieldType = c.getFieldType(); Object obj = c.getProperty( "alignment" ); //$NON-NLS-1$
String formula = condition.getCondition( logicalColumn.getDataType().name(), paramName ); Constraint constraint = new Constraint( combinationType, formula ); constraints.add( constraint ); DataType type = logicalColumn.getDataType(); String[] value = parameter.getValue(); org.pentaho.metadata.query.model.Parameter fullParam =
switch ( t.getLogicalColumn().getDataType() ) { case DATE: setFormatstring( DataFormatHolder.DATE_FORMATS );
olapCol.setLogicalTable( copiedTable ); olapCol.setPhysicalColumn( col.getPhysicalColumn() ); olapCol.setDataType( col.getDataType() ); olapCol.setAggregationType( col.getPhysicalColumn().getAggregationType() ); } else { if ( olapCol.getDataType().equals( DataType.NUMERIC ) ) { olapCol.setAggregationType( AggregationType.SUM ); } else { } else if ( olapCol.getDataType().equals( DataType.NUMERIC ) ) { olapCol.setProperty( "mask", "#" );
@SuppressWarnings( "deprecation" ) public void addColumn( final LogicalColumn column, final Element tableNode, final String locale ) { Element columnNode = tableNode.addElement( "column" ); //$NON-NLS-1$ if ( column.getId() != null ) { columnNode.addElement( "column_id" ).setText( column.getId() ); //$NON-NLS-1$ } if ( column.getName( locale ) != null ) { columnNode.addElement( "column_name" ).setText( column.getName( locale ) ); //$NON-NLS-1$ } if ( column.getDescription( locale ) != null ) { columnNode.addElement( "column_description" ).setText( column.getDescription( locale ) ); //$NON-NLS-1$ } if ( column.getFieldType() != null ) { // TODO this should take a locale String desc = column.getFieldType().getDescription(); desc = org.pentaho.pms.messages.Messages.getString( desc ); columnNode.addElement( "column_field_type" ).setText( desc ); //$NON-NLS-1$ } DataType dataType = column.getDataType(); if ( dataType != null ) { columnNode.addElement( "column_type" ).setText( dataType.getName() ); //$NON-NLS-1$ } if ( column.getProperty( "lookup" ) != null ) { //$NON-NLS-1$ columnNode.addElement( "column_lookup" ).setText( "true" ); //$NON-NLS-1$ //$NON-NLS-2$ } }