/
tag.go
84 lines (69 loc) · 1.81 KB
/
tag.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
package model
import (
"github.com/go-programming-tour-book/blog-service/pkg/app"
"github.com/jinzhu/gorm"
)
type Tag struct {
*Model
Name string `json:"name"`
State uint8 `json:"state"`
}
func (t Tag) TableName() string {
return "blog_tag"
}
type TagSwagger struct {
List []*Tag
Pager *app.Pager
}
func (t Tag) Count(db *gorm.DB) (int, error) {
var count int
if t.Name != "" {
db = db.Where("name = ?", t.Name)
}
db = db.Where("state = ?", t.State)
if err := db.Model(&t).Where("is_del = ?", 0).Count(&count).Error; err != nil {
return 0, err
}
return count, nil
}
func (t Tag) List(db *gorm.DB, pageOffset, pageSize int) ([]*Tag, error) {
var tags []*Tag
var err error
if pageOffset >= 0 && pageSize > 0 {
db = db.Offset(pageOffset).Limit(pageSize)
}
if t.Name != "" {
db = db.Where("name = ?", t.Name)
}
db = db.Where("state = ?", t.State)
if err = db.Where("is_del = ?", 0).Find(&tags).Error; err != nil {
return nil, err
}
return tags, nil
}
func (t Tag) ListByIDs(db *gorm.DB, ids []uint32) ([]*Tag, error) {
var tags []*Tag
db = db.Where("state = ? AND is_del = ?", t.State, 0)
err := db.Where("id IN (?)", ids).Find(&tags).Error
if err != nil && err != gorm.ErrRecordNotFound {
return nil, err
}
return tags, nil
}
func (t Tag) Get(db *gorm.DB) (Tag, error) {
var tag Tag
err := db.Where("id = ? AND is_del = ? AND state = ?", t.ID, 0, t.State).First(&tag).Error
if err != nil && err != gorm.ErrRecordNotFound {
return tag, err
}
return tag, nil
}
func (t Tag) Create(db *gorm.DB) error {
return db.Create(&t).Error
}
func (t Tag) Update(db *gorm.DB, values interface{}) error {
return db.Model(&t).Where("id = ? AND is_del = ?", t.ID, 0).Updates(values).Error
}
func (t Tag) Delete(db *gorm.DB) error {
return db.Where("id = ? AND is_del = ?", t.Model.ID, 0).Delete(&t).Error
}