private void activeSequence() { boolean useDatabase = wUseDatabase.getSelection(); DatabaseMeta databaseMeta = transMeta.findDatabase( wConnection.getText() ); wbSequence.setEnabled( databaseMeta == null ? false : useDatabase && databaseMeta.supportsSequences() ); }
public void modifyText( ModifyEvent e ) { // We have new content: change ci connection: ci = transMeta.findDatabase( wConnection.getText() ); setFlags(); } } );
public MonetDBAgileMart( StepMeta stepMeta, StepDataInterface stepDataInterface, int copyNr, TransMeta transMeta, Trans trans ) { super( stepMeta, stepDataInterface, copyNr, transMeta, trans ); // TODO - pull "AgileBI" from configuration String connection = MonetDBAgileMartMeta.getStringProperty( "AgileBIDatabase", "AgileBI" ); ( (MonetDBAgileMartMeta) stepMeta.getStepMetaInterface() ).setDatabaseMeta( transMeta .findDatabase( connection ) ); }
public void setFlags() { wlIgnoreFlagField.setEnabled( wErrorIgnored.getSelection() ); wIgnoreFlagField.setEnabled( wErrorIgnored.getSelection() ); DatabaseMeta databaseMeta = transMeta.findDatabase( wConnection.getText() ); boolean hasErrorHandling = transMeta.findStep( stepname ).isDoingErrorHandling(); // Can't use batch yet when grabbing auto-generated keys... // Only enable batch option when not returning keys. // If we are on PostgreSQL (and look-a-likes), error handling is not supported. (PDI-366) // boolean enableBatch = wBatch.getSelection() && !transMeta.isUsingUniqueConnections(); enableBatch = enableBatch && !( databaseMeta != null && databaseMeta.supportsErrorHandlingOnBatchUpdates() && hasErrorHandling ); }
protected void getFunction() { DatabaseMeta databaseMeta = transMeta.findDatabase( wConnection.getText() ); if ( databaseMeta == null ) { showDatabaseWarning( false ); return; } SapFunctionBrowser browser = new SapFunctionBrowser( shell, transMeta, SWT.NONE, databaseMeta, wFunction.getText() ); function = browser.open(); if ( function != null ) { get(); } }
public void modifyText( ModifyEvent e ) { // We have new content: change ci connection: ci = transMeta.findDatabase( wConnection.getText() ); setAutoincUse(); setSequence(); input.setChanged(); } } );
private void getInfo( GetTableNamesMeta info ) { info.setDatabase( transMeta.findDatabase( wConnection.getText() ) ); info.setSchemaName( wschemaname.getText() ); info.setTablenameFieldName( wTablenameField.getText() ); info.setSQLCreationFieldName( wSQLCreationField.getText() ); info.setObjectTypeFieldName( wObjectTypeField.getText() ); info.setIsSystemObjectFieldName( wisSystemObjectField.getText() ); info.setIncludeCatalog( wincludeCatalog.getSelection() ); info.setIncludeSchema( wincludeSchema.getSelection() ); info.setIncludeTable( wincludeTable.getSelection() ); info.setIncludeView( wincludeView.getSelection() ); info.setIncludeProcedure( wincludeProcedure.getSelection() ); info.setIncludeSynonym( wincludeSynonym.getSelection() ); info.setAddSchemaInOut( waddSchemaInOutput.getSelection() ); info.setDynamicSchema( wdynamicSchema.getSelection() ); info.setSchemaFieldName( wSchemaField.getText() ); }
private String[] getModelList() { String[] modelList = null; if ( addConnectionLine.getText() != null ) { DatabaseMeta dbMeta = transMeta.findDatabase( addConnectionLine.getText() ); if ( dbMeta != null ) { OpenERPObjectInputData data = null; try { data = new OpenERPObjectInputData( dbMeta ); data.helper.StartSession(); modelList = data.helper.getModelList(); } catch ( Exception e ) { return null; } } } return modelList; }
private String[] getModelList() { String[] objectList = null; // Fill object name if ( addConnectionLine.getText() != null ) { DatabaseMeta dbMeta = transMeta.findDatabase( addConnectionLine.getText() ); if ( dbMeta != null ) { OpenERPObjectDeleteData data = null; try { data = new OpenERPObjectDeleteData( dbMeta ); data.helper.StartSession(); objectList = data.helper.getModelList(); } catch ( Exception e ) { return null; } } } return objectList; }
private String[] getModelList() { String[] objectList = null; // Fill object name if ( addConnectionLine.getText() != null ) { DatabaseMeta dbMeta = transMeta.findDatabase( addConnectionLine.getText() ); if ( dbMeta != null ) { OpenERPObjectOutputData data = null; try { data = new OpenERPObjectOutputData( dbMeta ); data.helper.StartSession(); objectList = data.helper.getModelList(); } catch ( Exception e ) { return null; } } } return objectList; }
private void getInfo( MondrianInputMeta meta ) { meta.setSQL( wSQL.getText() ); meta.setDatabaseMeta( transMeta.findDatabase( wConnection.getText() ) ); meta.setCatalog( wCatalog.getText() ); meta.setVariableReplacementActive( wVariables.getSelection() ); meta.setRole( wRole.getText() ); }
private void getInfo( TableInputMeta meta, boolean preview ) { meta.setSQL( preview && !Utils.isEmpty( wSQL.getSelectionText() ) ? wSQL.getSelectionText() : wSQL.getText() ); meta.setDatabaseMeta( transMeta.findDatabase( wConnection.getText() ) ); meta.setRowLimit( wLimit.getText() ); StreamInterface infoStream = input.getStepIOMeta().getInfoStreams().get( 0 ); infoStream.setStepMeta( transMeta.findStep( wDatefrom.getText() ) ); meta.setExecuteEachInputRow( wEachRow.getSelection() ); meta.setVariableReplacementActive( wVariables.getSelection() ); meta.setLazyConversionActive( wLazyConversion.getSelection() ); }
private void getInfo( PaloDimInputMeta myMeta ) throws KettleException { stepname = textStepName.getText(); List<PaloDimensionLevel> levels = new ArrayList<PaloDimensionLevel>(); for ( int i = 0; i < tableViewFields.table.getItemCount(); i++ ) { PaloDimensionLevel level = new PaloDimensionLevel( tableViewFields.table.getItem( i ).getText( 1 ), Integer .parseInt( tableViewFields.table.getItem( i ).getText( 2 ) ), tableViewFields.table.getItem( i ).getText( 3 ), tableViewFields.table.getItem( i ).getText( 4 ) ); levels.add( level ); } myMeta.setDatabaseMeta( transMeta.findDatabase( addConnectionLine.getText() ) ); myMeta.setLevels( levels ); myMeta.setDimension( comboDimension.getText() ); myMeta.setBaseElementsOnly( buttonBaseElementsOnly.getSelection() ); myMeta.setChanged( true ); }
protected void setupDatabaseMeta() { if ( this.getDatabaseMeta() == null ) { if ( getParentStepMeta() != null ) { TransMeta transMeta = getParentStepMeta().getParentTransMeta(); if ( transMeta != null ) { setDatabaseMeta( transMeta.findDatabase( transMeta.environmentSubstitute( getStringProperty( "AgileBIDatabase", "AgileBI" ) ) ) ); } } } }
protected void setupDatabaseMeta() { if ( this.getDatabaseMeta() == null ) { if ( getParentStepMeta() != null ) { TransMeta transMeta = getParentStepMeta().getParentTransMeta(); if ( transMeta != null ) { setDatabaseMeta( transMeta.findDatabase( transMeta.environmentSubstitute( getDbConnectionName() ) ) ); } } } }
protected void isConnectionSupported() { final String tableName = wTable.getText(), connectionName = wConnection.getText(); if ( !Utils.isEmpty( tableName ) ) { DatabaseMeta dbmeta = transMeta.findDatabase( connectionName ); if ( dbmeta != null && !dbmeta.getDatabaseInterface().supportsStandardTableOutput() ) { showUnsupportedConnectionMessageBox( dbmeta.getDatabaseInterface() ); } } }
private void getInfo( PaloCellInputMeta myMeta ) throws KettleException { stepname = textStepName.getText(); List<DimensionField> fields = new ArrayList<DimensionField>(); for ( int i = 0; i < tableViewFields.table.getItemCount(); i++ ) { DimensionField field = new DimensionField( tableViewFields.table.getItem( i ).getText( 1 ), tableViewFields.table.getItem( i ) .getText( 2 ), tableViewFields.table.getItem( i ).getText( 3 ) ); fields.add( field ); } myMeta.setDatabaseMeta( transMeta.findDatabase( addConnectionLine.getText() ) ); myMeta.setCubeMeasureName( new DimensionField( "Measure", textMeasureName.getText(), comboMeasureType.getText() ) ); myMeta.setLevels( fields ); myMeta.setCube( comboCube.getText() ); myMeta.setChanged( true ); }
private void ok() { if ( Utils.isEmpty( wStepname.getText() ) ) { return; } input.setDatabase( transMeta.findDatabase( wConnection.getText() ) ); input.setSchemaname( wSchemaname.getText() ); input.setDynamicTablenameField( wTableName.getText() ); input.setResultFieldName( wResult.getText() ); stepname = wStepname.getText(); // return value if ( input.getDatabase() == null ) { MessageBox mb = new MessageBox( shell, SWT.OK | SWT.ICON_ERROR ); mb.setMessage( BaseMessages.getString( PKG, "TableExistsDialog.InvalidConnection.DialogMessage" ) ); mb.setText( BaseMessages.getString( PKG, "TableExistsDialog.InvalidConnection.DialogTitle" ) ); mb.open(); } dispose(); }
public void widgetSelected( SelectionEvent e ) { DatabaseMeta databaseMeta = transMeta.findDatabase( wConnection.getText() ); if ( databaseMeta != null ) { databaseMeta.shareVariablesWith( transMeta ); DatabaseDialog cid = getDatabaseDialog( shell ); cid.setDatabaseMeta( databaseMeta ); cid.setModalDialog( true ); if ( cid.open() != null ) { wConnection.removeAll(); addDatabases( wConnection, null ); selectDatabase( wConnection, databaseMeta.getName() ); } } } } );
@Test public void testFindDatabaseWithEncodedConnectionName() { DatabaseMeta dbMeta1 = new DatabaseMeta( "encoded_DBConnection", "Oracle", "localhost", "access", "test", "111", "test", "test" ); dbMeta1.setDisplayName( "encoded.DBConnection" ); meta.addDatabase( dbMeta1 ); DatabaseMeta dbMeta2 = new DatabaseMeta( "normalDBConnection", "Oracle", "localhost", "access", "test", "111", "test", "test" ); dbMeta2.setDisplayName( "normalDBConnection" ); meta.addDatabase( dbMeta2 ); DatabaseMeta databaseMeta = meta.findDatabase( dbMeta1.getDisplayName() ); assertNotNull( databaseMeta ); assertEquals( databaseMeta.getName(), "encoded_DBConnection" ); assertEquals( databaseMeta.getDisplayName(), "encoded.DBConnection" ); }