/** * Convert this expression to a String. * * @return the string representation */ @Override public String toString() { return getSQL(); }
String getDefaultSQL() { return defaultExpression == null ? null : defaultExpression.getSQL(); }
@Override public String getSQL() { return "(NOT " + condition.getSQL() + ")"; }
String getOnUpdateSQL() { return onUpdateExpression == null ? null : onUpdateExpression.getSQL(); }
@Override public String getSQL() { String sql; switch (andOrType) { case AND: sql = left.getSQL() + "\n AND " + right.getSQL(); break; case OR: sql = left.getSQL() + "\n OR " + right.getSQL(); break; default: throw DbException.throwInternalError("andOrType=" + andOrType); } return "(" + sql + ")"; }
@Override public String getSQL() { String sql; if (opType == OpType.NEGATE) { // don't remove the space, otherwise it might end up some thing like // --1 which is a line remark sql = "- " + left.getSQL(); } else { // don't remove the space, otherwise it might end up some thing like // --1 which is a line remark sql = left.getSQL() + " " + getOperationToken() + " " + right.getSQL(); } return "(" + sql + ")"; }
/** * Get the alias name of a column or SQL expression * if it is not an aliased expression. * * @return the alias name */ public String getAlias() { return StringUtils.unEnclose(getSQL()); }
/** * Get the check constraint SQL snippet. * * @param session the session * @param asColumnName the column name to use * @return the SQL snippet */ String getCheckConstraintSQL(Session session, String asColumnName) { Expression constraint = getCheckConstraint(session, asColumnName); return constraint == null ? "" : constraint.getSQL(); }
@Override public String getSQL() { return expr.getSQL() + " AS " + Parser.quoteIdentifier(alias); }
@Override public String getSQL() { return '(' + left.getSQL() + " = ANY(" + parameter.getSQL() + "))"; }
private String getShortDescription() { return getName() + ": " + expr.getSQL(); }
private static void checkDefaultReferencesTable(Table table, Expression defaultExpression) { if (defaultExpression == null) { return; } HashSet<DbObject> dependencies = new HashSet<>(); ExpressionVisitor visitor = ExpressionVisitor .getDependenciesVisitor(dependencies); defaultExpression.isEverything(visitor); if (dependencies.contains(table)) { throw DbException.get(ErrorCode.COLUMN_IS_REFERENCED_1, defaultExpression.getSQL()); } }
@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 getSQL() { StatementBuilder buff = new StatementBuilder(); buff.append(Parser.quoteIdentifier(userAggregate.getName())).append('('); for (Expression e : args) { buff.appendExceptFirst(", "); buff.append(e.getSQL()); } buff.append(')'); if (filterCondition != null) { buff.append(" FILTER (WHERE ").append(filterCondition.getSQL()).append(')'); } return buff.toString(); }
@Override public void checkExistingData(Session session) { if (session.getDatabase().isStarting()) { // don't check at startup return; } String sql = "SELECT 1 FROM " + filter.getTable().getSQL() + " WHERE NOT(" + expr.getSQL() + ")"; ResultInterface r = session.prepare(sql).query(1); if (r.next()) { throw DbException.get(ErrorCode.CHECK_CONSTRAINT_VIOLATED_1, getName()); } }
@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(); }