/** * Check if an index on certain fields in a table exists. * * @param tableName The table on which the index is checked * @param idx_fields The fields on which the indexe is checked * @return True if the index exists */ public boolean checkIndexExists( String tableName, String[] idx_fields ) throws KettleDatabaseException { return checkIndexExists( null, tableName, idx_fields ); }
&& idx_fields.length > 0 && !db.checkIndexExists( schemaTable, idx_fields ) ) { String indexname = "idx_" + tableName + "_lookup"; cr_index =
if ( idx_fields != null && idx_fields.length > 0 && !db.checkIndexExists( schemaTable, idx_fields ) ) { String indexname = "idx_" + tableName + "_lookup"; cr_index =
&& idx_fields.length > 0 && !db.checkIndexExists( schemaName, tableName, idx_fields ) ) { String indexname = "idx_" + tableName + "_lookup"; cr_index =
if ( !Utils.isEmpty( idx_fields ) && !db.checkIndexExists( schemaTable, idx_fields ) ) { String indexname = "idx_" + tableName + "_lookup"; sql += db.getCreateIndexStatement( schemaTable, indexname, idx_fields, false, false, false, true ); if ( !db.checkIndexExists( schemaTable, idx_fields ) ) { String indexname = "idx_" + tableName + "_tk"; sql += db.getCreateIndexStatement( schemaTable, indexname, idx_fields, true, false, true, true );
if ( !db.checkIndexExists( schemaTable, techKeyArr ) ) { String indexname = "idx_" + tablename + "_pk"; cr_uniq_index = if ( !Utils.isEmpty( idx_fields ) && !db.checkIndexExists( schemaTable, idx_fields ) ) { String indexname = "idx_" + tablename + "_lookup"; cr_index =
&& idx_fields.length > 0 && !db.checkIndexExists( schemaName, tableName, idx_fields ) ) { String indexname = "idx_" + tableName + "_lookup"; cr_index =
KettleDatabaseRepository.FIELD_DATABASE_ATTRIBUTE_ID_DATABASE, KettleDatabaseRepository.FIELD_DATABASE_ATTRIBUTE_CODE, }; if ( !database.checkIndexExists( schemaTable, keyfield ) ) { sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, true, false, false ); statements.add( sql ); KettleDatabaseRepository.FIELD_DIRECTORY_ID_DIRECTORY_PARENT, KettleDatabaseRepository.FIELD_DIRECTORY_DIRECTORY_NAME }; if ( !database.checkIndexExists( schemaTable, keyfield ) ) { sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, true, false, false ); statements.add( sql ); if ( !database.checkIndexExists( schemaTable, keyfield ) ) { sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, true, false, false ); statements.add( sql ); if ( !database.checkIndexExists( schemaTable, keyfield ) ) { sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, true, false, false ); statements.add( sql ); KettleDatabaseRepository.FIELD_STEP_ATTRIBUTE_CODE, KettleDatabaseRepository.FIELD_STEP_ATTRIBUTE_NR, }; if ( !database.checkIndexExists( schemaTable, keyfield ) ) { sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, true, false, false ); statements.add( sql ); indexname = KettleDatabaseRepositoryBase.R_STEP_DATABASE_LU1; keyfield = new String[] { KettleDatabaseRepository.FIELD_STEP_DATABASE_ID_TRANSFORMATION, }; if ( !database.checkIndexExists( schemaTable, keyfield ) ) {