/** * @return the display names of all the business columns */ public List<String> getColumnNames( String locale ) { List<String> list = new ArrayList<String>(); for ( LogicalColumn column : logicalColumns ) { list.add( column.getName( locale ) ); } return list; }
public LogicalColumn findLogicalColumn( String locale, String thisName ) { if ( referenceColumn != null && referenceColumn.getName( locale ).equalsIgnoreCase( thisName ) ) { return referenceColumn; } for ( int i = 0; i < logicalColumns.size(); i++ ) { LogicalColumn column = (LogicalColumn) logicalColumns.get( i ); if ( column.getName( locale ).equalsIgnoreCase( thisName ) ) { return column; } } return null; }
private boolean columnMatches( final ModelerWorkspace workspace, final String column, final LogicalColumn logicalColumn ) { return column.equalsIgnoreCase( logicalColumn.getName( workspace.getWorkspaceHelper().getLocale() ) ); }
/** * TODO: This should use IDs vs Names * * @param locale * @return */ public String[] getUnusedColumnNames( String locale ) { List<String> names = logicalTable.getColumnNames( locale ); for ( int i = names.size() - 1; i >= 0; i-- ) { String columnName = (String) names.get( i ); for ( int m = 0; m < olapMeasures.size(); m++ ) { OlapMeasure measure = (OlapMeasure) olapMeasures.get( m ); if ( measure.getLogicalColumn().getName( locale ).equals( columnName ) ) { names.remove( i ); } } } return (String[]) names.toArray( new String[ names.size() ] ); }
public LogicalColumn findLogicalColumn( String id ) { LogicalColumn col = null; for ( LogicalColumn c : getLogicalModel( currentModelerPerspective ).getLogicalTables().get( 0 ) .getLogicalColumns() ) { if ( c.getName( workspaceHelper.getLocale() ).equals( id ) ) { col = c; break; } } return col; }
protected LogicalColumn locateLogicalColumn( final ModelerWorkspace workspace, final String columnName ) { String locale = workspace.getWorkspaceHelper().getLocale(); LogicalModel logicalModel = workspace.getLogicalModel( ModelerPerspective.ANALYSIS ); logicalModel.getLogicalTables(); for ( LogicalTable logicalTable : logicalModel.getLogicalTables() ) { for ( LogicalColumn logicalColumn : logicalTable.getLogicalColumns() ) { if ( logicalColumn.getName( locale ).equalsIgnoreCase( columnName ) || logicalColumn.getName( locale ).equalsIgnoreCase( beautify( columnName ) ) ) { return logicalColumn; } } } return null; }
private MeasureMetaData locateMeasure( final ModelerWorkspace workspace, final String column ) { MeasuresCollection measures = workspace.getModel().getMeasures(); for ( MeasureMetaData measure : measures ) { if ( measure.getLogicalColumn().getName( workspace.getWorkspaceHelper().getLocale() ).equals( column ) || measure.getLogicalColumn().getName( workspace.getWorkspaceHelper().getLocale() ).equals( beautify( column ) ) ) { return measure; } } return null; }
protected LevelMetaData locateLevel( final ModelerWorkspace workspace, final String column ) throws ModelerException { String locale = workspace.getWorkspaceHelper().getLocale(); workspace.getModel().getDimensions(); for ( DimensionMetaData dimensionMetaData : workspace.getModel().getDimensions() ) { for ( HierarchyMetaData hierarchyMetaData : dimensionMetaData ) { for ( LevelMetaData levelMetaData : hierarchyMetaData ) { if ( levelMetaData.getLogicalColumn().getName( locale ).equalsIgnoreCase( column ) || levelMetaData.getLogicalColumn().getName( locale ).equals( beautify( column ) ) ) { return levelMetaData; } } } } return null; }
OlapHierarchyLevel olapHierarchyLevel = (OlapHierarchyLevel) hierarchyLevels.get( hl ); if ( levelName.equals( buffer.toString() + olapHierarchyLevel.getName() + "]" ) ) { return olapHierarchyLevel.getReferenceColumn().getName( locale );
LocalizedString name = col.getName(); if ( name != null && contextName.equals( name.getString( locale ) ) ) { c = col;
/** * 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() ); } } }
private void addFieldsToTables( Domain domain, AbstractModelList<JoinTableModel> availableTables ) { String locale = LocalizedString.DEFAULT_LOCALE; Outter: for ( JoinTableModel table : availableTables ) { for ( LogicalTable tbl : domain.getLogicalModels().get( 0 ).getLogicalTables() ) { if ( tbl.getPhysicalTable().getProperty( "target_table" ).equals( table.getName() ) ) { for ( LogicalColumn col : tbl.getLogicalColumns() ) { JoinFieldModel field = new JoinFieldModel(); field.setName( col.getName( locale ) ); field.setParentTable( table ); table.getFields().add( field ); } continue Outter; } } } }
@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$ } }
new MemberPropertyMetaData( theLevelMD, lc.getName( workspaceHelper.getLocale() ) ); memberProp.setLogicalColumn( lc ); memberProp.setDescription( lc.getDescription( workspaceHelper.getLocale() ) ); theMeasureMD.setName( theMeasure.getLogicalColumn().getName( workspaceHelper.getLocale() ) ); } else { theMeasureMD.setName( theMeasure.getName() ); Set<String> locales = lCol.getName().getLocales(); String[] stringLocals = locales.toArray( new String[] {} ); if ( stringLocals != null && stringLocals.length > 0 ) { String colName = col.getName( workspaceHelper.getLocale() ); AggregationType aggType = col.getAggregationType();
col.setName( c.getName( getLocale() ) ); col.setId( c.getId() ); if ( c.getFieldType() != null ) {
LocalizedString newName = appendOlap( col.getName() ); olapCol.setName( newName );