public String getCreateIndexStatement( String tablename, String indexname, String[] idx_fields, boolean tk, boolean unique, boolean bitmap, boolean semi_colon ) { return getCreateIndexStatement( null, tablename, indexname, idx_fields, tk, unique, bitmap, semi_colon ); }
when( repository.getDatabaseMeta() ).thenReturn( meta ); when( db.getCreateIndexStatement( anyString(), anyString(), any( String[].class ), anyBoolean(), anyBoolean(), anyBoolean(), anyBoolean() ) ).thenAnswer( lan );
if ( !index.isEmpty() ) { String createIndex = db.getCreateIndexStatement( schemaTable, "IDX_" + tableName + "_" + ( i + 1 ), index .getFieldNames(), false, false, false, true ); if ( !Utils.isEmpty( createIndex ) ) {
if ( !index.isEmpty() ) { String createIndex = db.getCreateIndexStatement( schemaTable, "IDX_" + tableName + "_" + ( i + 1 ), index .getFieldNames(), false, false, false, true ); if ( !Utils.isEmpty( createIndex ) ) {
String indexname = "idx_" + tableName + "_lookup"; cr_index = db.getCreateIndexStatement( schemaTable, indexname, idx_fields, false, false, false, true );
String indexname = "idx_" + tableName + "_lookup"; cr_index = db.getCreateIndexStatement( schemaName, tableName, indexname, idx_fields, false, false, false, true );
String indexname = "idx_" + tableName + "_lookup"; cr_index = db.getCreateIndexStatement( schemaTable, indexname, idx_fields, false, false, false, true );
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 );
String indexname = "idx_" + tablename + "_pk"; cr_uniq_index = db.getCreateIndexStatement( schemaTable, indexname, techKeyArr, true, true, false, true ); cr_uniq_index += Const.CR; String indexname = "idx_" + tablename + "_lookup"; cr_index = db.getCreateIndexStatement( schemaTable, indexname, idx_fields, false, false, false, true ); cr_index += Const.CR;
String indexname = "idx_" + tableName + "_lookup"; cr_index = db.getCreateIndexStatement( schemaTable, indexname, idx_fields, false, false, false, true );
KettleDatabaseRepository.FIELD_DATABASE_ATTRIBUTE_CODE, }; if ( !database.checkIndexExists( schemaTable, keyfield ) ) { sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, true, false, false ); statements.add( sql ); if ( !dryrun ) { KettleDatabaseRepository.FIELD_DIRECTORY_DIRECTORY_NAME }; if ( !database.checkIndexExists( schemaTable, keyfield ) ) { sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, true, false, false ); statements.add( sql ); if ( !dryrun ) { sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, true, false, false ); statements.add( sql ); if ( !dryrun ) { sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, true, false, false ); statements.add( sql ); if ( !dryrun ) { KettleDatabaseRepository.FIELD_STEP_ATTRIBUTE_NR, }; if ( !database.checkIndexExists( schemaTable, keyfield ) ) { sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, true, false, false ); statements.add( sql ); if ( !dryrun ) { keyfield = new String[] { KettleDatabaseRepository.FIELD_STEP_DATABASE_ID_TRANSFORMATION, }; if ( !database.checkIndexExists( schemaTable, keyfield ) ) { sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, false, false, false );
String indexSql = db.getCreateIndexStatement( tableName, columnName + "_idx", //$NON-NLS-1$ new String[] { columnName }, false, false, false, true ); commands.add( indexSql );