/
filters.go
93 lines (78 loc) · 2.57 KB
/
filters.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
package bsdb
import (
"github.com/forbole/juno/v4/common"
"gorm.io/gorm"
)
func ContinuationTokenFilter(continuationToken string) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
return db.Where("object_name >= ?", continuationToken)
}
}
func PrefixFilter(prefix string) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
return db.Where("object_name LIKE ?", prefix+"%")
}
}
func PathNameFilter(pathName string) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
return db.Where("path_name = ?", pathName)
}
}
func NameFilter(name string) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
return db.Where("name like ?", name+"%")
}
}
func FullNameFilter(fullName string) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
return db.Where("full_name >= ?", fullName)
}
}
func SourceTypeFilter(sourceType string) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
return db.Where("source_type = ?", sourceType)
}
}
func RemovedFilter(removed bool) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
return db.Where("removed = ?", removed)
}
}
func BucketIDStartAfterFilter(bucketID common.Hash) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
return db.Where("bucket_id > ?", bucketID)
}
}
func ObjectIDStartAfterFilter(objectID common.Hash) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
return db.Where("object_id > ?", objectID)
}
}
func GroupIDStartAfterFilter(groupID common.Hash) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
return db.Where("group_id > ?", groupID)
}
}
// GroupAccountIDStartAfterFilter
// In the "group" table, each group has an account ID of "0x0000000000000000000000000000000000000000" representing the group's creation information.
// Since the "group" table maps groups to account, this special value is used to filter out non-user data
func GroupAccountIDStartAfterFilter(accountID common.Address) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
return db.Where("account_id > ? and account_id != ?", accountID, common.HexToAddress("0"))
}
}
func CreateAtFilter(createAt int64) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
return db.Where("create_at <= ?", createAt)
}
}
func CreateAtEqualFilter(createAt int64) func(db *gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
return db.Where("create_at = ?", createAt)
}
}
func WithLimit(limit int) func(*gorm.DB) *gorm.DB {
return func(db *gorm.DB) *gorm.DB {
return db.Limit(limit)
}
}