-
Notifications
You must be signed in to change notification settings - Fork 39
/
global_virtual_group_family.go
126 lines (112 loc) · 3.28 KB
/
global_virtual_group_family.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
116
117
118
119
120
121
122
123
124
125
126
package bsdb
import (
"errors"
"fmt"
"time"
"gorm.io/gorm"
)
// ListVirtualGroupFamiliesBySpID list virtual group families by sp id
func (b *BsDBImpl) ListVirtualGroupFamiliesBySpID(spID uint32) ([]*GlobalVirtualGroupFamily, error) {
var (
families []*GlobalVirtualGroupFamily
filters []func(*gorm.DB) *gorm.DB
err error
)
startTime := time.Now()
methodName := currentFunction()
defer func() {
if err != nil {
MetadataDatabaseFailureMetrics(err, startTime, methodName)
} else {
MetadataDatabaseSuccessMetrics(startTime, methodName)
}
}()
filters = append(filters, RemovedFilter(false))
err = b.db.Table((&GlobalVirtualGroupFamily{}).TableName()).
Select("*").
Where("primary_sp_id = ?", spID).
Scopes(filters...).
Find(&families).Error
return families, err
}
// GetVirtualGroupFamiliesByVgfID get virtual group families by vgf id
func (b *BsDBImpl) GetVirtualGroupFamiliesByVgfID(vgfID uint32) (*GlobalVirtualGroupFamily, error) {
var (
family *GlobalVirtualGroupFamily
filters []func(*gorm.DB) *gorm.DB
err error
)
startTime := time.Now()
methodName := currentFunction()
defer func() {
if err != nil {
MetadataDatabaseFailureMetrics(err, startTime, methodName)
} else {
MetadataDatabaseSuccessMetrics(startTime, methodName)
}
}()
filters = append(filters, RemovedFilter(false))
err = b.db.Table((&GlobalVirtualGroupFamily{}).TableName()).
Select("*").
Where("global_virtual_group_family_id = ?", vgfID).
Scopes(filters...).
Take(&family).Error
if errors.Is(err, gorm.ErrRecordNotFound) {
return nil, nil
}
return family, err
}
// ListVgfByGvgID list vgf by gvg id
func (b *BsDBImpl) ListVgfByGvgID(gvgIDs []uint32) ([]*GlobalVirtualGroupFamily, error) {
var (
families []*GlobalVirtualGroupFamily
query string
err error
)
startTime := time.Now()
methodName := currentFunction()
defer func() {
if err != nil {
MetadataDatabaseFailureMetrics(err, startTime, methodName)
} else {
MetadataDatabaseSuccessMetrics(startTime, methodName)
}
}()
if len(gvgIDs) == 0 {
return nil, nil
}
query = fmt.Sprintf("select * from global_virtual_group_families where (FIND_IN_SET('%d', global_virtual_group_ids) > 0", gvgIDs[0])
if len(gvgIDs) > 1 {
for _, id := range gvgIDs[1:] {
subQuery := fmt.Sprintf(" or FIND_IN_SET('%d', global_virtual_group_ids) > 0", id)
query = query + subQuery
}
}
query = query + ") and removed = false;"
err = b.db.Table((&GlobalVirtualGroupFamily{}).TableName()).Raw(query).Find(&families).Error
return families, err
}
// ListVirtualGroupFamiliesByVgfIDs list virtual group families by vgf id
func (b *BsDBImpl) ListVirtualGroupFamiliesByVgfIDs(vgfIDs []uint32) ([]*GlobalVirtualGroupFamily, error) {
var (
families []*GlobalVirtualGroupFamily
filters []func(*gorm.DB) *gorm.DB
err error
)
startTime := time.Now()
methodName := currentFunction()
defer func() {
if err != nil {
MetadataDatabaseFailureMetrics(err, startTime, methodName)
} else {
MetadataDatabaseSuccessMetrics(startTime, methodName)
}
}()
filters = append(filters, RemovedFilter(false))
err = b.db.Table((&GlobalVirtualGroupFamily{}).TableName()).
Select("*").
Where("global_virtual_group_family_id in (?)", vgfIDs).
Scopes(filters...).
Find(&families).Error
return families, err
}