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(); }
public static void appendMap(StatementBuilder sql, Map<String, String> map) { sql.resetCount(); sql.append("("); for (Entry<String, String> e : map.entrySet()) { if (e.getValue() == null) continue; sql.appendExceptFirst(","); sql.append(e.getKey()).append('=').append("'").append(e.getValue()).append("'"); } sql.append(')'); }
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()); }
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 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 getString() { StatementBuilder buff = new StatementBuilder("("); for (Value v : values) { buff.appendExceptFirst(", "); buff.append(v.getString()); } return buff.append(')').toString(); }
@Override public String getTraceSQL() { StatementBuilder buff = new StatementBuilder("("); for (Value v : values) { buff.appendExceptFirst(", "); buff.append(v.getTraceSQL()); } return buff.append(')').toString(); }
private void appendColumnList(StatementBuilder buff, boolean set) { buff.resetCount(); for (int i = 0; i < columnCount; i++) { buff.appendExceptFirst(","); String col = result.getColumnName(i); buff.append(StringUtils.quoteIdentifier(col)); if (set) { buff.append("=? "); } } }
private void appendKeyCondition(StatementBuilder buff) { buff.append(" WHERE "); buff.resetCount(); for (String k : key) { buff.appendExceptFirst(" AND "); buff.append(StringUtils.quoteIdentifier(k)).append("=?"); } }
@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(boolean isDistributed) { StatementBuilder buff = new StatementBuilder("("); for (Expression e : list) { buff.appendExceptFirst(", "); buff.append(e.getSQL(isDistributed)); } if (list.length == 1) { buff.append(','); } return buff.append(')').toString(); }
private void appendWhere(StatementBuilder buff) { buff.append(" WHERE "); buff.resetCount(); for (IndexColumn c : columns) { buff.appendExceptFirst(" AND "); buff.append(database.quoteIdentifier(c.column.getName())).append("=?"); } }
@Override public String toString() { StatementBuilder buff = new StatementBuilder("( /* key:"); buff.append(getKey()); if (version != 0) { buff.append(" v:" + version); } buff.append(" */ "); for (Value v : data) { buff.appendExceptFirst(", "); buff.append(v == null ? "null" : v.getTraceSQL()); } return buff.append(')').toString(); }
@Override public String getSQL(boolean isDistributed) { StatementBuilder buff = new StatementBuilder("("); buff.append(left.getSQL(isDistributed)).append(" IN("); for (Expression e : valueList) { buff.appendExceptFirst(", "); buff.append(e.getSQL(isDistributed)); } return buff.append("))").toString(); }
@Override public String getSQL(boolean isDistributed) { 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 void appendUpdate(StatementBuilder buff) { buff.append("UPDATE ").append(table.getSQL()).append(" SET "); buff.resetCount(); for (IndexColumn c : columns) { buff.appendExceptFirst(" , "); buff.append(database.quoteIdentifier(c.column.getName())).append("=?"); } }
@Override public String getSQL(boolean isDistributed) { StatementBuilder buff = new StatementBuilder(); buff.append(Parser.quoteIdentifier(userAggregate.getName())).append('('); for (Expression e : args) { buff.appendExceptFirst(", "); buff.append(e.getSQL(isDistributed)); } return buff.append(')').toString(); }
@Override public String getSQL(boolean isDistributed) { 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(isDistributed)); } return buff.append(')').toString(); }
@Override public String getSQL(boolean isDistributed) { StatementBuilder buff = new StatementBuilder(); // TODO always append the schema once FUNCTIONS_IN_SCHEMA is enabled if (functionAlias.getDatabase().getSettings().functionsInSchema || !functionAlias.getSchema().getName().equals(Constants.SCHEMA_MAIN)) { buff.append(Parser.quoteIdentifier(functionAlias.getSchema().getName())).append('.'); } buff.append(Parser.quoteIdentifier(functionAlias.getName())).append('('); for (Expression e : args) { buff.appendExceptFirst(", "); buff.append(e.getSQL(isDistributed)); } return buff.append(')').toString(); }