/** * Gets the database names. * * @return the database names */ public String[] getDatabaseNames() { String[] names = new String[databases.size()]; for ( int i = 0; i < names.length; i++ ) { names[i] = databases.get( i ).getName(); } return names; }
public static String createEntryKey( String connectionGroup, String partitionID, Database database ) { StringBuilder key = new StringBuilder( connectionGroup ); key.append( ':' ).append( database.getDatabaseMeta().getName() ); if ( !Utils.isEmpty( partitionID ) ) { key.append( ':' ).append( partitionID ); } return key.toString(); }
public String getXML() { StringBuilder xml = new StringBuilder( 200 ); xml.append( " " ).append( XMLHandler.openTag( XML_TAG ) ).append( Const.CR ); xml.append( " " ).append( XMLHandler.addTagValue( "connection", db == null ? "" : db.getName() ) ); xml.append( " " ).append( XMLHandler.addTagValue( "table", tablename ) ); xml.append( " " ).append( XMLHandler.addTagValue( "field", fieldname ) ); xml.append( " " ).append( XMLHandler.closeTag( XML_TAG ) ).append( Const.CR ); return xml.toString(); }
public final String getXML() { StringBuffer retval = new StringBuffer(); retval.append( " " ).append( XMLHandler.addTagValue( "connection", this.databaseMeta == null ? "" : this.databaseMeta.getName() ) ); retval.append( " " ).append( XMLHandler.addTagValue( "modelName", this.modelName ) ); retval.append( " " ).append( XMLHandler.addTagValue( "readBatchSize", this.commitBatchSize ) ); retval.append( " " ).append( XMLHandler.addTagValue( "idFieldName", this.idFieldName ) ); return retval.toString(); }
public String getXML() { StringBuilder retval = new StringBuilder(); retval.append( " " + XMLHandler.addTagValue( "connection", database == null ? "" : database.getName() ) ); retval.append( " " + XMLHandler.addTagValue( "tablenamefield", tablenamefield ) ); retval.append( " " + XMLHandler.addTagValue( "resultfieldname", resultfieldname ) ); retval.append( " " + XMLHandler.addTagValue( "schemaname", schemaname ) ); return retval.toString(); }
public String getXML() { StringBuilder retval = new StringBuilder(); retval.append( " " + XMLHandler.addTagValue( "connection", databaseMeta == null ? "" : databaseMeta.getName() ) ); retval.append( " " + XMLHandler.addTagValue( "sql", sql ) ); retval.append( " " + XMLHandler.addTagValue( "catalog", catalog ) ); retval.append( " " + XMLHandler.addTagValue( "role", role ) ); retval.append( " " + XMLHandler.addTagValue( "variables_active", variableReplacementActive ) ); return retval.toString(); }
@Override public String getConnectionTestReport( DatabaseMeta databaseMeta ) { try { OpenERPHelper helper = new OpenERPHelper( databaseMeta ); helper.StartSession(); return "Successfully connected to [" + databaseMeta.environmentSubstitute( databaseMeta.getName() ) + "]"; } catch ( NumberFormatException e ) { return "Invalid port number: " + e.getMessage(); } catch ( Exception e ) { return "Connection failed: " + e.getMessage(); } }
@SuppressWarnings( { "rawtypes", "unchecked" } ) public void addDatabases( XulMenuList wConnection, Class<? extends DatabaseInterface> databaseType ) { List<String> databases = new ArrayList<String>(); for ( int i = 0; i < transMeta.nrDatabases(); i++ ) { DatabaseMeta ci = transMeta.getDatabase( i ); if ( databaseType == null || ci.getDatabaseInterface().getClass().equals( databaseType ) ) { databases.add( ci.getName() ); } } wConnection.setElements( databases ); }
public String getXML() { StringBuilder retval = new StringBuilder(); retval .append( " " + XMLHandler.addTagValue( "connection", databaseMeta == null ? "" : databaseMeta.getName() ) ); retval.append( " " + XMLHandler.addTagValue( "rowlimit", rowLimit ) ); retval.append( " " + XMLHandler.addTagValue( "sql", sql ) ); retval.append( " " + XMLHandler.addTagValue( "outer_join", outerJoin ) ); retval.append( " " + XMLHandler.addTagValue( "replace_vars", replacevars ) ); retval.append( " " + XMLHandler.addTagValue( "sql_fieldname", sqlfieldname ) ); retval.append( " " + XMLHandler.addTagValue( "query_only_on_change", queryonlyonchange ) ); return retval.toString(); }
public String getXML() { StringBuffer retval = new StringBuffer(); retval.append( super.getXML() ); retval.append( " " ).append( XMLHandler.addTagValue( "connection", getDatabaseMeta() == null ? "" : getDatabaseMeta().getName() ) ); retval.append( " " ).append( XMLHandler.addTagValue( "cubeName", getCubeName() ) ); return retval.toString(); }
public DatabaseMeta searchDatabase( String name ) { for ( int i = 0; i < nrDatabases(); i++ ) { if ( getDatabase( i ).getName().equalsIgnoreCase( name ) ) { return getDatabase( i ); } } return null; }
@Override public void widgetSelected( SelectionEvent e ) { DatabaseMeta databaseMeta = new DatabaseMeta(); String connectionName = showDbDialogUnlessCancelledOrValid( databaseMeta, null ); if ( connectionName != null ) { jobMeta.addDatabase( databaseMeta ); reinitConnectionDropDown( wConnection, databaseMeta.getName() ); } } }
public void addDatabases() { connections = new String[jobMeta.nrDatabases()]; for ( int i = 0; i < jobMeta.nrDatabases(); i++ ) { DatabaseMeta ci = jobMeta.getDatabase( i ); connections[i] = ci.getName(); } }
@SuppressWarnings( "unchecked" ) public String getDatabases() { JSONArray list = new JSONArray(); for ( int i = 0; i < repositoriesMeta.nrDatabases(); i++ ) { JSONObject databaseJSON = new JSONObject(); databaseJSON.put( "name", repositoriesMeta.getDatabase( i ).getName() ); list.add( databaseJSON ); } return list.toString(); }
public void widgetSelected( SelectionEvent e ) { CreateDatabaseWizard cdw = new CreateDatabaseWizard(); DatabaseMeta newDBInfo = cdw.createAndRunDatabaseWizard( shell, props, transMeta.getDatabases() ); if ( newDBInfo != null ) { transMeta.addDatabase( newDBInfo ); reinitConnectionDropDown( wConnection, newDBInfo.getName() ); } } } );
private void fillConnections() { wConnection.removeAll(); // Fill in the available connections... for ( int i = 0; i < repositories.nrDatabases(); i++ ) { wConnection.add( repositories.getDatabase( i ).getName() ); } }
public static void showDatabaseExistsDialog( Shell parent, DatabaseMeta databaseMeta ) { String title = BaseMessages.getString( PKG, "DatabaseDialog.DatabaseNameExists.Title" ); String message = BaseMessages.getString( PKG, "DatabaseDialog.DatabaseNameExists", databaseMeta.getName() ); String okButton = BaseMessages.getString( PKG, "System.Button.OK" ); MessageDialog dialog = new MessageDialog( parent, title, null, message, MessageDialog.ERROR, new String[] { okButton }, 0 ); dialog.open(); }
public static SAPConnectionParams getFromDatabaseMeta( DatabaseMeta sapConnection ) { String name = sapConnection.getName(); String host = sapConnection.environmentSubstitute( sapConnection.getHostname() ); String sysnr = sapConnection.environmentSubstitute( sapConnection.getAttributes().getProperty( "SAPSystemNumber" ) ); String client = sapConnection.environmentSubstitute( sapConnection.getAttributes().getProperty( "SAPClient" ) ); String user = sapConnection.environmentSubstitute( sapConnection.getUsername() ); String password = sapConnection.environmentSubstitute( sapConnection.getPassword() ); String lang = ""; return new SAPConnectionParams( name, host, sysnr, client, user, password, lang ); } }
public void widgetSelected( SelectionEvent e ) { DatabaseMeta databaseMeta = new DatabaseMeta(); databaseMeta.shareVariablesWith( transMeta ); getDatabaseDialog().setDatabaseMeta( databaseMeta ); if ( getDatabaseDialog().open() != null ) { transMeta.addDatabase( getDatabaseDialog().getDatabaseMeta() ); wLogconnection.add( getDatabaseDialog().getDatabaseMeta().getName() ); wLogconnection.select( wLogconnection.getItemCount() - 1 ); } } } );