/
playlist.go
93 lines (72 loc) · 1.99 KB
/
playlist.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 postgres
import (
"context"
"errors"
"github.com/bookoo-billy/jukebox/db"
"gorm.io/gorm"
"gorm.io/gorm/clause"
v1 "github.com/bookoo-billy/jukebox/proto/api/v1"
"github.com/google/uuid"
)
type PlaylistDAO struct {
db *gorm.DB
}
func NewPlaylistDAO(db *gorm.DB) db.PlaylistDAO {
return &PlaylistDAO{db: db}
}
func (a *PlaylistDAO) Create(ctx context.Context, playlist *v1.Playlist) (*v1.Playlist, error) {
err := a.validate(playlist)
if err != nil {
return nil, err
}
playlist.Id = uuid.New().String()
tx := a.db.WithContext(ctx).Create(playlist)
if tx.Error != nil {
return nil, tx.Error
}
return playlist, nil
}
func (a *PlaylistDAO) Delete(ctx context.Context, query *v1.PlaylistQuery) (*v1.Playlist, error) {
playlist := &v1.Playlist{}
tx := a.db.Model(playlist).
WithContext(ctx).
Clauses(clause.Returning{}).
Delete(v1.Playlist{Id: query.Id})
if tx.Error != nil {
return nil, tx.Error
}
return playlist, nil
}
func (a *PlaylistDAO) Get(ctx context.Context, query *v1.PlaylistQuery) (*v1.Playlist, error) {
playlist := &v1.Playlist{}
tx := a.db.Model(playlist).WithContext(ctx).First(query)
if tx.Error != nil {
return nil, tx.Error
}
return playlist, nil
}
func (a *PlaylistDAO) List(ctx context.Context, query *v1.PlaylistQuery) (*v1.PlaylistList, error) {
var items []*v1.Playlist
tx := a.db.Model(items).WithContext(ctx).Find(query)
if tx.Error != nil {
return nil, tx.Error
}
return &v1.PlaylistList{Items: items}, nil
}
func (a *PlaylistDAO) Update(ctx context.Context, playlist *v1.Playlist) (*v1.Playlist, error) {
if playlist.Id == "" {
return nil, errors.New("Playlist.Id is a required field")
}
updated := &v1.Playlist{}
tx := a.db.Model(updated).WithContext(ctx).Clauses(clause.Returning{}).Updates(playlist)
if tx.Error != nil {
return nil, tx.Error
}
return updated, nil
}
func (a *PlaylistDAO) validate(playlist *v1.Playlist) error {
if playlist.Name == "" {
return errors.New("playlist.Name is a required field")
}
return nil
}