-
Notifications
You must be signed in to change notification settings - Fork 1
/
function.go
115 lines (88 loc) · 2.32 KB
/
function.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
113
114
115
package sqlbuilder
func Func(name string, args ...AsExpr) *FuncExpr {
return &FuncExpr{name: name, args: args}
}
type FuncExpr struct {
name string
args []AsExpr
}
func (e *FuncExpr) AsExpr(s *Serializer) {
s.D(e.name).D("(")
for i, arg := range e.args {
s.F(arg.AsExpr).DC(", ", i != len(e.args)-1)
}
s.D(")")
}
func (e *FuncExpr) As(alias string) *ColumnAlias {
return AliasColumn(e, alias)
}
// FuncTableExpr is deprecated in favour of FuncTableWithoutNameExpr
type FuncTableExpr struct {
expr *FuncExpr
name string
column *BasicColumn
}
// FuncTable is deprecated in favour of FuncTableWithoutName
func FuncTable(expr *FuncExpr, name string) *FuncTableExpr {
t := &FuncTableExpr{
expr: expr,
name: name,
}
t.column = &BasicColumn{name: name}
return t
}
func (t *FuncTableExpr) AsNamed(s *Serializer) {
s.N(t.name)
}
func (t *FuncTableExpr) AsTableOrSubquery(s *Serializer) {
s.F(t.expr.AsExpr).D(" ").N(t.name)
}
func (t *FuncTableExpr) C(name string) *BasicColumn {
if t.name != name {
return nil
}
return t.column
}
func (t *FuncTableExpr) Join(kind string, right AsTableOrSubquery) *JoinExpr {
return Join(kind, t, right)
}
func (t *FuncTableExpr) LeftJoin(right AsTableOrSubquery) *JoinExpr {
return LeftJoin(t, right)
}
func (t *FuncTableExpr) CrossJoin(right AsTableOrSubquery) *JoinExpr {
return CrossJoin(t, right)
}
type FuncTableWithoutNameExpr struct {
expr *FuncExpr
names []string
columns []*BasicColumn
}
func FuncTableWithoutName(expr *FuncExpr, names ...string) *FuncTableWithoutNameExpr {
t := &FuncTableWithoutNameExpr{expr: expr, names: names}
columns := make([]*BasicColumn, len(names))
for i, v := range names {
columns[i] = &BasicColumn{name: v}
}
t.columns = columns
return t
}
func (t *FuncTableWithoutNameExpr) AsTableOrSubquery(s *Serializer) {
s.F(t.expr.AsExpr)
}
func (t *FuncTableWithoutNameExpr) C(name string) *BasicColumn {
for i, n := range t.names {
if n == name {
return t.columns[i]
}
}
return nil
}
func (t *FuncTableWithoutNameExpr) Join(kind string, right AsTableOrSubquery) *JoinExpr {
return Join(kind, t, right)
}
func (t *FuncTableWithoutNameExpr) LeftJoin(right AsTableOrSubquery) *JoinExpr {
return LeftJoin(t, right)
}
func (t *FuncTableWithoutNameExpr) CrossJoin(right AsTableOrSubquery) *JoinExpr {
return CrossJoin(t, right)
}