This repository has been archived by the owner on Aug 18, 2022. It is now read-only.
/
db.go
119 lines (105 loc) · 2.4 KB
/
db.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
package cockroachdb
import (
"context"
"database/sql"
"encoding/json"
"github.com/51st-state/api/pkg/apis/role"
"github.com/51st-state/api/pkg/rbac"
)
// CreateSchema for the cockroachdb repository
func CreateSchema(ctx context.Context, db *sql.DB) (err error) {
_, err = db.ExecContext(
ctx,
`CREATE TABLE IF NOT EXISTS role_info (
id TEXT PRIMARY KEY,
title TEXT NOT NULL DEFAULT '',
description TEXT NOT NULL DEFAULT ''
);
CREATE UNIQUE INDEX IF NOT EXISTS role_info_idx_id ON role_info (id);`,
)
return
}
type db struct {
database *sql.DB
}
// NewRepository for storage of role information in a cockroachdb database
func NewRepository(d *sql.DB) role.Repository {
return &db{
d,
}
}
type complete struct {
role.Identifier
role.Incomplete
}
func newComplete(id role.Identifier, inc role.Incomplete) role.Complete {
return &complete{id, inc}
}
func (c *complete) MarshalJSON() ([]byte, error) {
return json.Marshal(&struct {
ID rbac.RoleID `json:"id"`
Title string `json:"title"`
Description string `json:"description"`
Rules rbac.RoleRules `json:"rules"`
}{
c.ID(),
c.Data().Title,
c.Data().Description,
c.Data().Rules,
})
}
func (d *db) Get(ctx context.Context, id role.Identifier) (role.Complete, error) {
inc := role.NewIncomplete("", "", make(rbac.RoleRules, 0))
if err := d.database.QueryRowContext(
ctx,
`SELECT title,
description
FROM role_info
WHERE id = $1`,
id.ID(),
).Scan(
&inc.Data().Title,
&inc.Data().Description,
); err != nil {
return nil, err
}
return newComplete(id, inc), nil
}
func (d *db) Update(ctx context.Context, c role.Complete) error {
_, err := d.database.ExecContext(
ctx,
`UPDATE role_info
SET title = $1,
description = $2
WHERE id = $3`,
c.Data().Title,
c.Data().Description,
c.ID(),
)
return err
}
func (d *db) Create(ctx context.Context, c role.Complete) error {
_, err := d.database.ExecContext(
ctx,
`INSERT INTO role_info (
id,
title,
description
) SELECT $1,
$2,
$3`,
c.ID(),
c.Data().Title,
c.Data().Description,
)
return err
}
func (d *db) Delete(ctx context.Context, id role.Identifier) error {
_, err := d.database.ExecContext(
ctx,
`DELETE FROM role_info
WHERE id = $1`,
id.ID(),
)
return err
}