Examples with Command org.h2.command.Command used on opensource projects

Example 11 with Command

use of org.h2.command.Command in project h2database by h2database.

the class Parser method parseSetBinaryCollation.

private Set parseSetBinaryCollation() {
    Set command = new Set(session, SetTypes.BINARY_COLLATION);
    String name = readAliasIdentifier();
    command.setString(name);
    if (equalsToken(name, CompareMode.UNSIGNED) || equalsToken(name, CompareMode.SIGNED)) {
        return command;
    }
    throw DbException.getInvalidValueException("BINARY_COLLATION", name);
}

Example 12 with Command

use of org.h2.command.Command in project h2database by h2database.

the class Parser method parseCreateAggregate.

private CreateAggregate parseCreateAggregate(boolean force) {
    boolean ifNotExists = readIfNotExists();
    CreateAggregate command = new CreateAggregate(session);
    command.setForce(force);
    String name = readIdentifierWithSchema();
    if (isKeyword(name) || Function.getFunction(database, name) != null || getAggregateType(name) != null) {
        throw DbException.get(ErrorCode.FUNCTION_ALIAS_ALREADY_EXISTS_1, name);
    }
    command.setName(name);
    command.setSchema(getSchema());
    command.setIfNotExists(ifNotExists);
    read("FOR");
    command.setJavaClassMethod(readUniqueIdentifier());
    return command;
}

Example 13 with Command

use of org.h2.command.Command in project h2database by h2database.

the class Parser method parseCreateFunctionAlias.

private CreateFunctionAlias parseCreateFunctionAlias(boolean force) {
    boolean ifNotExists = readIfNotExists();
    String aliasName = readIdentifierWithSchema();
    final boolean newAliasSameNameAsBuiltin = Function.getFunction(database, aliasName) != null;
    if (database.isAllowBuiltinAliasOverride() && newAliasSameNameAsBuiltin) {
    // fine
    } else if (isKeyword(aliasName) || newAliasSameNameAsBuiltin || getAggregateType(aliasName) != null) {
        throw DbException.get(ErrorCode.FUNCTION_ALIAS_ALREADY_EXISTS_1, aliasName);
    }
    CreateFunctionAlias command = new CreateFunctionAlias(session, getSchema());
    command.setForce(force);
    command.setAliasName(aliasName);
    command.setIfNotExists(ifNotExists);
    command.setDeterministic(readIf("DETERMINISTIC"));
    command.setBufferResultSetToLocalTemp(!readIf("NOBUFFER"));
    if (readIf("AS")) {
        command.setSource(readString());
    } else {
        read("FOR");
        command.setJavaClassMethod(readUniqueIdentifier());
    }
    return command;
}

Example 14 with Command

use of org.h2.command.Command in project h2database by h2database.

the class Parser method parseAlterSequence.

private AlterSequence parseAlterSequence() {
    boolean ifExists = readIfExists(false);
    String sequenceName = readIdentifierWithSchema();
    AlterSequence command = new AlterSequence(session, getSchema());
    command.setSequenceName(sequenceName);
    command.setIfExists(ifExists);
    while (true) {
        if (readIf("RESTART")) {
            read("WITH");
            command.setStartWith(readExpression());
        } else if (readIf("INCREMENT")) {
            read("BY");
            command.setIncrement(readExpression());
        } else if (readIf("MINVALUE")) {
            command.setMinValue(readExpression());
        } else if (readIf("NOMINVALUE")) {
            command.setMinValue(null);
        } else if (readIf("MAXVALUE")) {
            command.setMaxValue(readExpression());
        } else if (readIf("NOMAXVALUE")) {
            command.setMaxValue(null);
        } else if (readIf("CYCLE")) {
            command.setCycle(true);
        } else if (readIf("NOCYCLE")) {
            command.setCycle(false);
        } else if (readIf("NO")) {
            if (readIf("MINVALUE")) {
                command.setMinValue(null);
            } else if (readIf("MAXVALUE")) {
                command.setMaxValue(null);
            } else if (readIf("CYCLE")) {
                command.setCycle(false);
            } else if (readIf("CACHE")) {
                command.setCacheSize(ValueExpression.get(ValueLong.get(1)));
            } else {
                break;
            }
        } else if (readIf("CACHE")) {
            command.setCacheSize(readExpression());
        } else if (readIf("NOCACHE")) {
            command.setCacheSize(ValueExpression.get(ValueLong.get(1)));
        } else {
            break;
        }
    }
    return command;
}

Example 15 with Command

use of org.h2.command.Command in project h2database by h2database.

the class Parser method parseMerge.

private Prepared parseMerge() {
    Merge command = new Merge(session);
    currentPrepared = command;
    int start = lastParseIndex;
    read("INTO");
    List<String> excludeIdentifiers = Arrays.asList("USING", "KEY", "VALUES");
    TableFilter targetTableFilter = readSimpleTableFilter(0, excludeIdentifiers);
    command.setTargetTableFilter(targetTableFilter);
    Table table = command.getTargetTable();
    if (readIf("USING")) {
        return parseMergeUsing(command, start);
    }
    if (readIf("(")) {
        if (isSelect()) {
            command.setQuery(parseSelect());
            read(")");
            return command;
        }
        Column[] columns = parseColumnList(table);
        command.setColumns(columns);
    }
    if (readIf("KEY")) {
        read("(");
        Column[] keys = parseColumnList(table);
        command.setKeys(keys);
    }
    if (readIf("VALUES")) {
        do {
            ArrayList<Expression> values = New.arrayList();
            read("(");
            if (!readIf(")")) {
                do {
                    if (readIf("DEFAULT")) {
                        values.add(null);
                    } else {
                        values.add(readExpression());
                    }
                } while (readIfMore(false));
            }
            command.addRow(values.toArray(new Expression[0]));
        } while (readIf(","));
    } else {
        command.setQuery(parseSelect());
    }
    return command;
}