public LogicalColumn findLogicalColumn( String id ) { for ( LogicalColumn col : logicalColumns ) { if ( id.equals( col.getId() ) ) { return col; } } return null; }
public int hashCode() { return logicalColumn.getId().hashCode(); }
/** * searches the category for a specific column id. * * @param columnId * column to search for * * @return logical column object if found */ public LogicalColumn findLogicalColumn( String columnId ) { for ( LogicalColumn col : getLogicalColumns() ) { if ( columnId.equals( col.getId() ) ) { return col; } } return null; }
@Override public int hashCode() { if ( getLogicalColumn() != null ) { return getLogicalColumn().getId().hashCode(); } else { return formula.hashCode(); } }
/** * finds a logical column within the model. * * @param columnId the column to find * @return a logical column object. */ public LogicalColumn findLogicalColumn( String columnId ) { for ( LogicalTable table : getLogicalTables() ) { for ( LogicalColumn column : table.getLogicalColumns() ) { if ( columnId.equals( column.getId() ) ) { return column; } } } return null; }
public boolean equals( Object o ) { if ( o == null || o instanceof BaseAggregationMetaDataNode == false ) { return false; } BaseAggregationMetaDataNode f = (BaseAggregationMetaDataNode) o; if ( o == this ) { return true; } if ( f.getLogicalColumn() == null || this.getLogicalColumn() == null ) { return false; } if ( f.getLogicalColumn().getId().equals( this.getLogicalColumn().getId() ) ) { return true; } return false; }
/** * finds a logical column within the model. * * @param columnId the column to find * @return a logical column object. */ public LogicalColumn findLogicalColumnInCategories( String columnId ) { for ( Category cat : getCategories() ) { for ( LogicalColumn column : cat.getLogicalColumns() ) { if ( columnId.equals( column.getId() ) ) { return column; } } } return null; }
@Bindable public String getDescription() { if ( getLogicalColumn() != null && !description.equals( getLogicalColumn().getId() ) ) { return description; } else { return ""; } }
@Override protected void addSelectionToDocument( Document doc, Selection selection, Element selectionElement ) { AliasedSelection aliasedSelection = (AliasedSelection) selection; Category view = selection.getCategory(); LogicalColumn column = selection.getLogicalColumn(); Element element = null; if ( view != null && column != null ) { element = doc.createElement( "view" ); //$NON-NLS-1$ element.appendChild( doc.createTextNode( view.getId() ) ); selectionElement.appendChild( element ); element = doc.createElement( "column" ); //$NON-NLS-1$ element.appendChild( doc.createTextNode( column.getId() ) ); selectionElement.appendChild( element ); if ( aliasedSelection.getAlias() != null ) { element = doc.createElement( "alias" ); //$NON-NLS-1$ element.appendChild( doc.createTextNode( aliasedSelection.getAlias() ) ); selectionElement.appendChild( element ); } } else if ( aliasedSelection.getFormula() != null ) { element = doc.createElement( "formula" ); //$NON-NLS-1$ element.appendChild( doc.createTextNode( aliasedSelection.getFormula() ) ); selectionElement.appendChild( element ); } }
element.appendChild( doc.createTextNode( selection.getLogicalColumn().getId() ) ); orderElement.appendChild( element );
alias = databaseMeta.generateColumnAlias( i, selections.get( i ).getLogicalColumn().getId() ); columnsMap.put( alias, selections.get( i ).getLogicalColumn().getId() ); alias = databaseMeta.quoteField( alias ); } else { alias = databaseMeta.quoteField( selections.get( i ).getLogicalColumn().getId() );
if ( value.equals( businessColumn.getId() ) ) {
/** * 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() ); } } }
public Object clone() { LogicalColumn clone = new LogicalColumn(); clone.setId( getId() ); clone.setParent( getParent() ); clone.setInheritedConcept( getInheritedConcept() ); clone.setParentConcept( getParentConcept() ); // copy over properties for ( String key : getChildProperties().keySet() ) { clone.setProperty( key, getChildProperty( key ) ); } return clone; } }
protected void addSelectionToDocument( Document doc, Selection selection, Element selectionElement ) { addTextElement( doc, selectionElement, "view", selection.getCategory().getId() ); //$NON-NLS-1$ addTextElement( doc, selectionElement, "column", selection.getLogicalColumn().getId() ); //$NON-NLS-1$ if ( selection.getAggregationType() != null ) { addTextElement( doc, selectionElement, "aggregation", selection.getAggregationType().toString() ); //$NON-NLS-1$ } }
protected void addOrderByToDocument( Document doc, Order order, Element orderElement ) { // test that this is lower case addTextElement( doc, orderElement, "direction", order.getType().toString() ); //$NON-NLS-1$ addTextElement( doc, orderElement, "view_id", order.getSelection().getCategory().getId() ); //$NON-NLS-1$ addTextElement( doc, orderElement, "column_id", order.getSelection().getLogicalColumn().getId() ); //$NON-NLS-1$ if ( order.getSelection().getAggregationType() != null ) { addTextElement( doc, orderElement, "aggregation", order.getSelection().getAggregationType().toString() ); //$NON-NLS-1$ } }
@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$ } }
Column col = new Column(); col.setName( c.getName( getLocale() ) ); col.setId( c.getId() ); if ( c.getFieldType() != null ) { col.setFieldType( c.getFieldType().name() );
BusinessColumn column = model.findBusinessColumn( sel.getLogicalColumn().getId() ); org.pentaho.pms.mql.Selection legSel = new org.pentaho.pms.mql.Selection( column, convertToLegacy( sel.getAggregationType() ) ); aggStr = aggregation.getCode(); impl.addOrderBy( order.getSelection().getCategory().getId(), order.getSelection().getLogicalColumn().getId(), aggStr, order.getType() == Order.Type.ASC );
columnClone.setId( BaseModelerWorkspaceHelper.uniquify( columnClone.getId(), logicalColumns ) ); measureMetaData.setLogicalColumn( columnClone ); measureMetaData.setName( getName() );