public DatabaseMeta getDatabaseInfo() { if ( wUsername.getText() != null && wUsername.getText().length() > 0 ) { databaseMeta.setUsername( wUsername.getText() ); } if ( wPassword.getText() != null && wPassword.getText().length() > 0 ) { databaseMeta.setPassword( wPassword.getText() ); } wTest.setEnabled( ( (BaseDatabaseMeta) databaseMeta.getDatabaseInterface() ).canTest() ); return databaseMeta; }
@Override public DatabaseMeta getTestObject() { DatabaseMeta db = new DatabaseMeta(); db.setObjectId( new LongObjectId( rand.nextInt( Integer.MAX_VALUE ) ) ); db.setName( UUID.randomUUID().toString() ); db.setHostname( UUID.randomUUID().toString() ); db.setUsername( UUID.randomUUID().toString() ); db.setPassword( UUID.randomUUID().toString() ); return db; }
public void setValues( String name, String type, String access, String host, String db, String port, String user, String pass ) { try { databaseInterface = getDatabaseInterface( type ); } catch ( KettleDatabaseException kde ) { throw new RuntimeException( "Database type not found!", kde ); } setName( name ); setAccessType( getAccessType( access ) ); setHostname( host ); setDBName( db ); setDBPort( port ); setUsername( user ); setPassword( pass ); setServername( null ); setChanged( false ); }
meta.setPassword( passwordBox.getValue() );
setPassword( "password" ); // Don't give away the password in the URL! String url = ""; try { r.addValue( val, ValueMetaInterface.TYPE_STRING, url ); list.add( r ); setPassword( pwd );
public void setDatabaseType( String type ) { DatabaseInterface oldInterface = databaseInterface; try { databaseInterface = getDatabaseInterface( type ); } catch ( KettleDatabaseException kde ) { throw new RuntimeException( "Database type [" + type + "] not found!", kde ); } setName( oldInterface.getName() ); setDisplayName( oldInterface.getDisplayName() ); setAccessType( oldInterface.getAccessType() ); setHostname( oldInterface.getHostname() ); setDBName( oldInterface.getDatabaseName() ); setDBPort( oldInterface.getDatabasePortNumberString() ); setUsername( oldInterface.getUsername() ); setPassword( oldInterface.getPassword() ); setServername( oldInterface.getServername() ); setDataTablespace( oldInterface.getDataTablespace() ); setIndexTablespace( oldInterface.getIndexTablespace() ); setChanged( oldInterface.isChanged() ); }
public void dataNodeToElement( final DataNode rootNode, final RepositoryElementInterface element ) throws KettleException { DatabaseMeta databaseMeta = (DatabaseMeta) element; databaseMeta.setDatabaseType( getString( rootNode, PROP_TYPE ) ); databaseMeta.setAccessType( DatabaseMeta.getAccessType( getString( rootNode, PROP_CONTYPE ) ) ); databaseMeta.setHostname( getString( rootNode, PROP_HOST_NAME ) ); databaseMeta.setDBName( getString( rootNode, PROP_DATABASE_NAME ) ); databaseMeta.setDBPort( getString( rootNode, PROP_PORT ) ); databaseMeta.setUsername( getString( rootNode, PROP_USERNAME ) ); databaseMeta.setPassword( Encr.decryptPasswordOptionallyEncrypted( getString( rootNode, PROP_PASSWORD ) ) ); databaseMeta.setServername( getString( rootNode, PROP_SERVERNAME ) ); databaseMeta.setDataTablespace( getString( rootNode, PROP_DATA_TBS ) ); databaseMeta.setIndexTablespace( getString( rootNode, PROP_INDEX_TBS ) ); // Also, load all the properties we can find... DataNode attrNode = rootNode.getNode( NODE_ATTRIBUTES ); for ( DataProperty property : attrNode.getProperties() ) { String code = property.getName(); String attribute = property.getString(); // We need to unescape the code as it was escaped to handle characters that JCR does not handle String unescapeCode = RepositoryFilenameUtils.unescape( code ); databaseMeta.getAttributes().put( unescapeCode, Const.NVL( attribute, "" ) ); //$NON-NLS-1$ } }
databaseMeta.setDBPort( r.getString( KettleDatabaseRepository.FIELD_DATABASE_PORT, "" ) ); databaseMeta.setUsername( r.getString( KettleDatabaseRepository.FIELD_DATABASE_USERNAME, "" ) ); databaseMeta.setPassword( Encr.decryptPasswordOptionallyEncrypted( r.getString( KettleDatabaseRepository.FIELD_DATABASE_PASSWORD, "" ) ) ); databaseMeta.setServername( r.getString( KettleDatabaseRepository.FIELD_DATABASE_SERVERNAME, "" ) );
setPassword( Encr.decryptPasswordOptionallyEncrypted( XMLHandler.getTagValue( con, "password" ) ) ); setServername( XMLHandler.getTagValue( con, "servername" ) ); setDataTablespace( XMLHandler.getTagValue( con, "data_tablespace" ) );
databaseMeta.setDBName( getChildString( element, MetaStoreConst.DB_ATTR_ID_DATABASE_NAME ) ); databaseMeta.setUsername( getChildString( element, MetaStoreConst.DB_ATTR_ID_USERNAME ) ); databaseMeta.setPassword( metaStore.getTwoWayPasswordEncoder().decode( getChildString( element, MetaStoreConst.DB_ATTR_ID_PASSWORD ) ) ); databaseMeta.setServername( getChildString( element, MetaStoreConst.DB_ATTR_ID_SERVERNAME ) );
public Domain generateDomain( String connectionName, String tableName, String dbType, String query, String datasourceName ) throws Exception { try { DatabaseMeta database = new DatabaseMeta(); database.setDatabaseInterface( new MySQLDatabaseMeta() ); database.setDatabaseType( "mysql" ); database.setUsername( "root" ); database.setPassword( "" ); database.setAccessType( DatabaseMeta.TYPE_ACCESS_NATIVE ); database.setHostname( "localhost" ); database.setDBName( "hibernate" ); database.setDBPort( "3306" ); TableModelerSource source = new TableModelerSource( database, tableName, null ); Domain d = null; try { d = source.generateDomain(); } catch ( ModelerException e ) { e.printStackTrace(); // To change body of catch statement use File | Settings | File Templates. } return d; } catch ( Exception e ) { e.printStackTrace(); } return null; }
public static DatabaseMeta convertToLegacy( String name, SqlDataSource datasource ) { // make sure that the Kettle environment is initialized before DatabaseMeta creation try { KettleEnvironment.init( false ); } catch ( KettleException e ) { logger.error( "Error initializing the Kettle Environment", e ); throw new RuntimeException( "Error initializing the Kettle Environment", e ); } DatabaseMeta databaseMeta = new DatabaseMeta(); databaseMeta.setName( name ); databaseMeta.setHostname( datasource.getHostname() ); if ( datasource.getDialectType() == null ) { // default to mysql if dialect is null databaseMeta.setDatabaseType( "GENERIC" ); //$NON-NLS-1$ } else { databaseMeta.setDatabaseType( datasource.getDialectType() ); } databaseMeta.setAccessType( DatabaseMeta.getAccessType( datasource.getType().toString() ) ); databaseMeta.setDBName( datasource.getDatabaseName() ); databaseMeta.setDBPort( datasource.getPort() ); databaseMeta.setUsername( datasource.getUsername() ); databaseMeta.setPassword( datasource.getPassword() ); databaseMeta.setServername( datasource.getServername() ); // And now load the attributes... for ( String key : datasource.getAttributes().keySet() ) { databaseMeta.getAttributes().put( key, datasource.getAttributes().get( key ) ); } return databaseMeta; }
databaseMeta.setDBPort( cwm.getFirstTaggedValue( catalog, CWM.TAG_DATABASE_PORT ) ); databaseMeta.setUsername( cwm.getFirstTaggedValue( catalog, CWM.TAG_DATABASE_USERNAME ) ); databaseMeta.setPassword( cwm.getFirstTaggedValue( catalog, CWM.TAG_DATABASE_PASSWORD ) ); databaseMeta.setServername( cwm.getFirstTaggedValue( catalog, CWM.TAG_DATABASE_SERVERNAME ) ); databaseMeta.setDataTablespace( cwm.getFirstTaggedValue( catalog, CWM.TAG_DATABASE_DATA_TABLESPACE ) );