if ( type.equalsIgnoreCase( DataType.STRING.getName() ) && theOperator == Operator.EQUAL ) { theOperator = Operator.EXACTLY_MATCHES; if ( !enforceParameters && type.equalsIgnoreCase( DataType.STRING.getName() ) ) { for ( int idx = 0; idx < val.length; idx++ ) { val[idx] = "\"" + val[idx] + "\""; //$NON-NLS-1$ //$NON-NLS-2$ "[" + parentId + "." + elementId + ( StringUtils.isEmpty( selectedAggregation ) ? "" : "." + selectedAggregation ) + "]"; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$ //$NON-NLS-5$; if ( type.equals( DataType.DATE.getName() ) ) { if ( enforceParameters ) {
info.put( "colName", resultSet.getMetaData().getColumnHeaders()[ 0 ][ i ] ); //$NON-NLS-1$ DataType type = (DataType) resultSet.getMetaData().getAttribute( 0, i, IPhysicalColumn.DATATYPE_PROPERTY ); info.put( "colType", type.getName().toUpperCase() ); //$NON-NLS-1$ LocalizedString name = (LocalizedString) resultSet.getMetaData().getAttribute( 0, i, Concept.NAME_PROPERTY ); if ( name != null && locale != null ) {
if ( type.equalsIgnoreCase( DataType.STRING.getName() ) && theOperator == Operator.EQUAL ) { theOperator = Operator.EXACTLY_MATCHES; if ( type.equalsIgnoreCase( DataType.STRING.getName() ) ) { for ( int idx = 0; idx < val.length; idx++ ) { val[ idx ] = "\"" + val[ idx ] + "\""; //$NON-NLS-1$ //$NON-NLS-2$ String columnName = "[" + getCategory() + "." + getColumn() + "]"; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$; if ( type.equals( DataType.DATE.getName() ) ) { if ( enforceParameters ) {
protected int convertDataType( ColumnInfo ci ) { if ( ci != null && ci.getDataType() != null ) { switch ( ci.getDataType() ) { case NUMERIC: if ( ci.getPrecision() <= 0 ) { return ValueMetaInterface.TYPE_INTEGER; } else { return ValueMetaInterface.TYPE_NUMBER; } default: return ValueMetaBase.getType( ci.getDataType().getName() ); } } else { return ValueMetaInterface.TYPE_STRING; } }
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; }
col.setType( c.getDataType().getName().toUpperCase() ); col.setCategory( category.getId() );
@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$ } }