private DbException getSyntaxError() { if (expectedList == null || expectedList.size() == 0) { 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 SQL snippet of the expression list. * * @param list the expression list * @return the SQL snippet */ public 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(); }
/** * Get the SQL snippet of the value list. * * @param values the value list * @return the SQL snippet */ public 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(); }
@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 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(); }
/** * Convert a string array to the Java source code that represents this * array. Null will be converted to 'null'. * * @param array the string array * @return the Java source code (including new String[]{}) */ public static String quoteJavaStringArray(String[] array) { if (array == null) { return "null"; } StatementBuilder buff = new StatementBuilder("new String[]{"); for (String a : array) { buff.appendExceptFirst(", "); buff.append(quoteJavaString(a)); } 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(); }
@Override public String getPreparedSQL(Session session, List<Value> parameters) { StatementBuilder buff = new StatementBuilder("("); for (Expression e : list) { buff.appendExceptFirst(", "); buff.append(e.getPreparedSQL(session, parameters)); } if (list.length == 1) { buff.append(','); } return buff.append(')').toString(); }
@Override public String getPreparedSQL(Session session, List<Value> parameters) { StatementBuilder buff = new StatementBuilder("("); buff.append(left.getPreparedSQL(session, parameters)).append(" IN("); for (Expression e : valueList) { buff.appendExceptFirst(", "); buff.append(e.getPreparedSQL(session, parameters)); } return buff.append("))").toString(); } }
@Override public SQLTranslated translate(Column[] searchColumns, TableFilter filter, GroupObjectNode node) { ObjectNode[] items = node.getItems(); List<Value> params = New.arrayList(10 * items.length); StatementBuilder sql = new StatementBuilder(100 * items.length); for (ObjectNode objectNode : items) { SQLTranslated translated = translate(searchColumns, filter, objectNode); sql.appendExceptFirst(" UNION ALL "); sql.append(StringUtils.enclose(translated.sql)); params.addAll(translated.params); } return SQLTranslated.build().sql(sql.toString()).sqlParams(params); }
@Override public SQLTranslated translate(Select select, GroupObjectNode node, Map<ObjectNode, Map<TableFilter, ObjectNode>> consistencyTableNodes,Expression[] selectCols, Integer limit, Integer offset) { ObjectNode[] items = node.getItems(); List<Value> params = New.arrayList(10 * items.length); StatementBuilder sql = new StatementBuilder(100 * items.length); for (ObjectNode objectNode : items) { SQLTranslated translated = translate(select, objectNode, consistencyTableNodes,selectCols, limit, offset); sql.appendExceptFirst(" UNION ALL "); sql.append(StringUtils.enclose(translated.sql)); params.addAll(translated.params); } return SQLTranslated.build().sql(sql.toString()).sqlParams(params); }
@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 getPreparedSQL(Session session, List<Value> parameters) { StatementBuilder buff = new StatementBuilder("("); buff.append(left.getPreparedSQL(session, parameters)).append(" IN("); for (Expression e : valueList) { buff.appendExceptFirst(", "); buff.append(e.getPreparedSQL(session, parameters)); } 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(); }
public String explain() { StatementBuilder buff = new StatementBuilder(); buff.append("execute on ").append(shardName); buff.append(": ").append(sql); if (params != null && params.size() > 0) { buff.append(" params: {"); int i = 1; for (Value v : params) { buff.appendExceptFirst(", "); buff.append(i++).append(": ").append(v.getSQL()); } buff.append('}'); } 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(); }
/** * @see http://dev.mysql.com/doc/refman/5.7/en/drop-index.html */ @Override public SQLTranslated translate(DropIndex prepared, ObjectNode indexNode, ObjectNode tableNode) { String forIndex = indexNode.getCompositeObjectName(); String forTable = tableNode.getCompositeObjectName(); StatementBuilder sql = new StatementBuilder(); sql.append("DROP INDEX "); sql.append(identifier(forIndex)); sql.append(" ON ").append(identifier(forTable)); return SQLTranslated.build().sql(sql.toString()); } /**