private void buildUpdateSQL() { if (updateAction == ConstraintActionType.RESTRICT) { return; } StatementBuilder buff = new StatementBuilder(); appendUpdate(buff); appendWhere(buff); updateSQL = buff.toString(); }
private static String getMethodSignature(Method m) { StatementBuilder buff = new StatementBuilder(m.getName()); buff.append('('); for (Class<?> p : m.getParameterTypes()) { // do not use a space here, because spaces are removed // in CreateFunctionAlias.setJavaClassMethod() buff.appendExceptFirst(","); if (p.isArray()) { buff.append(p.getComponentType().getName()).append("[]"); } else { buff.append(p.getName()); } } return buff.append(')').toString(); }
private DbException getSyntaxError() { if (expectedList == null || expectedList.isEmpty()) { return DbException.getSyntaxError(sqlCommand, parseIndex); } StatementBuilder buff = new StatementBuilder(); for (String e : expectedList) { buff.appendExceptFirst(", "); buff.append(e); } return DbException.getSyntaxError(sqlCommand, parseIndex, buff.toString()); }
@Override public String toString() { StatementBuilder buff = new StatementBuilder("{"); for (int i = 0; i < size; i++) { buff.appendExceptFirst(", "); buff.append(data[i]); } return buff.append('}').toString(); }
/** * 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(); }
/** * Get the SQL snippet of the value list. * * @param values the value list * @return the SQL snippet */ protected static String getSQL(Value[] values) { StatementBuilder buff = new StatementBuilder(); for (Value v : values) { buff.appendExceptFirst(", "); if (v != null) { buff.append(v.getSQL()); } } return buff.toString(); }
/** * Get the SQL snippet of the expression list. * * @param list the expression list * @return the SQL snippet */ protected static String getSQL(Expression[] list) { StatementBuilder buff = new StatementBuilder(); for (Expression e : list) { buff.appendExceptFirst(", "); if (e != null) { buff.append(e.getSQL()); } } return buff.toString(); }
@Override public String getTraceSQL() { StatementBuilder buff = new StatementBuilder("("); for (Value v : values) { buff.appendExceptFirst(", "); buff.append(v == null ? "null" : v.getTraceSQL()); } return buff.append(')').toString(); }
@Override public String getString() { StatementBuilder buff = new StatementBuilder("("); for (Value v : values) { buff.appendExceptFirst(", "); buff.append(v.getString()); } return buff.append(')').toString(); }
@Override public String getSQL() { StatementBuilder buff = new StatementBuilder("("); for (Value v : values) { buff.appendExceptFirst(", "); buff.append(v.getSQL()); } if (values.length == 1) { buff.append(','); } return buff.append(')').toString(); }
@Override public String getSQL() { StatementBuilder buff = new StatementBuilder("("); for (Expression e: list) { buff.appendExceptFirst(", "); buff.append(e.getSQL()); } if (list.length == 1) { buff.append(','); } return buff.append(')').toString(); }
private void buildDeleteSQL() { if (deleteAction == ConstraintActionType.RESTRICT) { return; } StatementBuilder buff = new StatementBuilder(); if (deleteAction == ConstraintActionType.CASCADE) { buff.append("DELETE FROM ").append(table.getSQL()); } else { appendUpdate(buff); } appendWhere(buff); deleteSQL = buff.toString(); }
@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(); }
@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(); }
private String getKey(Object[] row) throws SQLException { StatementBuilder buff = new StatementBuilder(); for (int columnIndex : index.keys) { buff.appendExceptFirst(" AND "); buff.append(StringUtils.quoteIdentifier(index.columns[columnIndex])); Object o = row[columnIndex]; if (o == null) { buff.append(" IS NULL"); } else { buff.append('=').append(quoteSQL(o, columnTypes[columnIndex])); } } return buff.toString(); }
@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(); }
@Override public String toString() { StatementBuilder buff = new StatementBuilder("( /* key:"); buff.append(getKey()); if (version != 0) { buff.append(" v:").append(version); } buff.append(" */ "); for (Value v : data) { buff.appendExceptFirst(", "); buff.append(v == null ? "null" : v.getTraceSQL()); } return buff.append(')').toString(); }
@Override public String getSQL() { StatementBuilder buff = new StatementBuilder(); buff.append(Parser.quoteIdentifier(userAggregate.getName())).append('('); for (Expression e : args) { buff.appendExceptFirst(", "); buff.append(e.getSQL()); } buff.append(')'); if (filterCondition != null) { buff.append(" FILTER (WHERE ").append(filterCondition.getSQL()).append(')'); } return buff.toString(); }
/** {@inheritDoc} */ @Override public String getSQL() { StatementBuilder buff = new StatementBuilder(); buff.append(leftTable().getSQL()); buff.append(leftOuter ? " \n LEFT OUTER JOIN " : " \n INNER JOIN "); buff.append(rightTable().getSQL()); buff.append(" \n ON ").append(StringUtils.unEnclose(on().getSQL())); return buff.toString(); } }
/** {@inheritDoc} */ @Override public String getSQL() { StatementBuilder buff = new StatementBuilder(explain() ? "EXPLAIN " : ""); buff.append("DELETE") .append("\nFROM ") .append(from.getSQL()); if (where != null) buff.append("\nWHERE ").append(StringUtils.unEnclose(where.getSQL())); if (limit != null) buff.append("\nLIMIT (").append(StringUtils.unEnclose(limit.getSQL())).append(')'); return buff.toString(); } }