private void buildUpdateSQL() { if (updateAction == RESTRICT) { return; } StatementBuilder buff = new StatementBuilder(); appendUpdate(buff); appendWhere(buff); updateSQL = buff.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()); }
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(); }
@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(); }
@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(); }
private void buildDeleteSQL() { if (deleteAction == RESTRICT) { return; } StatementBuilder buff = new StatementBuilder(); if (deleteAction == CASCADE) { buff.append("DELETE FROM ").append(table.getSQL()); } else { appendUpdate(buff); } appendWhere(buff); deleteSQL = buff.toString(); }
@Override public String getCreateSQL() { if (system) { return null; } StatementBuilder sql = new StatementBuilder(); sql.append("CREATE SCHEMA IF NOT EXISTS ").append(getSQL()).append(" AUTHORIZATION ").append(owner.getSQL()); return sql.toString(); }
private void rewriteSql() { StatementBuilder sql = new StatementBuilder("ALTER DATABASE "); sql.append(db.getShortName()); sql.append(" RUN MODE ").append(runMode.toString()); if (replicationProperties != null && !replicationProperties.isEmpty()) { sql.append(" WITH REPLICATION STRATEGY"); Database.appendMap(sql, replicationProperties); } sql.append(" PARAMETERS"); Database.appendMap(sql, db.getParameters()); this.sql = sql.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(); }
@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 long getRowCount(ServerSession session) { StatementBuilder sql = new StatementBuilder("select count(*) from "); sql.append(getName()); if (session == null) session = getDatabase().getSystemSession(); PreparedStatement prepared = session.prepareStatement(sql.toString(), true); prepared.setLocal(false); Result result = prepared.query(0); return result.getRowCount(); }
@Override public void rename(String newName) { StatementBuilder sql = new StatementBuilder("alter table "); sql.append(getName()).append(" rename to").append(newName); PreparedStatement prepared = getDatabase().getSystemSession().prepareStatement(sql.toString(), true); prepared.setLocal(true); prepared.update(); }
@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(); }