-
Notifications
You must be signed in to change notification settings - Fork 12
/
ast_select.go
112 lines (93 loc) · 3.13 KB
/
ast_select.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
// Copyright 2012, Google Inc. All rights reserved.
// Use of this source code is governed by a BSD-style
// license that can be found in the LICENSE file.
// The MIT License (MIT)
// Copyright (c) 2016 Jerry Bai
// Permission is hereby granted, free of charge, to any person obtaining a copy
// of this software and associated documentation files (the "Software"), to deal
// in the Software without restriction, including without limitation the rights
// to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
// copies of the Software, and to permit persons to whom the Software is
// furnished to do so, subject to the following conditions:
// The above copyright notice and this permission notice shall be included in all
// copies or substantial portions of the Software.
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
// IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
// FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
// AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
// LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
// OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
// SOFTWARE.
package sqlparser
// SelectStatement any SELECT statement.
type SelectStatement interface {
IStatement()
ISelectStatement()
IInsertRows()
SQLNode
}
//SimpleSelect no from and where statement.
type SimpleSelect struct {
Comments Comments
Distinct string
SelectExprs SelectExprs
Limit *Limit
}
func (node *SimpleSelect) Format(buf *TrackedBuffer) {
buf.Fprintf("select %v%s%v%v", node.Comments, node.Distinct, node.SelectExprs, node.Limit)
}
func (*SimpleSelect) IStatement() {}
func (*SimpleSelect) ISelectStatement() {}
func (*SimpleSelect) IInsertRows() {}
// Select represents a SELECT statement.
type Select struct {
Comments Comments
Distinct string
SelectExprs SelectExprs
From TableExprs
Where *Where
GroupBy GroupBy
Having *Where
OrderBy OrderBy
Limit *Limit
Lock string
}
// Select.Distinct
const (
AST_DISTINCT = "distinct "
)
// Select.Lock
const (
AST_FOR_UPDATE = " for update"
AST_SHARE_MODE = " lock in share mode"
)
// Format Select.
func (node *Select) Format(buf *TrackedBuffer) {
buf.Fprintf("select %v%s%v from %v%v%v%v%v%v%s",
node.Comments, node.Distinct, node.SelectExprs,
node.From, node.Where,
node.GroupBy, node.Having, node.OrderBy,
node.Limit, node.Lock)
}
func (node *Select) IStatement() {}
func (node *Select) ISelectStatement() {}
func (node *Select) IInsertRows() {}
// Union represents a UNION statement.
type Union struct {
Type string
Left, Right SelectStatement
}
// Union.Type
const (
AST_UNION = "union"
AST_UNION_ALL = "union all"
AST_SET_MINUS = "minus"
AST_EXCEPT = "except"
AST_INTERSECT = "intersect"
)
func (node *Union) Format(buf *TrackedBuffer) {
buf.Fprintf("%v %s %v", node.Left, node.Type, node.Right)
}
func (node *Union) IStatement() {}
func (node *Union) ISelectStatement() {}
func (node *Union) IInsertRows() {}