-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathorder_by.go
More file actions
131 lines (108 loc) · 2.14 KB
/
order_by.go
File metadata and controls
131 lines (108 loc) · 2.14 KB
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
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
package gormx
import (
"fmt"
"strings"
)
// OrderByOne is a single order by.
type OrderByOne struct {
Key string
IsDESC bool
//
clause string
}
// String returns the string of the order by.
func (w *OrderByOne) String() string {
return w.Clause()
}
// Clause returns the clause of the order by.
func (w *OrderByOne) Clause() string {
if w.clause == "" {
orderMod := "ASC"
if w.IsDESC {
orderMod = "DESC"
}
w.clause = fmt.Sprintf("%s %s", w.Key, orderMod)
}
return w.clause
}
// OrderBy is a list of order bys.
type OrderBy []OrderByOne
// NewOrderBy returns a new order by.
func NewOrderBy() *OrderBy {
return &OrderBy{}
}
// Set sets a order by.
func (w *OrderBy) Set(key string, IsDESC bool) {
*w = append(*w, OrderByOne{
Key: key,
IsDESC: IsDESC,
})
}
// Get gets a order by.
func (w *OrderBy) Get(key string) (bool, bool) {
for _, v := range *w {
if v.Key == key {
return v.IsDESC, true
}
}
return false, false
}
// Add adds a order by.
func (w *OrderBy) Add(key string, IsDESC bool) {
*w = append(*w, OrderByOne{
Key: key,
IsDESC: IsDESC,
})
}
// AddClause adds a order by clause.
func (w *OrderBy) AddClause(clause string) {
*w = append(*w, OrderByOne{
clause: clause,
})
}
// Del deletes a order by.
func (w *OrderBy) Del(key string) {
for i, v := range *w {
if v.Key == key {
*w = append((*w)[:i], (*w)[i+1:]...)
break
}
}
}
// Debug prints the order bys.
func (w *OrderBy) Debug() {
for _, v := range *w {
var desc string
if v.IsDESC {
desc = "DESC"
} else {
desc = "ASC"
}
fmt.Printf("[order_by] %s %s\n", v.Key, desc)
}
}
// Length returns the length of the order bys.
func (w *OrderBy) Length() int {
return len(*w)
}
// GetClause gets the order by clause.
func (w *OrderBy) GetClause(key string) string {
for _, v := range *w {
if v.Key == key {
return v.clause
}
}
return ""
}
// Build builds the order bys.
func (w *OrderBy) Build() string {
orders := []string{}
for _, order := range *w {
orders = append(orders, order.Clause())
}
return strings.Join(orders, ",")
}
// Reset resets the order bys.
func (w *OrderBy) Reset() {
*w = []OrderByOne{}
}