-
Notifications
You must be signed in to change notification settings - Fork 832
/
ingress.go
110 lines (93 loc) · 2.68 KB
/
ingress.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
package models
import (
"errors"
"fmt"
"strconv"
"strings"
"time"
)
const TableNameIngress = "ingress"
type ingressModel struct {
}
type Ingress struct {
Id int64 `orm:"auto" json:"id,omitempty"`
Name string `orm:"unique;index;size(128)" json:"name,omitempty"`
MetaData string `orm:"type(text)" json:"metaData,omitempty"`
App *App `orm:"index;rel(fk)" json:"app,omitempty"`
Description string `orm:"null,size(512)" json:"description,omitempty"`
OrderId int64 `orm:"index;default(0)" json:"order"`
CreateTime *time.Time `orm:"auto_now_add;type(datetime)" json:"createTime,omitempty"`
UpdateTime *time.Time `orm:"auto_now;type(datetime)" json:"updateTime,omitempty"`
User string `orm:"size(128)" json:"user,omitempty"`
Deleted bool `orm:"default(false)" json:"deleted,omitempty"`
AppId int64 `orm:"-" json:"appId,omitempty"`
}
func (*Ingress) TableName() string {
return TableNameIngress
}
func (*ingressModel) GetNames(filters map[string]interface{}) (ingreses []Ingress, err error) {
qs := Ormer().QueryTable(new(Ingress))
if len(filters) > 0 {
for k, v := range filters {
qs = qs.Filter(k, v)
}
}
_, err = qs.All(&ingreses, "Id", "Name")
if err != nil {
return nil, err
}
return
}
func (*ingressModel) Add(ingr *Ingress) (id int64, err error) {
ingr.App = &App{Id: ingr.AppId}
ingr.CreateTime = nil
id, err = Ormer().Insert(ingr)
return
}
func (*ingressModel) UpdateOrders(ingrs []*Ingress) error {
if len(ingrs) <= 0 {
return errors.New("need at lest one ingress")
}
batchUpdateSql := fmt.Sprintf("update `%s` set `order_id` = case ", TableNameIngress)
ids := make([]string, 0)
for _, ingr := range ingrs {
ids = append(ids, strconv.Itoa(int(ingr.Id)))
batchUpdateSql = fmt.Sprintf("%s when `id` = %d then %d ", batchUpdateSql, ingr.Id, ingr.OrderId)
}
batchUpdateSql = fmt.Sprintf("%s end where `id` in (%s)", batchUpdateSql, strings.Join(ids, ","))
_, err := Ormer().Raw(batchUpdateSql).Exec()
return err
}
func (*ingressModel) UpdateById(m *Ingress) (err error) {
v := Ingress{Id: m.Id}
// ascertain id exists in the database
if err = Ormer().Read(&v); err == nil {
m.UpdateTime = nil
m.App = &App{Id: m.AppId}
_, err = Ormer().Update(m)
return err
}
return
}
func (*ingressModel) GetById(id int64) (v *Ingress, err error) {
v = new(Ingress)
v.Id = id
if err = Ormer().Read(v); err != nil {
return nil, err
}
v.AppId = v.App.Id
return
}
func (*ingressModel) DeleteById(id int64, logical bool) (err error) {
v := Ingress{Id: id}
if err = Ormer().Read(&v); err != nil {
return
}
if logical {
v.Deleted = true
_, err = Ormer().Update(&v)
return
}
_, err = Ormer().Delete(&v)
return
}