/
tag_db.go
60 lines (52 loc) · 1.36 KB
/
tag_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
package adapter
import (
"context"
"database/sql"
"github.com/juju/errors"
"github.com/vertex-center/uuid"
"github.com/vertex-center/vertex/server/apps/containers/core/port"
"github.com/vertex-center/vertex/server/apps/containers/core/types"
"github.com/vertex-center/vertex/server/common/storage"
)
type tagDBAdapter struct {
db storage.DB
}
func NewTagDBAdapter(db storage.DB) port.TagAdapter {
return &tagDBAdapter{db}
}
func (a *tagDBAdapter) GetTag(ctx context.Context, userID uuid.UUID, name string) (types.Tag, error) {
var tag types.Tag
err := a.db.Get(&tag, `
SELECT * FROM tags
WHERE user_id = $1 AND name = $2
`, userID, name)
if errors.Is(err, sql.ErrNoRows) {
err = errors.NotFoundf("tag %s", name)
}
return tag, err
}
func (a *tagDBAdapter) GetTags(ctx context.Context, userID uuid.UUID) (types.Tags, error) {
var tags types.Tags
err := a.db.Select(&tags, `
SELECT * FROM tags
WHERE user_id = $1
`, userID)
if errors.Is(err, sql.ErrNoRows) {
return tags, nil
}
return tags, err
}
func (a *tagDBAdapter) CreateTag(ctx context.Context, tag types.Tag) error {
_, err := a.db.NamedExec(`
INSERT INTO tags (id, user_id, name)
VALUES (:id, :user_id, :name)
`, tag)
return err
}
func (a *tagDBAdapter) DeleteTag(ctx context.Context, id uuid.UUID) error {
_, err := a.db.Exec(`
DELETE FROM tags
WHERE id = $1
`, id)
return err
}