本文整理了Java中org.pentaho.di.core.database.Database.checkIndexExists()
方法的一些代码示例,展示了Database.checkIndexExists()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Database.checkIndexExists()
方法的具体详情如下:
包路径:org.pentaho.di.core.database.Database
类名称: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 ) ) {
内容来源于网络,如有侵权,请联系作者删除!