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

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

本文整理了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

/**
 * 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 );
}

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

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

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

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

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

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

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

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 );

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

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 =

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

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

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

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 ) ) {

相关文章

微信公众号

最新文章

更多