Examples with DBSIndexType org.jkiss.dbeaver.model.struct.rdb.DBSIndexType used on opensource projects

Example 6 with DBSIndexType

use of org.jkiss.dbeaver.model.struct.rdb.DBSIndexType in project dbeaver by dbeaver.

the class HiveIndexManager method addObjectCreateActions.

@Override
protected void addObjectCreateActions(DBRProgressMonitor monitor, DBCExecutionContext executionContext, List<DBEPersistAction> actions, ObjectCreateCommand command, Map<String, Object> options) {
    HiveIndex tableIndex = (HiveIndex) command.getObject();
    DBSIndexType indexType = tableIndex.getIndexType();
    String indexName = tableIndex.getName();
    String tableName = tableIndex.getTable().getName();
    String hiveIndexType;
    List<GenericTableIndexColumn> indexColumns = tableIndex.getAttributeReferences(monitor);
    if (indexType.getId().equals("COMPACT")) {
        hiveIndexType = "\'COMPACT\'";
    } else {
        hiveIndexType = "\'BITMAP\'";
    }
    StringBuilder ddl = new StringBuilder();
    ddl.append("CREATE INDEX ").append(indexName).append(" ON TABLE ").append(tableName).append(" (");
    if (indexColumns != null) {
        for (int i = 0; i < indexColumns.size(); i++) {
            if (i == 0) {
                ddl.append(DBUtils.getQuotedIdentifier(indexColumns.get(i)));
            } else {
                ddl.append(", ").append(DBUtils.getQuotedIdentifier(indexColumns.get(i)));
            }
        }
    }
    ddl.append(") AS ").append(hiveIndexType).append(" WITH DEFERRED REBUILD");
    actions.add(new SQLDatabasePersistAction("Create table index", ddl.toString()));
    actions.add(new SQLDatabasePersistAction("ALTER INDEX " + indexName + " ON " + tableName + " REBUILD"));
}

Example 7 with DBSIndexType

use of org.jkiss.dbeaver.model.struct.rdb.DBSIndexType in project dbeaver by dbeaver.

the class IndexCache method fetchObject.

@Nullable
@Override
protected GenericTableIndex fetchObject(JDBCSession session, GenericStructContainer owner, GenericTableBase parent, String indexName, JDBCResultSet dbResult) throws SQLException, DBException {
    boolean isNonUnique = GenericUtils.safeGetBoolean(indexObject, dbResult, JDBCConstants.NON_UNIQUE);
    String indexQualifier = GenericUtils.safeGetStringTrimmed(indexObject, dbResult, JDBCConstants.INDEX_QUALIFIER);
    long cardinality = GenericUtils.safeGetLong(indexObject, dbResult, JDBCConstants.INDEX_CARDINALITY);
    int indexTypeNum = GenericUtils.safeGetInt(indexObject, dbResult, JDBCConstants.TYPE);
    DBSIndexType indexType;
    switch(indexTypeNum) {
        case DatabaseMetaData.tableIndexStatistic:
            // Table index statistic. Not a real index.
            log.debug("Skip statistics index '" + indexName + "' in '" + DBUtils.getObjectFullName(parent, DBPEvaluationContext.DDL) + "'");
            return null;
        // break;
        case DatabaseMetaData.tableIndexClustered:
            indexType = DBSIndexType.CLUSTERED;
            break;
        case DatabaseMetaData.tableIndexHashed:
            indexType = DBSIndexType.HASHED;
            break;
        case DatabaseMetaData.tableIndexOther:
            indexType = DBSIndexType.OTHER;
            break;
        default:
            indexType = DBSIndexType.UNKNOWN;
            break;
    }
    if (CommonUtils.isEmpty(indexName)) {
        // [JDBC] Some drivers return empty index names
        indexName = parent.getName().toUpperCase(Locale.ENGLISH) + "_INDEX";
    }
    return owner.getDataSource().getMetaModel().createIndexImpl(parent, isNonUnique, indexQualifier, cardinality, indexName, indexType, true);
}

Example 8 with DBSIndexType

use of org.jkiss.dbeaver.model.struct.rdb.DBSIndexType in project dbeaver by dbeaver.

the class SQLServerIndexManager method addObjectCreateActions.

@Override
protected void addObjectCreateActions(DBRProgressMonitor monitor, DBCExecutionContext executionContext, List<DBEPersistAction> actions, ObjectCreateCommand command, Map<String, Object> options) {
    SQLServerTableIndex index = command.getObject();
    SQLServerTableBase indexTable = index.getTable();
    if (indexTable instanceof SQLServerTableType) {
        return;
    }
    if (index.isPersisted()) {
        try {
            String indexDDL = index.getObjectDefinitionText(monitor, DBPScriptObject.EMPTY_OPTIONS);
            if (!CommonUtils.isEmpty(indexDDL)) {
                actions.add(new SQLDatabasePersistAction(ModelMessages.model_jdbc_create_new_index, indexDDL));
                return;
            }
        } catch (DBException e) {
            log.warn("Can't extract index DDL", e);
        }
    }
    DBSIndexType indexType = index.getIndexType();
    String sqlServerIndexType = null;
    if (indexType == DBSIndexType.CLUSTERED) {
        sqlServerIndexType = "CLUSTERED";
    } else if (indexType == SQLServerConstants.INDEX_TYPE_NON_CLUSTERED) {
        sqlServerIndexType = "NONCLUSTERED";
    }
    StringBuilder ddl = new StringBuilder();
    ddl.append("CREATE ");
    if (index.isUnique()) {
        ddl.append("UNIQUE ");
    }
    if (sqlServerIndexType != null) {
        ddl.append(sqlServerIndexType).append(" ");
    }
    ddl.append("INDEX ").append(index.getName()).append(" ON ").append(indexTable.getFullyQualifiedName(DBPEvaluationContext.DDL)).append(" (");
    List<SQLServerTableIndexColumn> indexColumns = index.getAttributeReferences(monitor);
    if (indexColumns != null) {
        for (int i = 0; i < indexColumns.size(); i++) {
            if (i == 0) {
                ddl.append(DBUtils.getQuotedIdentifier(indexColumns.get(i)));
            } else {
                ddl.append(", ").append(DBUtils.getQuotedIdentifier(indexColumns.get(i)));
            }
        }
    } else {
        super.addObjectCreateActions(monitor, executionContext, actions, command, options);
        return;
    }
    ddl.append(")");
    actions.add(new SQLDatabasePersistAction("Create new SQL Server index", ddl.toString()));
}

Example 9 with DBSIndexType

use of org.jkiss.dbeaver.model.struct.rdb.DBSIndexType in project dbeaver by dbeaver.

the class GenericTableIndexConfigurator method configureObject.

@Override
public GenericTableIndex configureObject(DBRProgressMonitor monitor, Object table, GenericTableIndex index) {
    GenericTableBase tableBase = (GenericTableBase) table;
    boolean supportUniqueIndexes = tableBase.supportUniqueIndexes();
    Collection<DBSIndexType> tableIndexTypes = tableBase.getTableIndexTypes();
    return new UITask<GenericTableIndex>() {

        @Override
        protected GenericTableIndex runTask() {
            EditIndexPage editPage = new EditIndexPage("Create index", index, tableIndexTypes, supportUniqueIndexes);
            if (!editPage.edit()) {
                return null;
            }
            index.setIndexType(editPage.getIndexType());
            StringBuilder idxName = new StringBuilder(64);
            idxName.append(CommonUtils.escapeIdentifier(index.getTable().getName()));
            int colIndex = 1;
            for (DBSEntityAttribute tableColumn : editPage.getSelectedAttributes()) {
                if (colIndex == 1) {
                    idxName.append("_").append(CommonUtils.escapeIdentifier(tableColumn.getName()));
                }
                index.addColumn(new GenericTableIndexColumn(index, (GenericTableColumn) tableColumn, colIndex++, !Boolean.TRUE.equals(editPage.getAttributeProperty(tableColumn, EditIndexPage.PROP_DESC))));
            }
            idxName.append("_IDX");
            index.setName(DBObjectNameCaseTransformer.transformObjectName(index, idxName.toString()));
            index.setUnique(editPage.isUnique());
            return index;
        }
    }.execute();
}

Example 10 with DBSIndexType

use of org.jkiss.dbeaver.model.struct.rdb.DBSIndexType in project dbeaver by dbeaver.

the class ExasolIndexConfigurator method configureObject.

@Override
public ExasolTableIndex configureObject(DBRProgressMonitor monitor, Object container, ExasolTableIndex index) {
    return UITask.run(() -> {
        EditIndexPage editPage = new EditIndexPage("create index", index, Arrays.asList(new DBSIndexType("LOCAL", "LOCAL"), new DBSIndexType("GLOBAL", "GLOBAL")), false);
        if (!editPage.edit()) {
            return null;
        }
        index.setIndexType(editPage.getIndexType());
        int colIndex = 1;
        for (DBSEntityAttribute tableColumn : editPage.getSelectedAttributes()) {
            index.addColumn(new ExasolTableIndexColumn(index, (ExasolTableColumn) tableColumn, colIndex++));
        }
        index.setName(index.getIndexType().getName() + " INDEX " + index.getSimpleColumnString());
        return index;
    });
}