@Override public String getSQL() { return StringUtils.quoteStringSQL(value); }
@Override public String getSQL() { return "CAST(" + StringUtils.quoteStringSQL(value) + " AS VARCHAR_IGNORECASE)"; }
@Override public String getCreateSQL() { StringBuilder buff = new StringBuilder("COMMENT ON "); buff.append(getTypeName(objectType)).append(' ').append(objectName).append(" IS "); if (commentText == null) { buff.append("NULL"); } else { buff.append(StringUtils.quoteStringSQL(commentText)); } return buff.toString(); }
@Override public String getSQL() { return StringUtils.quoteStringSQL(getString()); }
@Override public String getCreateSQL() { StringBuilder buff = new StringBuilder("CREATE FORCE ALIAS "); buff.append(getSQL()); if (deterministic) { buff.append(" DETERMINISTIC"); } if (!bufferResultSetToLocalTemp) { buff.append(" NOBUFFER"); } if (source != null) { buff.append(" AS ").append(StringUtils.quoteStringSQL(source)); } else { buff.append(" FOR ").append(database.quoteIdentifier(className + "." + methodName)); } return buff.toString(); }
@Override public String getCreateSQL() { StringBuilder buff = new StringBuilder("ALTER TABLE "); buff.append(table.getSQL()).append(" ADD CONSTRAINT "); if (table.isHidden()) { buff.append("IF NOT EXISTS "); } buff.append(getSQL()); if (comment != null) { buff.append(" COMMENT ").append(StringUtils.quoteStringSQL(comment)); } buff.append(" CHECK").append(StringUtils.enclose(expr.getSQL())).append(" NOCHECK"); return buff.toString(); }
/** * Convert a string to a SQL literal. Null is converted to NULL. The text is * enclosed in single quotes. If there are any special characters, the method * STRINGDECODE is used. * * @param s the text to convert. * @return the SQL literal */ public static String quoteStringSQL(String s) { if (s == null) { return "NULL"; } int length = s.length(); StringBuilder buff = new StringBuilder(length + 2); buff.append('\''); for (int i = 0; i < length; i++) { char c = s.charAt(i); if (c == '\'') { buff.append(c); } else if (c < ' ' || c > 127) { // need to start from the beginning because maybe there was a \ // that was not quoted return "STRINGDECODE(" + quoteStringSQL(javaEncode(s)) + ")"; } buff.append(c); } buff.append('\''); return buff.toString(); }
@Override public String getCreateSQL() { StringBuilder buff = new StringBuilder("CREATE "); buff.append(indexType.getSQL()); buff.append(' '); if (table.isHidden()) { buff.append("IF NOT EXISTS "); } buff.append(getSQL()); buff.append(" ON ").append(table.getSQL()); if (comment != null) { buff.append(" COMMENT ").append(StringUtils.quoteStringSQL(comment)); } buff.append('(').append(getColumnListSQL()).append(')'); return buff.toString(); }
/** * Get the CREATE SQL statement for this object. * * @param password true if the password (actually the salt and hash) should * be returned * @return the SQL statement */ public String getCreateSQL(boolean password) { StringBuilder buff = new StringBuilder("CREATE USER IF NOT EXISTS "); buff.append(getSQL()); if (comment != null) { buff.append(" COMMENT ").append(StringUtils.quoteStringSQL(comment)); } if (password) { buff.append(" SALT '").append(StringUtils.convertBytesToHex(salt)).append("' HASH '") .append(StringUtils.convertBytesToHex(passwordHash)).append('\''); } else { buff.append(" PASSWORD ''"); } if (admin) { buff.append(" ADMIN"); } return buff.toString(); }
@Override public String getCreateSQL() { StringBuilder buff = new StringBuilder("CREATE FORCE TRIGGER "); buff.append(getSQL()); if (insteadOf) { buff.append(" INSTEAD OF "); } else if (before) { buff.append(" BEFORE "); } else { buff.append(" AFTER "); } buff.append(getTypeNameList()); buff.append(" ON ").append(table.getSQL()); if (rowBased) { buff.append(" FOR EACH ROW"); } if (noWait) { buff.append(" NOWAIT"); } else { buff.append(" QUEUE ").append(queueSize); } if (triggerClassName != null) { buff.append(" CALL ").append(database.quoteIdentifier(triggerClassName)); } else { buff.append(" AS ").append(StringUtils.quoteStringSQL(triggerSource)); } return buff.toString(); }
buff.append(" COMMENT ").append(StringUtils.quoteStringSQL(comment));
@Override public String getSQL() { String s; if (type == Value.CLOB) { s = getString(); return StringUtils.quoteStringSQL(s); } byte[] buff = getBytes(); s = StringUtils.convertBytesToHex(buff); return "X'" + s + "'"; }
break; buff.append(StringUtils.quoteStringSQL(new String(chars, 0, len))).append(", NULL)"); String sql = buff.toString(); add(sql, true);
private String getCreateSQL(boolean orReplace, boolean force, String quotedName) { StatementBuilder buff = new StatementBuilder("CREATE "); if (orReplace) { buff.append("OR REPLACE "); } if (force) { buff.append("FORCE "); } buff.append("VIEW "); buff.append(quotedName); if (comment != null) { buff.append(" COMMENT ").append(StringUtils.quoteStringSQL(comment)); } if (columns != null && columns.length > 0) { buff.append('('); for (Column c : columns) { buff.appendExceptFirst(", "); buff.append(c.getSQL()); } buff.append(')'); } else if (columnNames != null) { buff.append('('); for (String n : columnNames) { buff.appendExceptFirst(", "); buff.append(n); } buff.append(')'); } return buff.append(" AS\n").append(querySQL).toString(); }
buff.append(" COMMENT ").append(StringUtils.quoteStringSQL(comment));
private String getCreateSQLForCopy(Table forTable, String quotedName, boolean internalIndex) { StatementBuilder buff = new StatementBuilder("ALTER TABLE "); buff.append(forTable.getSQL()).append(" ADD CONSTRAINT "); if (forTable.isHidden()) { buff.append("IF NOT EXISTS "); } buff.append(quotedName); if (comment != null) { buff.append(" COMMENT ").append(StringUtils.quoteStringSQL(comment)); } buff.append(' ').append(getTypeName()).append('('); for (IndexColumn c : columns) { buff.appendExceptFirst(", "); buff.append(forTable.getDatabase().quoteIdentifier(c.column.getName())); } buff.append(')'); if (internalIndex && indexOwner && forTable == this.table) { buff.append(" INDEX ").append(index.getSQL()); } return buff.toString(); }
buff.append(" COMMENT ").append(StringUtils.quoteStringSQL(comment));