Examples with StatementBuilder org.h2.util.StatementBuilder used on opensource projects

Example 11 with StatementBuilder

use of org.h2.util.StatementBuilder in project h2database by h2database.

the class TableFunction method getSQL.

@Override
public String getSQL() {
    StatementBuilder buff = new StatementBuilder(getName());
    buff.append('(');
    int i = 0;
    for (Expression e : args) {
        buff.appendExceptFirst(", ");
        buff.append(columnList[i++].getCreateSQL()).append('=').append(e.getSQL());
    }
    return buff.append(')').toString();
}

Example 12 with StatementBuilder

use of org.h2.util.StatementBuilder in project h2database by h2database.

the class ConditionIn method getSQL.

@Override
public String getSQL() {
    StatementBuilder buff = new StatementBuilder("(");
    buff.append(left.getSQL()).append(" IN(");
    for (Expression e : valueList) {
        buff.appendExceptFirst(", ");
        buff.append(e.getSQL());
    }
    return buff.append("))").toString();
}

Example 13 with StatementBuilder

use of org.h2.util.StatementBuilder in project h2database by h2database.

the class BaseIndex method getColumnListSQL.

/**
 * Get the list of columns as a string.
 *
 * @return the list of columns
 */
private String getColumnListSQL() {
    StatementBuilder buff = new StatementBuilder();
    for (IndexColumn c : indexColumns) {
        buff.appendExceptFirst(", ");
        buff.append(c.getSQL());
    }
    return buff.toString();
}

Example 14 with StatementBuilder

use of org.h2.util.StatementBuilder in project h2database by h2database.

the class IndexCondition method getSQL.

/**
 * Get the SQL snippet of this comparison.
 *
 * @return the SQL snippet
 */
public String getSQL() {
    if (compareType == Comparison.FALSE) {
        return "FALSE";
    }
    StatementBuilder buff = new StatementBuilder();
    buff.append(column.getSQL());
    switch(compareType) {
        case Comparison.EQUAL:
            buff.append(" = ");
            break;
        case Comparison.EQUAL_NULL_SAFE:
            buff.append(" IS ");
            break;
        case Comparison.BIGGER_EQUAL:
            buff.append(" >= ");
            break;
        case Comparison.BIGGER:
            buff.append(" > ");
            break;
        case Comparison.SMALLER_EQUAL:
            buff.append(" <= ");
            break;
        case Comparison.SMALLER:
            buff.append(" < ");
            break;
        case Comparison.IN_LIST:
            buff.append(" IN(");
            for (Expression e : expressionList) {
                buff.appendExceptFirst(", ");
                buff.append(e.getSQL());
            }
            buff.append(')');
            break;
        case Comparison.IN_QUERY:
            buff.append(" IN(");
            buff.append(expressionQuery.getPlanSQL());
            buff.append(')');
            break;
        case Comparison.SPATIAL_INTERSECTS:
            buff.append(" && ");
            break;
        default:
            DbException.throwInternalError("type=" + compareType);
    }
    if (expression != null) {
        buff.append(expression.getSQL());
    }
    return buff.toString();
}

Example 15 with StatementBuilder

use of org.h2.util.StatementBuilder in project h2database by h2database.

the class Aggregate method getSQLArrayAggregate.

private String getSQLArrayAggregate() {
    StatementBuilder buff = new StatementBuilder("ARRAY_AGG(");
    if (distinct) {
        buff.append("DISTINCT ");
    }
    buff.append(on.getSQL());
    if (orderByList != null) {
        buff.append(" ORDER BY ");
        for (SelectOrderBy o : orderByList) {
            buff.appendExceptFirst(", ");
            buff.append(o.expression.getSQL());
            if (o.descending) {
                buff.append(" DESC");
            }
        }
    }
    buff.append(')');
    if (filterCondition != null) {
        buff.append(" FILTER (WHERE ").append(filterCondition.getSQL()).append(')');
    }
    return buff.toString();
}