-
Notifications
You must be signed in to change notification settings - Fork 732
/
update_stmt.go
112 lines (100 loc) · 2.08 KB
/
update_stmt.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
package ast
import "strings"
type UpdateStmt struct {
Relations *List
TargetList *List
WhereClause Node
FromClause *List
LimitCount Node
ReturningList *List
WithClause *WithClause
}
func (n *UpdateStmt) Pos() int {
return 0
}
func (n *UpdateStmt) Format(buf *TrackedBuffer) {
if n == nil {
return
}
if n.WithClause != nil {
buf.astFormat(n.WithClause)
buf.WriteString(" ")
}
buf.WriteString("UPDATE ")
if items(n.Relations) {
buf.astFormat(n.Relations)
}
if items(n.TargetList) {
buf.WriteString(" SET ")
multi := false
for _, item := range n.TargetList.Items {
switch nn := item.(type) {
case *ResTarget:
if _, ok := nn.Val.(*MultiAssignRef); ok {
multi = true
}
}
}
if multi {
names := []string{}
vals := &List{}
for _, item := range n.TargetList.Items {
res, ok := item.(*ResTarget)
if !ok {
continue
}
if res.Name != nil {
names = append(names, *res.Name)
}
multi, ok := res.Val.(*MultiAssignRef)
if !ok {
vals.Items = append(vals.Items, res.Val)
continue
}
row, ok := multi.Source.(*RowExpr)
if !ok {
vals.Items = append(vals.Items, res.Val)
continue
}
vals.Items = append(vals.Items, row.Args.Items[multi.Colno-1])
}
buf.WriteString("(")
buf.WriteString(strings.Join(names, ","))
buf.WriteString(") = (")
buf.join(vals, ",")
buf.WriteString(")")
} else {
for i, item := range n.TargetList.Items {
if i > 0 {
buf.WriteString(", ")
}
switch nn := item.(type) {
case *ResTarget:
if nn.Name != nil {
buf.WriteString(*nn.Name)
}
buf.WriteString(" = ")
buf.astFormat(nn.Val)
default:
buf.astFormat(item)
}
}
}
}
if items(n.FromClause) {
buf.WriteString(" FROM ")
buf.astFormat(n.FromClause)
}
if set(n.WhereClause) {
buf.WriteString(" WHERE ")
buf.astFormat(n.WhereClause)
}
if set(n.LimitCount) {
buf.WriteString(" LIMIT ")
buf.astFormat(n.LimitCount)
}
if items(n.ReturningList) {
buf.WriteString(" RETURNING ")
buf.astFormat(n.ReturningList)
}
}