private void appendKeyCondition(StatementBuilder buff) { buff.append(" WHERE "); buff.resetCount(); for (String k : key) { buff.appendExceptFirst(" AND "); buff.append(StringUtils.quoteIdentifier(k)).append("=?"); } }
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("=? "); } } }
@Override public String getString() { try { StatementBuilder buff = new StatementBuilder("("); result.beforeFirst(); ResultSetMetaData meta = result.getMetaData(); int columnCount = meta.getColumnCount(); for (int i = 0; result.next(); i++) { if (i > 0) { buff.append(", "); } buff.append('('); buff.resetCount(); for (int j = 0; j < columnCount; j++) { buff.appendExceptFirst(", "); int t = DataType.getValueTypeFromResultSet(meta, j + 1); Value v = DataType.readValue(null, result, j + 1, t); buff.append(v.getString()); } buff.append(')'); } result.beforeFirst(); return buff.append(')').toString(); } catch (SQLException e) { throw DbException.convert(e); } }
private void appendWhere(StatementBuilder buff) { buff.append(" WHERE "); buff.resetCount(); for (IndexColumn c : columns) { buff.appendExceptFirst(" AND "); buff.append(Parser.quoteIdentifier(c.column.getName())).append("=?"); } }
private void appendUpdate(StatementBuilder buff) { buff.append("UPDATE ").append(table.getSQL()).append(" SET "); buff.resetCount(); for (IndexColumn c : columns) { buff.appendExceptFirst(" , "); buff.append(Parser.quoteIdentifier(c.column.getName())).append("=?"); } }
appendColumnList(buff, false); buff.append(")VALUES("); buff.resetCount(); for (int i = 0; i < columnCount; i++) { buff.appendExceptFirst(",");
if (keys != null) { buff.append(" KEY("); buff.resetCount(); for (Column c : keys) { buff.appendExceptFirst(", "); buff.resetCount(); for (Expression e : expr) { buff.appendExceptFirst(", ");
buff.resetCount(); for (IndexColumn r : refColumns) { buff.appendExceptFirst(", "); if (searchIndex != null && check != null) { buff.append(" ("); buff.resetCount(); Column[] cols = searchIndex.getColumns(); int len = Math.min(columns.length, cols.length);
if (keys != null) { buff.append(" KEY("); buff.resetCount(); for (Column c : keys) { buff.appendExceptFirst(", "); buff.resetCount(); for (Expression e : expr) { buff.appendExceptFirst(", ");
buff.resetCount(); for (Column c : keys) { buff.appendExceptFirst(" AND ");
buff.resetCount(); for (Expression e : expr) { buff.appendExceptFirst(", ");
buff.append("\nGROUP BY "); buff.resetCount();
buff.resetCount(); for (IndexColumn c : columns) { buff.appendExceptFirst(" AND "); buff.resetCount(); for (IndexColumn c : columns) { buff.appendExceptFirst(", "); buff.resetCount(); int i = 0; for (IndexColumn c : columns) {
buff.resetCount(); for (Expression e : expr) { buff.appendExceptFirst(", ");
buff.resetCount();
buff.resetCount(); for (int i = 0; i < oldRow.getColumnCount(); i++) { Column col = table.getColumn(i);
buff.resetCount(); for (String parameter : tableEngineParams) { buff.appendExceptFirst(", ");
buff.append(" ORDER BY "); buff.resetCount();
buff.resetCount(); for (GridSqlColumn c : keys) { buff.appendExceptFirst(",\n");
buff.resetCount(); for (IndexColumn r : refCols) { buff.appendExceptFirst(", ");