/
subscribe.go
70 lines (63 loc) · 2.2 KB
/
subscribe.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
package persistance
import (
"context"
model2 "github.com/go-related/graphql/internal/model"
"github.com/sirupsen/logrus"
)
func (l *libraryDb) Subscribe(ctx context.Context, subscriberID uint, listOfBooks []model2.Book, listOfAuthors []model2.Author) (*model2.Subscribe, error) {
data := model2.Subscribe{
SubscriberID: subscriberID,
Books: listOfBooks,
Authors: listOfAuthors,
}
result := l.Db.Model(&model2.Subscribe{}).Create(&data)
if result.Error != nil {
logrus.WithError(result.Error).Error("couldn't create the subscribe")
}
return &data, result.Error
}
func (l *libraryDb) DeleteSubscribe(ctx context.Context, Id uint) error {
currentData, err := l.GetSubscribeById(ctx, Id)
if err != nil {
return err
}
result := l.Db.Delete(¤tData)
if result.Error != nil {
logrus.WithError(result.Error).WithField("id", Id).Error("Error deleting subscribe")
}
return nil
}
func (l *libraryDb) GetAllSubscribes(ctx context.Context) ([]*model2.Subscribe, error) {
var outputList []*model2.Subscribe
result := l.Db.Model(&model2.Subscribe{}).Find(&outputList)
if result.Error != nil {
logrus.WithError(result.Error).Error("couldn't load subscribes")
}
return outputList, result.Error
}
func (l *libraryDb) GetSubscribeById(ctx context.Context, Id uint) (*model2.Subscribe, error) {
var output model2.Subscribe
result := l.Db.Model(&model2.Subscribe{}).First(&output, Id)
if result.Error != nil {
logrus.WithError(result.Error).Error("couldn't load subscribe")
}
return &output, result.Error
}
func (l *libraryDb) GetAuthorsSubscribers(ctx context.Context, listOfAuthors []model2.Author) ([]*model2.Subscriber, error) {
var outputList []*model2.Subscriber
if len(listOfAuthors) == 0 {
return outputList, nil
}
var authors []uint
for _, author := range listOfAuthors {
authors = append(authors, author.ID)
}
result := l.Db.Model(&model2.Subscriber{}).
Joins(`join subscribes s on s.subscriber_id= subscribers.id`).
Joins(`join subscribe_author sa ON sa.subscribe_id =s.id `).
Where(" sa.author_id in ? ", authors).Find(&outputList)
if result.Error != nil {
logrus.WithError(result.Error).Error("couldn't load subscribers for the authors")
}
return outputList, result.Error
}