/** * Returns the contents of this SQL buffer as a 'certified kocher' SQL * string. * * <p>Use this method in preference to {@link #toString()}. It indicates * that the SQL string has been constructed using good hygiene, and is * therefore less likely to contain SQL injection or badly quoted * identifiers or strings. * * @return Contents of this builder as a SQL string. */ public SqlString toSqlString() { return new SqlString(dialect, buf.toString()); }
/** * Returns the contents of this SQL buffer as a 'certified kocher' SQL * string. * * <p>Use this method in preference to {@link #toString()}. It indicates * that the SQL string has been constructed using good hygiene, and is * therefore less likely to contain SQL injection or badly quoted * identifiers or strings. * * @return Contents of this builder as a SQL string. */ public SqlString toSqlString() { return new SqlString(dialect, buf.toString()); }
public SqlString toSqlString() { ImmutableList<Integer> dynamicParameters = this.dynamicParameters == null ? null : this.dynamicParameters.build(); return new SqlString(dialect, toString(), dynamicParameters); }
protected void generateTypeString(StringBuilder sb, boolean withDetail) { sb.append("INTERVAL "); final SqlDialect dialect = AnsiSqlDialect.DEFAULT; final SqlPrettyWriter writer = new SqlPrettyWriter(dialect); writer.setAlwaysUseParentheses(false); writer.setSelectListItemsOnSeparateLines(false); writer.setIndentation(0); intervalQualifier.unparse(writer, 0, 0); final String sql = writer.toString(); sb.append(new SqlString(dialect, sql).getSql()); }
protected void generateTypeString(StringBuilder sb, boolean withDetail) { sb.append("INTERVAL "); final SqlDialect dialect = AnsiSqlDialect.DEFAULT; final SqlPrettyWriter writer = new SqlPrettyWriter(dialect); writer.setAlwaysUseParentheses(false); writer.setSelectListItemsOnSeparateLines(false); writer.setIndentation(0); intervalQualifier.unparse(writer, 0, 0); final String sql = writer.toString(); sb.append(new SqlString(dialect, sql).getSql()); }
/** * Returns the SQL text of the tree of which this <code>SqlNode</code> is * the root. * * @param dialect Dialect * @param forceParens wraps all expressions in parentheses; good for parse * test, but false by default. * * <p>Typical return values are:</p> * <ul> * <li>'It''s a bird!'</li> * <li>NULL</li> * <li>12.3</li> * <li>DATE '1969-04-29'</li> * </ul> */ public SqlString toSqlString(SqlDialect dialect, boolean forceParens) { if (dialect == null) { dialect = AnsiSqlDialect.DEFAULT; } SqlPrettyWriter writer = new SqlPrettyWriter(dialect); writer.setAlwaysUseParentheses(forceParens); writer.setSelectListItemsOnSeparateLines(false); writer.setIndentation(0); unparse(writer, 0, 0); final String sql = writer.toString(); return new SqlString(dialect, sql); }