Method SQL

pkg/sql/ast/sql.go:735–774

SQL returns the full SQL string for this DELETE statement, including the optional WITH clause, USING clause, WHERE condition, and RETURNING clause.

()

// SQL returns the full SQL string for this DELETE statement, including the
// optional WITH clause, USING clause, WHERE condition, and RETURNING clause.
func (d *DeleteStatement) SQL() string {
	if d == nil {
		return ""
	}
	sb := getBuilder()
	defer putBuilder(sb)

	if d.With != nil {
		sb.WriteString(d.With.SQL())
		sb.WriteString(" ")
	}

	sb.WriteString("DELETE FROM ")
	sb.WriteString(d.TableName)
	if d.Alias != "" {
		sb.WriteString(" ")
		sb.WriteString(d.Alias)
	}

	if len(d.Using) > 0 {
		sb.WriteString(" USING ")
		usings := make([]string, len(d.Using))
		for i := range d.Using {
			usings[i] = tableRefSQL(&d.Using[i])
		}
		sb.WriteString(strings.Join(usings, ", "))
	}

	if d.Where != nil {
		sb.WriteString(" WHERE ")
		sb.WriteString(exprSQL(d.Where))
	}

	if len(d.Returning) > 0 {
		sb.WriteString(" RETURNING ")
		sb.WriteString(exprListSQL(d.Returning))
	}

	return sb.String()
}

// SQL returns the full SQL string for this CREATE TABLE statement including
// column definitions, table constraints, INHERITS, PARTITION BY, and table options.