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 static SqlDataSource convertFromLegacy( DatabaseMeta database ) { SqlDataSource dataSource = new SqlDataSource(); dataSource.setDialectType( database.getDatabaseTypeDesc() ); dataSource.setDatabaseName( database.environmentSubstitute( database.getDatabaseName() ) ); dataSource.setHostname( database.environmentSubstitute( database.getHostname() ) ); dataSource.setPort( database.environmentSubstitute( database.getDatabasePortNumberString() ) ); dataSource.setUsername( database.environmentSubstitute( database.getUsername() ) ); dataSource.setPassword( database.environmentSubstitute( database.getPassword() ) ); dataSource.setServername( database.environmentSubstitute( database.getServername() ) ); if ( database.getAccessType() == DatabaseMeta.TYPE_ACCESS_JNDI ) { dataSource.setType( DataSourceType.values()[database.getAccessType()] ); } else if ( database.getAccessType() == DatabaseMeta.TYPE_ACCESS_NATIVE ) { dataSource.setType( DataSourceType.NATIVE ); } // And now load the attributes... if ( database.getAttributes() != null ) { for ( Object key : database.getAttributes().keySet() ) { dataSource.getAttributes().put( (String) key, database.environmentSubstitute( (String) database.getAttributes().get( key ) ) ); } } return dataSource; }
model.setId( modelID ); model.setName( new LocalizedString( locale.getCode(), modelName ) ); SqlDataSource dataSource = new SqlDataSource(); dataSource.getAttributes().put( "QUOTE_ALL_FIELDS", "Y" ); //$NON-NLS-1$ //$NON-NLS-2$ dataSource.setType( DataSourceType.JNDI ); if ( dbType != null ) { dataSource.setDialectType( dbType ); dataSource.setDatabaseName( connectionName ); model.setDatasource( dataSource );
if ( sqlModel.getDatasource().getType() == DataSourceType.JNDI ) { database = new DatabaseMeta( ( (SqlPhysicalModel) physicalModel ).getDatasource().getDatabaseName(), "MYSQL", //$NON-NLS-1$ "JNDI", "", "", "", "", "" ); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$ //$NON-NLS-5$ //$NON-NLS-6$ database.getDatabaseInterface().setDatabaseName( ( (SqlPhysicalModel) physicalModel ).getDatasource().getDatabaseName() );
public BusinessData loadBusinessData( String domainId, String modelId ) throws DatasourceServiceException { Domain domain = getMetadataDomainRepository().getDomain( domainId ); List<List<String>> data = null; if ( domain.getPhysicalModels().get( 0 ) instanceof InlineEtlPhysicalModel ) { InlineEtlPhysicalModel model = (InlineEtlPhysicalModel) domain.getPhysicalModels().get( 0 ); data = DatasourceInMemoryServiceHelper.getCsvDataSample( model.getFileLocation(), model.getHeaderPresent(), model .getDelimiter(), model.getEnclosure(), 5 ); } else { SqlPhysicalModel model = (SqlPhysicalModel) domain.getPhysicalModels().get( 0 ); String query = model.getPhysicalTables().get( 0 ).getTargetTable(); SerializedResultSet resultSet = DatasourceInMemoryServiceHelper .getSerializeableResultSet( model.getDatasource().getDatabaseName(), query, 5, null ); data = resultSet.getData(); } return new BusinessData( domain, data ); }
public BusinessData loadBusinessData( String domainId, String modelId ) throws DatasourceServiceException { Domain domain = getMetadataDomainRepository().getDomain( domainId ); List<List<String>> data = null; if ( domain.getPhysicalModels().get( 0 ) instanceof InlineEtlPhysicalModel ) { InlineEtlPhysicalModel model = (InlineEtlPhysicalModel) domain.getPhysicalModels().get( 0 ); String relativePath = PentahoSystem.getSystemSetting( "file-upload-defaults/relative-path", String.valueOf( CsvTransformGenerator.DEFAULT_RELATIVE_UPLOAD_FILE_PATH ) ); //$NON-NLS-1$ String csvFileLoc = PentahoSystem.getApplicationContext().getSolutionPath( relativePath ); data = DatasourceServiceHelper.getCsvDataSample( csvFileLoc + model.getFileLocation(), model.getHeaderPresent(), model.getDelimiter(), model.getEnclosure(), 5 ); } else { SqlPhysicalModel model = (SqlPhysicalModel) domain.getPhysicalModels().get( 0 ); String query = model.getPhysicalTables().get( 0 ).getTargetTable(); SerializedResultSet resultSet = DatasourceServiceHelper.getSerializeableResultSet( model.getDatasource().getDatabaseName(), query, 5, PentahoSessionHolder.getSession() ); data = resultSet.getData(); } return new BusinessData( domain, data ); }
SqlDataSource sqlDataSource = new SqlDataSource(); sqlPhysicalModel.setDatasource( sqlDataSource ); .setType( DataSourceType.values()[DatabaseMeta.getAccessType( database_access_type )] ); //$NON-NLS-1$ sqlDataSource.setDatabaseName( kvp.get( "DATABASE_DATABASE" ) ); //$NON-NLS-1$ sqlDataSource.setHostname( kvp.get( "DATABASE_SERVER" ) ); //$NON-NLS-1$ sqlDataSource.setPort( kvp.get( "DATABASE_PORT" ) ); //$NON-NLS-1$ sqlDataSource.setUsername( kvp.get( "DATABASE_USERNAME" ) ); //$NON-NLS-1$ sqlDataSource.setPassword( kvp.get( "DATABASE_PASSWORD" ) ); //$NON-NLS-1$ sqlDataSource.setDialectType( kvp.get( "DATABASE_TYPE" ) ); //$NON-NLS-1$ sqlDataSource.setServername( kvp.get( "DATABASE_SERVER_INSTANCE" ) ); //$NON-NLS-1$ String attribute = kvp.get( tag ); sqlDataSource.getAttributes().put( key, attribute );
"DATABASE_TYPE", datasource.getDialectType(), idGen.getNextId() ) ); //$NON-NLS-1$ modelElement.appendChild( createTaggedValue( doc, "DATABASE_ACCESS", datasource.getType().toString(), idGen.getNextId() ) ); //$NON-NLS-1$ modelElement.appendChild( createTaggedValue( doc, "DATABASE_DATABASE", datasource.getDatabaseName(), idGen.getNextId() ) ); //$NON-NLS-1$ modelElement.appendChild( createTaggedValue( doc, "DATABASE_SERVER", datasource.getHostname(), idGen.getNextId() ) ); //$NON-NLS-1$ modelElement.appendChild( createTaggedValue( doc, "DATABASE_PORT", datasource.getPort(), idGen.getNextId() ) ); //$NON-NLS-1$ modelElement.appendChild( createTaggedValue( doc, "DATABASE_USERNAME", datasource.getUsername(), idGen.getNextId() ) ); //$NON-NLS-1$ modelElement.appendChild( createTaggedValue( doc, "DATABASE_PASSWORD", datasource.getPassword(), idGen.getNextId() ) ); //$NON-NLS-1$ if ( !StringUtils.isEmpty( datasource.getServername() ) ) { modelElement.appendChild( createTaggedValue( doc, "DATABASE_SERVER_INSTANCE", datasource.getServername(), idGen.getNextId() ) ); //$NON-NLS-1$ for ( String attribute : datasource.getAttributes().keySet() ) { modelElement.appendChild( createTaggedValue( doc, CWM.TAG_DATABASE_ATTRIBUTE_PREFIX + attribute, datasource .getAttributes().get( attribute ), idGen.getNextId() ) );