org.pentaho.di.core.database.Database.checkIndexExists()方法的使用及代码示例

x33g5p2x  于2022-01-18 转载在 其他  
字(3.8k)|赞(0)|评价(0)|浏览(148)

本文整理了Java中org.pentaho.di.core.database.Database.checkIndexExists()方法的一些代码示例,展示了Database.checkIndexExists()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Database.checkIndexExists()方法的具体详情如下:
包路径:org.pentaho.di.core.database.Database
类名称:Database
方法名:checkIndexExists

Database.checkIndexExists介绍

[英]Check if an index on certain fields in a table exists.
[中]检查表中某些字段上是否存在索引。

代码示例

代码示例来源:origin: pentaho/pentaho-kettle

  1. /**
  2. * Check if an index on certain fields in a table exists.
  3. *
  4. * @param tableName The table on which the index is checked
  5. * @param idx_fields The fields on which the indexe is checked
  6. * @return True if the index exists
  7. */
  8. public boolean checkIndexExists( String tableName, String[] idx_fields ) throws KettleDatabaseException {
  9. return checkIndexExists( null, tableName, idx_fields );
  10. }

代码示例来源:origin: pentaho/pentaho-kettle

  1. && idx_fields.length > 0 && !db.checkIndexExists( schemaTable, idx_fields ) ) {
  2. String indexname = "idx_" + tableName + "_lookup";
  3. cr_index =

代码示例来源:origin: pentaho/pentaho-kettle

  1. if ( idx_fields != null && idx_fields.length > 0 && !db.checkIndexExists( schemaTable, idx_fields ) ) {
  2. String indexname = "idx_" + tableName + "_lookup";
  3. cr_index =

代码示例来源:origin: pentaho/pentaho-kettle

  1. && idx_fields.length > 0 && !db.checkIndexExists( schemaName, tableName, idx_fields ) ) {
  2. String indexname = "idx_" + tableName + "_lookup";
  3. cr_index =

代码示例来源:origin: pentaho/pentaho-kettle

  1. if ( !Utils.isEmpty( idx_fields ) && !db.checkIndexExists( schemaTable, idx_fields ) ) {
  2. String indexname = "idx_" + tableName + "_lookup";
  3. sql += db.getCreateIndexStatement( schemaTable, indexname, idx_fields, false, false, false, true );
  4. if ( !db.checkIndexExists( schemaTable, idx_fields ) ) {
  5. String indexname = "idx_" + tableName + "_tk";
  6. sql += db.getCreateIndexStatement( schemaTable, indexname, idx_fields, true, false, true, true );

代码示例来源:origin: pentaho/pentaho-kettle

  1. if ( !db.checkIndexExists( schemaTable, techKeyArr ) ) {
  2. String indexname = "idx_" + tablename + "_pk";
  3. cr_uniq_index =
  4. if ( !Utils.isEmpty( idx_fields ) && !db.checkIndexExists( schemaTable, idx_fields ) ) {
  5. String indexname = "idx_" + tablename + "_lookup";
  6. cr_index =

代码示例来源:origin: pentaho/pentaho-kettle

  1. && idx_fields.length > 0 && !db.checkIndexExists( schemaName, tableName, idx_fields ) ) {
  2. String indexname = "idx_" + tableName + "_lookup";
  3. cr_index =

代码示例来源:origin: pentaho/pentaho-kettle

  1. KettleDatabaseRepository.FIELD_DATABASE_ATTRIBUTE_ID_DATABASE,
  2. KettleDatabaseRepository.FIELD_DATABASE_ATTRIBUTE_CODE, };
  3. if ( !database.checkIndexExists( schemaTable, keyfield ) ) {
  4. sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, true, false, false );
  5. statements.add( sql );
  6. KettleDatabaseRepository.FIELD_DIRECTORY_ID_DIRECTORY_PARENT,
  7. KettleDatabaseRepository.FIELD_DIRECTORY_DIRECTORY_NAME };
  8. if ( !database.checkIndexExists( schemaTable, keyfield ) ) {
  9. sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, true, false, false );
  10. statements.add( sql );
  11. if ( !database.checkIndexExists( schemaTable, keyfield ) ) {
  12. sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, true, false, false );
  13. statements.add( sql );
  14. if ( !database.checkIndexExists( schemaTable, keyfield ) ) {
  15. sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, true, false, false );
  16. statements.add( sql );
  17. KettleDatabaseRepository.FIELD_STEP_ATTRIBUTE_CODE,
  18. KettleDatabaseRepository.FIELD_STEP_ATTRIBUTE_NR, };
  19. if ( !database.checkIndexExists( schemaTable, keyfield ) ) {
  20. sql = database.getCreateIndexStatement( schemaTable, indexname, keyfield, false, true, false, false );
  21. statements.add( sql );
  22. indexname = KettleDatabaseRepositoryBase.R_STEP_DATABASE_LU1;
  23. keyfield = new String[] { KettleDatabaseRepository.FIELD_STEP_DATABASE_ID_TRANSFORMATION, };
  24. if ( !database.checkIndexExists( schemaTable, keyfield ) ) {

相关文章