public DatabaseMeta getDatabaseInfo() { databaseMeta.setHostname( wHostname.getText() ); databaseMeta.setDBPort( wPort.getText() ); databaseMeta.setDBName( wDBName.getText() ); return databaseMeta; }
public DatabaseMeta getDatabaseInfo() { if ( wHostname.getText() != null && wHostname.getText().length() > 0 ) { info.setHostname( wHostname.getText() ); } if ( wSAPLanguage.getText() != null && wSAPLanguage.getText().length() > 0 ) { info.getAttributes().put( SAPR3DatabaseMeta.ATTRIBUTE_SAP_LANGUAGE, wSAPLanguage.getText() ); } if ( wSAPSystemNumber.getText() != null && wSAPSystemNumber.getText().length() > 0 ) { info.getAttributes().put( SAPR3DatabaseMeta.ATTRIBUTE_SAP_SYSTEM_NUMBER, wSAPSystemNumber.getText() ); } if ( wSAPClient.getText() != null && wSAPClient.getText().length() > 0 ) { info.getAttributes().put( SAPR3DatabaseMeta.ATTRIBUTE_SAP_CLIENT, wSAPClient.getText() ); } return info; }
@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 ); }
@Test public void testDatabaseNotOverridden() throws Exception { final String name = "db meta"; DatabaseMeta dbMetaShared = new DatabaseMeta(); dbMetaShared.setName( name ); dbMetaShared.setHostname( "host" ); DatabaseMeta dbMetaStore = new DatabaseMeta(); dbMetaStore.setName( name ); dbMetaStore.setHostname( "anotherhost" ); IMetaStore mstore = new MemoryMetaStore(); DatabaseMetaStoreUtil.createDatabaseElement( mstore, dbMetaStore ); TransMeta trans = new TransMeta(); trans.addOrReplaceDatabase( dbMetaShared ); trans.setMetaStore( mstore ); trans.importFromMetaStore(); DatabaseMeta dbMeta = trans.findDatabase( name ); assertEquals( dbMetaShared.getHostname(), dbMeta.getHostname() ); }
private void getConnectionSpecificInfo( DatabaseMeta meta ) { meta.setHostname( hostNameBox.getValue() );
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.setAccessType( DatabaseMeta.getAccessType( getDatabaseConTypeCode( id_database_contype ) ) ); databaseMeta.setHostname( r.getString( KettleDatabaseRepository.FIELD_DATABASE_HOST_NAME, "" ) ); databaseMeta.setDBName( r.getString( KettleDatabaseRepository.FIELD_DATABASE_DATABASE_NAME, "" ) ); databaseMeta.setDBPort( r.getString( KettleDatabaseRepository.FIELD_DATABASE_PORT, "" ) );
setHostname( XMLHandler.getTagValue( con, "server" ) ); String acc = XMLHandler.getTagValue( con, "access" ); setAccessType( getAccessType( acc ) );
databaseMeta.setHostname( getChildString( element, MetaStoreConst.DB_ATTR_ID_HOSTNAME ) ); databaseMeta.setDBPort( getChildString( element, MetaStoreConst.DB_ATTR_ID_PORT ) ); databaseMeta.setDBName( getChildString( element, MetaStoreConst.DB_ATTR_ID_DATABASE_NAME ) );
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; }
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; }
databaseMeta.setHostname( cwm.getFirstTaggedValue( catalog, CWM.TAG_DATABASE_SERVER ) ); databaseMeta.setDatabaseType( cwm.getFirstTaggedValue( catalog, CWM.TAG_DATABASE_TYPE ) ); databaseMeta.setAccessType( DatabaseMeta