Examples with ExasolTableColumn org.jkiss.dbeaver.ext.exasol.model.ExasolTableColumn used on opensource projects

Example 21 with ExasolTableColumn

use of org.jkiss.dbeaver.ext.exasol.model.ExasolTableColumn in project dbeaver by dbeaver.

the class ExasolTableIndexCache method fetchObjectRow.

@Override
protected ExasolTableIndexColumn[] fetchObjectRow(JDBCSession session, ExasolTable parent, ExasolTableIndex forObject, JDBCResultSet resultSet) throws SQLException, DBException {
    // ToDo: fix regex
    Matcher m = indexCols.matcher(JDBCUtils.safeGetString(resultSet, "REMARKS"));
    String[] colString;
    ArrayList<ExasolTableIndexColumn> indexCols = new ArrayList<ExasolTableIndexColumn>();
    if (m.find()) {
        colString = m.group(1).split(",");
        for (int i = 0; i < colString.length; i++) {
            ExasolTableColumn tableColumn = colString[i] == null ? null : parent.getAttribute(session.getProgressMonitor(), colString[i]);
            indexCols.add(new ExasolTableIndexColumn(forObject, tableColumn, i + 1));
        }
    }
    ExasolTableIndexColumn[] arrayIndexCols = new ExasolTableIndexColumn[indexCols.size()];
    arrayIndexCols = indexCols.toArray(arrayIndexCols);
    return arrayIndexCols;
}

Example 22 with ExasolTableColumn

use of org.jkiss.dbeaver.ext.exasol.model.ExasolTableColumn in project dbeaver by serge-rider.

the class ExasolTableColumnManager method createDatabaseObject.

// ------
// Create
// ------
@Override
protected ExasolTableColumn createDatabaseObject(DBRProgressMonitor monitor, DBECommandContext context, Object container, Object copyFrom, Map<String, Object> options) {
    ExasolTableColumn column = new ExasolTableColumn((ExasolTableBase) container);
    column.setName(getNewColumnName(monitor, context, (ExasolTableBase) container));
    return column;
}

Example 23 with ExasolTableColumn

use of org.jkiss.dbeaver.ext.exasol.model.ExasolTableColumn in project dbeaver by serge-rider.

the class ExasolTableColumnManager method addObjectRenameActions.

@Override
protected void addObjectRenameActions(DBRProgressMonitor monitor, DBCExecutionContext executionContext, List<DBEPersistAction> actions, ObjectRenameCommand command, Map<String, Object> options) {
    final ExasolTableColumn column = command.getObject();
    actions.add(new SQLDatabasePersistAction("Rename column", "ALTER TABLE " + column.getTable().getFullyQualifiedName(DBPEvaluationContext.DDL) + " RENAME COLUMN " + DBUtils.getQuotedIdentifier(column.getDataSource(), command.getOldName()) + " TO " + DBUtils.getQuotedIdentifier(column.getDataSource(), command.getNewName())));
}

Example 24 with ExasolTableColumn

use of org.jkiss.dbeaver.ext.exasol.model.ExasolTableColumn in project dbeaver by serge-rider.

the class ExasolTableColumnManager method addObjectCreateActions.

@Override
protected void addObjectCreateActions(DBRProgressMonitor monitor, DBCExecutionContext executionContext, List<DBEPersistAction> actions, ObjectCreateCommand command, Map<String, Object> options) {
    final ExasolTableColumn exasolColumn = command.getObject();
    // build nullability string
    String nullability = exasolColumn.isRequired() ? "NOT NULL" : "NULL";
    final String addSQL = DBUtils.getQuotedIdentifier(exasolColumn) + " " + exasolColumn.getFormatType() + " " + (exasolColumn.getDefaultValue() == null ? "" : " DEFAULT " + exasolColumn.getDefaultValue()) + " " + formatIdentiy(exasolColumn.isAutoGenerated(), exasolColumn.getIdentityValue()) + " " + nullability;
    actions.add(new SQLDatabasePersistAction("Add column", "ALTER TABLE " + exasolColumn.getTable().getFullyQualifiedName(DBPEvaluationContext.DDL) + " ADD COLUMN " + addSQL + " "));
    if (exasolColumn.isDistKey())
        try {
            modifyDistKey(monitor, exasolColumn);
        } catch (DBException e) {
            log.error("Failed to generate distribution key", e);
        }
}