@SuppressWarnings( "unchecked" ) public List<AggregationType> getAggregationList() { return (List<AggregationType>) getProperty( IPhysicalColumn.AGGREGATIONLIST_PROPERTY ); }
public DataType getDataType() { return (DataType) getProperty( IPhysicalColumn.DATATYPE_PROPERTY ); }
public AggregationType getAggregationType() { return (AggregationType) getProperty( IPhysicalColumn.AGGREGATIONTYPE_PROPERTY ); }
public FieldType getFieldType() { return (FieldType) getProperty( IPhysicalColumn.FIELDTYPE_PROPERTY ); }
public Object getAttribute( int rowNo, int columnNo, String attributeName ) { // TODO support OLAP if ( rowNo == 0 && columnNo < columns.size() ) { LogicalColumn column = columns.get( columnNo ).getLogicalColumn(); return column.getProperty( attributeName ); } return null; }
"InlineEtlQueryExecutor.ERROR_0001_FAILED_TO_LOCATE_COLUMN", seg[0], seg[1] ) ); //$NON-NLS-1$ String fieldName = (String) col.getProperty( InlineEtlPhysicalColumn.FIELD_NAME ); AggregationType agg = null; if ( seg.length > 2 ) {
if ( contextName.equals( col.getProperty( SqlPhysicalColumn.TARGET_COLUMN ) ) ) { c = col; break;
xml.append( olapHierarchy.getPrimaryKey().getProperty( SqlPhysicalColumn.TARGET_COLUMN ) ); xml.append( "\"" ); //$NON-NLS-1$ XMLHandler.appendReplacedChars( xml, (String) column.getProperty( SqlPhysicalColumn.TARGET_COLUMN ) ); xml.append( "\"" ); //$NON-NLS-1$ if ( column != null ) { xml.append( " ordinalColumn=\"" ); //$NON-NLS-1$ XMLHandler.appendReplacedChars( xml, (String) column.getProperty( SqlPhysicalColumn.TARGET_COLUMN ) ); xml.append( "\"" ); //$NON-NLS-1$ if ( column != null ) { xml.append( " captionColumn=\"" ); //$NON-NLS-1$ XMLHandler.appendReplacedChars( xml, (String) column.getProperty( SqlPhysicalColumn.TARGET_COLUMN ) ); xml.append( "\"" ); //$NON-NLS-1$ .getProperty( SqlPhysicalColumn.TARGET_COLUMN ) ); xml.append( "\"" ); //$NON-NLS-1$ XMLHandler.appendReplacedChars( xml, (String) keyColumn.getProperty( SqlPhysicalColumn.TARGET_COLUMN ) ); xml.append( "\"" ); //$NON-NLS-1$ } else { XMLHandler.appendReplacedChars( xml, (String) businessColumn.getProperty( SqlPhysicalColumn.TARGET_COLUMN ) ); xml.append( "\"" ); //$NON-NLS-1$ String formatString = (String) businessColumn.getProperty( "mask" ); //$NON-NLS-1$ if ( !StringUtils.isEmpty( formatString ) ) { xml.append( " formatString=\"" ); //$NON-NLS-1$
join += "."; //$NON-NLS-1$ join += databaseMeta.quoteField( (String) relation.relation.getFromColumn().getProperty( SqlPhysicalColumn.TARGET_COLUMN ) ); join += "."; //$NON-NLS-1$ join += databaseMeta.quoteField( (String) relation.relation.getToColumn().getProperty( SqlPhysicalColumn.TARGET_COLUMN ) );
if ( ( column.getProperty( SqlPhysicalColumn.TARGET_COLUMN_TYPE ) == TargetColumnType.COLUMN_NAME ) && fieldName.equals( column.getProperty( SqlPhysicalColumn.TARGET_COLUMN ) ) ) {
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() ) ); } }
Map<LogicalTable, String> tableAliases, Map<String, Object> parameters, boolean genAsPreparedStatement, DatabaseMeta databaseMeta, String locale ) { String targetColumn = (String) column.getLogicalColumn().getProperty( SqlPhysicalColumn.TARGET_COLUMN ); LogicalTable logicalTable = column.getLogicalColumn().getLogicalTable(); if ( column.getLogicalColumn().getProperty( SqlPhysicalColumn.TARGET_COLUMN_TYPE ) == TargetColumnType.OPEN_FORMULA ) {
join += "."; //$NON-NLS-1$ join += databaseMeta.quoteField( (String) relation.getFromColumn().getProperty( SqlPhysicalColumn.TARGET_COLUMN ) ); join += databaseMeta.quoteField( (String) relation.getToColumn().getProperty( SqlPhysicalColumn.TARGET_COLUMN ) ); } else { throw new PentahoMetadataException( Messages.getErrorString(
public static SQLAndAliasedTables getSelectionSQL( LogicalModel LogicalModel, AliasedSelection selection, DatabaseMeta databaseMeta, String locale ) { String columnStr = (String) selection.getLogicalColumn().getProperty( SqlPhysicalColumn.TARGET_COLUMN ); if ( selection.getLogicalColumn().getProperty( SqlPhysicalColumn.TARGET_COLUMN_TYPE ) == TargetColumnType.OPEN_FORMULA ) {
if ( column.getProperty( "lookup" ) == null ) { //$NON-NLS-1$ mql += "<selection><view>" + view.getId() + "</view><column>" + column.getId() + "</column></selection>"; //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ mql += String lookup = (String) column.getProperty( "lookup" ); //$NON-NLS-1$
Object obj = c.getProperty( "alignment" ); //$NON-NLS-1$ if ( obj instanceof Alignment ) { if ( obj == Alignment.LEFT ) { obj = c.getProperty( "mask" ); //$NON-NLS-1$ if ( obj != null ) { col.setFormatMask( (String) obj );
theMeasureMD.setName( theMeasure.getName() ); theMeasureMD.setFormat( (String) theMeasure.getLogicalColumn().getProperty( "mask" ) ); //$NON-NLS-1$ theMeasureMD.setDefaultAggregation( theMeasure.getLogicalColumn().getAggregationType() ); String possibleMeasureName = theMeasure.getLogicalColumn().getId(); Object formatMask = col.getProperty( "mask" ); String colName = col.getName( workspaceHelper.getLocale() ); AggregationType aggType = col.getAggregationType();
if ( col.getProperty( "mask" ) != null ) { olapCol.setProperty( "mask", col.getProperty( "mask" ) ); } 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$ } }
Boolean hidden = (Boolean) column.getProperty( "hidden" ); //$NON-NLS-1$ if ( hidden != null && hidden ) { continue;