private String[] getQuotedSchemaTablenames( String[] tables ) { String[] quoted = new String[ tables.length ]; for ( int i = 0; i < quoted.length; i++ ) { quoted[ i ] = database.getDatabaseMeta().getQuotedSchemaTableCombination( null, tables[ i ] ); } return quoted; }
public boolean checkIndexExists( Database database, String schemaName, String tableName, String[] idx_fields ) throws KettleDatabaseException { String tablename = database.getDatabaseMeta().getQuotedSchemaTableCombination( schemaName, tableName );
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 boolean checkIndexExists( Database database, String schemaName, String tableName, String[] idx_fields ) throws KettleDatabaseException { String tablename = database.getDatabaseMeta().getQuotedSchemaTableCombination( schemaName, tableName );
/** * @param database * The database to set. */ public void setDatabase( Database database ) { connectionDelegate.setDatabase( database ); connectionDelegate.setDatabaseMeta( database.getDatabaseMeta() ); }
/** * Returns max VARCHAR length depending on db interface */ protected int getRepoStringLength() { return database.getDatabaseMeta().getDatabaseInterface().getMaxVARCHARLength() - 1 > 0 ? database.getDatabaseMeta() .getDatabaseInterface().getMaxVARCHARLength() - 1 : KettleDatabaseRepository.REP_ORACLE_STRING_LENGTH; }
public synchronized void unlockRepository() throws KettleException { if ( database.getDatabaseMeta().needsToLockAllTables() ) { database.unlockTables( KettleDatabaseRepository.repositoryTableNames ); } else { database.unlockTables( new String[] { KettleDatabaseRepository.TABLE_R_REPOSITORY_LOG, } ); } }
public synchronized void lockRepository() throws KettleException { if ( database.getDatabaseMeta().needsToLockAllTables() ) { database.lockTables( getQuotedSchemaTablenames( KettleDatabaseRepository.repositoryTableNames ) ); } else { database .lockTables( getQuotedSchemaTablenames( new String[] { KettleDatabaseRepository.TABLE_R_REPOSITORY_LOG, } ) ); } }
public boolean checkIndexExists( Database database, String schemaName, String tableName, String[] idx_fields ) throws KettleDatabaseException { String tablename = database.getDatabaseMeta().getQuotedSchemaTableCombination( schemaName, tableName );
@Test public void testDBNameNOTOverridden_IfDbNameOverrideNull() throws Exception { // Db Name Override is null PGBulkLoaderMeta pgBulkLoaderMock = getPgBulkLoaderMock( null ); Database database = pgBulkLoader.getDatabase( pgBulkLoader, pgBulkLoaderMock ); assertNotNull( database ); // Verify DB name is NOT overridden assertEquals( CONNECTION_DB_NAME, database.getDatabaseMeta().getDatabaseName() ); // Check additionally other connection information assertEquals( CONNECTION_NAME, database.getDatabaseMeta().getName() ); assertEquals( CONNECTION_DB_HOST, database.getDatabaseMeta().getHostname() ); assertEquals( CONNECTION_DB_PORT, database.getDatabaseMeta().getDatabasePortNumberString() ); assertEquals( CONNECTION_DB_USERNAME, database.getDatabaseMeta().getUsername() ); assertEquals( CONNECTION_DB_PASSWORD, database.getDatabaseMeta().getPassword() ); }
@Test public void testDBNameOverridden_IfDbNameOverrideSetUp() throws Exception { // Db Name Override is set up PGBulkLoaderMeta pgBulkLoaderMock = getPgBulkLoaderMock( DB_NAME_OVVERRIDE ); Database database = pgBulkLoader.getDatabase( pgBulkLoader, pgBulkLoaderMock ); assertNotNull( database ); // Verify DB name is overridden assertEquals( DB_NAME_OVVERRIDE, database.getDatabaseMeta().getDatabaseName() ); // Check additionally other connection information assertEquals( CONNECTION_NAME, database.getDatabaseMeta().getName() ); assertEquals( CONNECTION_DB_HOST, database.getDatabaseMeta().getHostname() ); assertEquals( CONNECTION_DB_PORT, database.getDatabaseMeta().getDatabasePortNumberString() ); assertEquals( CONNECTION_DB_USERNAME, database.getDatabaseMeta().getUsername() ); assertEquals( CONNECTION_DB_PASSWORD, database.getDatabaseMeta().getPassword() ); }
@Test public void testDBNameNOTOverridden_IfDbNameOverrideEmpty() throws Exception { // Db Name Override is empty PGBulkLoaderMeta pgBulkLoaderMock = getPgBulkLoaderMock( DB_NAME_EMPTY ); Database database = pgBulkLoader.getDatabase( pgBulkLoader, pgBulkLoaderMock ); assertNotNull( database ); // Verify DB name is NOT overridden assertEquals( CONNECTION_DB_NAME, database.getDatabaseMeta().getDatabaseName() ); // Check additionally other connection information assertEquals( CONNECTION_NAME, database.getDatabaseMeta().getName() ); assertEquals( CONNECTION_DB_HOST, database.getDatabaseMeta().getHostname() ); assertEquals( CONNECTION_DB_PORT, database.getDatabaseMeta().getDatabasePortNumberString() ); assertEquals( CONNECTION_DB_USERNAME, database.getDatabaseMeta().getUsername() ); assertEquals( CONNECTION_DB_PASSWORD, database.getDatabaseMeta().getPassword() ); }
when( db.getDatabaseMeta() ).thenReturn( meta );
if ( !Utils.isEmpty( realSchemaName ) ) { countStatement = selectCount + db.getDatabaseMeta().getQuotedSchemaTableCombination( realSchemaName, realTableName ); } else { countStatement = selectCount + db.getDatabaseMeta().quoteField( realTableName );
public boolean checkIndexExists( Database database, String schemaName, String tableName, String[] idx_fields ) throws KettleDatabaseException { String tablename = database.getDatabaseMeta().getQuotedSchemaTableCombination( schemaName, tableName );
if ( !( db.getDatabaseMeta().getDatabaseInterface() instanceof MSSQLServerDatabaseMeta ) ) { logError( BaseMessages.getString( PKG, "JobMssqlBulkLoad.Error.DbNotMSSQL", connection .getDatabaseName() ) );
countSQLStatement = selectCount + db.getDatabaseMeta().getQuotedSchemaTableCombination( realSchemaname, realTablename ); } else { countSQLStatement = selectCount + db.getDatabaseMeta().quoteField( realTablename );
data.tablename = data.db.getDatabaseMeta().getQuotedSchemaTableCombination( data.schemaname, data.tablename ); } else { data.tablename = data.db.getDatabaseMeta().quoteField( data.tablename ); data.tablename = getInputRowMeta().getString( r, data.indexOfTablename ); if ( !Utils.isEmpty( data.schemaname ) ) { data.tablename = data.db.getDatabaseMeta().getQuotedSchemaTableCombination( data.schemaname, data.tablename ); } else { data.tablename = data.db.getDatabaseMeta().quoteField( data.tablename ); columnname = data.db.getDatabaseMeta().quoteField( columnname );
data.db.getDatabaseMeta().getQuotedSchemaTableCombination( data.realSchemaName, data.realTableName );
schemaTable = data.db.getDatabaseMeta().getQuotedSchemaTableCombination( schemaName, tableName );