-
Notifications
You must be signed in to change notification settings - Fork 2
/
db_backed_role_repository.go
86 lines (74 loc) · 2.26 KB
/
db_backed_role_repository.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
// Copyright 2014 Daniel Akiva
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
// http://www.apache.org/licenses/LICENSE-2.0
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
package nogo
import "github.com/dakiva/dbx"
type dbBackedRoleRepository struct {
ctx dbx.DBContext
queryMap dbx.QueryMap
}
// Construct a new DB backed RoleRepository
func NewDBBackedRoleRepository(ctx dbx.DBContext, queryMap dbx.QueryMap) RoleRepository {
return &dbBackedRoleRepository{ctx: ctx, queryMap: queryMap}
}
func (this *dbBackedRoleRepository) FindAll() ([]Role, error) {
rows, err := this.ctx.NamedQuery(this.queryMap.Q("FindAllRoles"), map[string]interface{}{})
if err != nil {
return nil, err
}
defer rows.Close()
roles := make([]Role, 0)
for rows.Next() {
role := &defaultRole{}
err = rows.StructScan(role)
if err != nil {
return nil, err
}
roles = append(roles, role)
}
return roles, nil
}
func (this *dbBackedRoleRepository) FindRole(roleName string) (Role, error) {
rows, err := this.ctx.NamedQuery(this.queryMap.Q("FindRole"), map[string]interface{}{"role_name": roleName})
if err != nil {
return nil, err
}
defer rows.Close()
if rows.Next() {
role := &defaultRole{}
err = rows.StructScan(role)
if err != nil {
return nil, err
}
return role, nil
}
return nil, nil
}
func (this *dbBackedRoleRepository) CreateRole(role Role) error {
_, err := this.ctx.NamedExec(this.queryMap.Q("InsertRole"), role)
if err != nil {
return err
}
return nil
}
func (this *dbBackedRoleRepository) UpdateRole(role Role) error {
_, err := this.ctx.NamedExec(this.queryMap.Q("UpdateRole"), role)
if err != nil {
return err
}
return nil
}
func (this *dbBackedRoleRepository) DeleteRole(roleName string) error {
_, err := this.ctx.NamedExec(this.queryMap.Q("DeleteRole"), map[string]interface{}{"role_name": roleName})
if err != nil {
return err
}
return nil
}