/
dal_user_feed.go
68 lines (59 loc) · 1.64 KB
/
dal_user_feed.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
package dal
type ModelUserFeedRelation struct {
BaseModel
UserID int64 `gorm:"column:user_id"`
FeedID int64 `gorm:"column:feed_id"`
TagName string `gorm:"column:tag_name"`
Title string `gorm:"column:title"`
}
func (ModelUserFeedRelation) TableName() string {
return "user_feed"
}
func (r *Client) ListUserFeed(userID int64) ([]*ModelUserFeedRelation, error) {
var pos []*ModelUserFeedRelation
err := r.db.
Where("user_id = ?", userID).Find(&pos).Error
if err != nil {
return nil, err
}
return pos, nil
}
func (r *Client) ListFeedUserIDs(feedID int64) ([]int64, error) {
var ids []int64
err := r.db.
Model(&ModelUserFeedRelation{}).
Where("feed_id = ?", feedID).
Pluck("user_id", &ids).Error
return ids, err
}
func (r *Client) ListUserFeedIDs(userID int64) ([]int64, error) {
var ids []int64
err := r.db.
Model(&ModelUserFeedRelation{}).
Where("user_id = ?", userID).
Pluck("feed_id", &ids).Error
return ids, err
}
func (r *Client) CreateUserFeed(userID, feedID int64, title string) error {
err := r.db.Clauses(ignoreInsertClause).Create(&ModelUserFeedRelation{
UserID: userID,
FeedID: feedID,
Title: title,
TagName: defaultTagName,
}).Error
if err != nil {
return err
}
return nil
}
func (r *Client) DeleteUserFeed(userID, feedID int64) error {
err := r.db.Unscoped().Where("user_id = ? and feed_id = ?", userID, feedID).
Delete(&ModelUserFeedRelation{}).Error
return err
}
func (r *Client) UpdateUserFeedTitle(userID, feedID int64, newTitle string) error {
err := r.db.Model(&ModelUserFeedRelation{}).
Where("user_id = ? and feed_id = ?", userID, feedID).
Update("title", newTitle).Error
return err
}