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

Example 1 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, GenericTable 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 2 with DBSIndexType

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

the class EditIndexPage method createContentsBeforeColumns.

@Override
protected void createContentsBeforeColumns(Composite panel) {
    UIUtils.createControlLabel(panel, EditorsMessages.dialog_struct_edit_index_label_type);
    final Combo typeCombo = new Combo(panel, SWT.DROP_DOWN | SWT.READ_ONLY);
    typeCombo.setLayoutData(new GridData(GridData.FILL_HORIZONTAL));
    for (DBSIndexType indexType : indexTypes) {
        typeCombo.add(indexType.getName());
        if (selectedIndexType == null) {
            selectedIndexType = indexType;
        }
    }
    typeCombo.select(0);
    typeCombo.setEnabled(indexTypes.size() > 1);
    typeCombo.addSelectionListener(new SelectionAdapter() {

        @Override
        public void widgetSelected(SelectionEvent e) {
            selectedIndexType = indexTypes.get(typeCombo.getSelectionIndex());
        }
    });
    if (supportUniqueIndexes) {
        final Button uniqueButton = UIUtils.createLabelCheckbox(panel, "Unique", false);
        uniqueButton.addSelectionListener(new SelectionAdapter() {

            @Override
            public void widgetSelected(SelectionEvent e) {
                unique = uniqueButton.getSelection();
            }
        });
    }
}

Example 3 with DBSIndexType

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

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

Example 4 with DBSIndexType

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

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 5 with DBSIndexType

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

the class IndexCache method fetchObject.

@Nullable
@Override
protected GenericTableIndex fetchObject(JDBCSession session, GenericStructContainer owner, GenericTable 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;
        // indexType = DBSIndexType.STATISTIC; 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);
}