Examples with GenericTableIndexColumn org.jkiss.dbeaver.ext.generic.model.GenericTableIndexColumn used on opensource projects

Example 1 with GenericTableIndexColumn

use of org.jkiss.dbeaver.ext.generic.model.GenericTableIndexColumn 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 2 with GenericTableIndexColumn

use of org.jkiss.dbeaver.ext.generic.model.GenericTableIndexColumn 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 3 with GenericTableIndexColumn

use of org.jkiss.dbeaver.ext.generic.model.GenericTableIndexColumn in project dbeaver by serge-rider.

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 4 with GenericTableIndexColumn

use of org.jkiss.dbeaver.ext.generic.model.GenericTableIndexColumn in project dbeaver by serge-rider.

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