Method SQL

pkg/sql/ast/sql.go:684–731

SQL returns the full SQL string for this UPDATE statement, including the optional WITH clause, SET assignments, FROM clause, WHERE condition, and RETURNING clause.

()

// optional WITH clause, SET assignments, FROM clause, WHERE condition, and
// RETURNING clause.
func (u *UpdateStatement) SQL() string {
	if u == nil {
		return ""
	}
	sb := getBuilder()
	defer putBuilder(sb)

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

	sb.WriteString("UPDATE ")
	sb.WriteString(u.TableName)
	if u.Alias != "" {
		sb.WriteString(" ")
		sb.WriteString(u.Alias)
	}

	sb.WriteString(" SET ")
	updates := u.Assignments
	upds := make([]string, len(updates))
	for i, upd := range updates {
		upds[i] = exprSQL(upd.Column) + " = " + exprSQL(upd.Value)
	}
	sb.WriteString(strings.Join(upds, ", "))

	if len(u.From) > 0 {
		sb.WriteString(" FROM ")
		froms := make([]string, len(u.From))
		for i := range u.From {
			froms[i] = tableRefSQL(&u.From[i])
		}
		sb.WriteString(strings.Join(froms, ", "))
	}

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

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

	return sb.String()
}

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