net.sf.jsqlparser.statement.create.index.CreateIndex Java Examples

The following examples show how to use net.sf.jsqlparser.statement.create.index.CreateIndex. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example #1

Source File: DDLSQLPlanner.java From herddb with Apache License 2.0

6 votes

private ExecutionPlan plan(
        String defaultTableSpace, net.sf.jsqlparser.statement.Statement stmt,
        boolean scan, boolean returnValues, int maxRows
) {
    ExecutionPlan result;
    if (stmt instanceof CreateTable) {
        result = ExecutionPlan.simple(buildCreateTableStatement(defaultTableSpace, (CreateTable) stmt));
    } else if (stmt instanceof CreateIndex) {
        result = ExecutionPlan.simple(buildCreateIndexStatement(defaultTableSpace, (CreateIndex) stmt));
    } else if (stmt instanceof Execute) {
        result = ExecutionPlan.simple(buildExecuteStatement(defaultTableSpace, (Execute) stmt));
    } else if (stmt instanceof Alter) {
        result = ExecutionPlan.simple(buildAlterStatement(defaultTableSpace, (Alter) stmt));
    } else if (stmt instanceof Drop) {
        result = ExecutionPlan.simple(buildDropStatement(defaultTableSpace, (Drop) stmt));
    } else if (stmt instanceof Truncate) {
        result = ExecutionPlan.simple(buildTruncateStatement(defaultTableSpace, (Truncate) stmt));
    } else {
        return null;
    }
    return result;
}

Example #2

Source File: DDLSQLPlanner.java From herddb with Apache License 2.0

5 votes

private Statement buildCreateIndexStatement(String defaultTableSpace, CreateIndex s) throws StatementExecutionException {
    try {
        String tableSpace = s.getTable().getSchemaName();
        if (tableSpace == null) {
            tableSpace = defaultTableSpace;
        }
        String tableName = s.getTable().getName().toLowerCase();

        String indexName = s.getIndex().getName().toLowerCase();
        String indexType = convertIndexType(s.getIndex().getType());

        herddb.model.Index.Builder builder = herddb.model.Index
                .builder()
                .name(indexName)
                .uuid(UUID.randomUUID().toString())
                .type(indexType)
                .table(tableName)
                .tablespace(tableSpace);

        AbstractTableManager tableDefinition = manager.getTableSpaceManager(tableSpace).getTableManager(tableName);
        if (tableDefinition == null) {
            throw new TableDoesNotExistException("no such table " + tableName + " in tablespace " + tableSpace);
        }
        for (String columnName : s.getIndex().getColumnsNames()) {
            columnName = columnName.toLowerCase();
            Column column = tableDefinition.getTable().getColumn(columnName);
            if (column == null) {
                throw new StatementExecutionException(
                        "no such column " + columnName + " on table " + tableName + " in tablespace " + tableSpace);
            }
            builder.column(column.name, column.type);
        }

        CreateIndexStatement statement = new CreateIndexStatement(builder.build());
        return statement;
    } catch (IllegalArgumentException err) {
        throw new StatementExecutionException("bad index definition: " + err.getMessage(), err);
    }
}

Example #3

Source File: AllColumnRefsFinder.java From jobson with Apache License 2.0

4 votes

public void visit(CreateIndex createIndex) {
    throw new UnsupportedSQLFeatureException("Feature CreateIndex not supported");
}

Example #4

Source File: TablesNamesFinder.java From evosql with Apache License 2.0

4 votes

@Override
public void visit(CreateIndex createIndex) {
    throw new UnsupportedOperationException(NOT_SUPPORTED_YET);
}

Example #5

Source File: TableRenameVisitor.java From compass with Apache License 2.0

4 votes

@Override
public void visit(CreateIndex createIndex) 
{
    throw new UnsupportedOperationException("Not supported yet."); 
}

Example #6

Source File: SqlElementVisitor.java From foxtrot with Apache License 2.0

4 votes

@Override
public void visit(CreateIndex createIndex) {
    //supported construct
}

Example #7

Source File: TableVisitor.java From DDF with Apache License 2.0

2 votes

@Override
public void visit(CreateIndex createIndex) throws Exception {

}