/
role.go
57 lines (49 loc) · 1.41 KB
/
role.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
package data
import (
"context"
"errors"
"github.com/goxiaoy/go-eventbus"
kitgorm "github.com/go-saas/kit/pkg/gorm"
v12 "github.com/go-saas/kit/user/api/role/v1"
"github.com/go-saas/kit/user/private/biz"
"gorm.io/gorm"
)
type RoleRepo struct {
*kitgorm.Repo[biz.Role, string, v12.ListRolesRequest]
}
func NewRoleRepo(data *Data, eventbus *eventbus.EventBus) biz.RoleRepo {
res := &RoleRepo{}
res.Repo = kitgorm.NewRepo[biz.Role, string, v12.ListRolesRequest](data.DbProvider, eventbus, res)
return res
}
func (r *RoleRepo) GetDb(ctx context.Context) *gorm.DB {
return GetDb(ctx, r.DbProvider)
}
//BuildFilterScope filter
func (r *RoleRepo) BuildFilterScope(q *v12.ListRolesRequest) func(db *gorm.DB) *gorm.DB {
filter := q.Filter
return func(db *gorm.DB) *gorm.DB {
if filter == nil {
return db
}
ret := db
ret = ret.Scopes(kitgorm.BuildStringFilter("`id`", filter.Id))
ret = ret.Scopes(kitgorm.BuildStringFilter("`name`", filter.Name))
return ret
}
}
//DefaultSorting get default sorting
func (r *RoleRepo) DefaultSorting() []string {
return []string{"-created_at"}
}
func (r *RoleRepo) FindByName(ctx context.Context, name string) (*biz.Role, error) {
db := r.GetDb(ctx).Model(&biz.Role{})
var item = &biz.Role{}
if err := db.Where("normalized_name = ?", name).First(item).Error; err != nil {
if errors.Is(err, gorm.ErrRecordNotFound) {
return nil, nil
}
return nil, err
}
return item, nil
}