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
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
|
package repositories
import (
"errors"
"metachan/entities"
"metachan/utils/logger"
"gorm.io/gorm/clause"
)
func CreateOrUpdateSimpleImage(image *entities.SimpleImage) (uint, error) {
result := DB.Clauses(clause.OnConflict{
Columns: []clause.Column{{Name: "image_url"}},
DoUpdates: clause.AssignmentColumns([]string{"image_url"}),
}).Create(image)
if result.Error != nil {
logger.Errorf("Meta", "Failed to create or update image: %v", result.Error)
return 0, errors.New("failed to create or update image")
}
return image.ID, nil
}
func BatchCreateSimpleImages(images []entities.SimpleImage) error {
if len(images) == 0 {
return nil
}
result := DB.Clauses(clause.OnConflict{
Columns: []clause.Column{{Name: "image_url"}},
DoNothing: true,
}).CreateInBatches(&images, 100)
if result.Error != nil {
logger.Errorf("Meta", "Failed to batch create images: %v", result.Error)
return errors.New("failed to batch create images")
}
return nil
}
func BatchCreateSimpleTitles(titles []entities.SimpleTitle) error {
if len(titles) == 0 {
return nil
}
result := DB.Clauses(clause.OnConflict{
Columns: []clause.Column{{Name: "type"}, {Name: "title"}},
DoNothing: true,
}).CreateInBatches(&titles, 100)
if result.Error != nil {
logger.Errorf("Meta", "Failed to batch create titles: %v", result.Error)
return errors.New("failed to batch create titles")
}
return nil
}
func CreateOrUpdateSimpleTitle(title *entities.SimpleTitle) (uint, error) {
result := DB.Clauses(clause.OnConflict{
Columns: []clause.Column{{Name: "type"}, {Name: "title"}},
DoUpdates: clause.AssignmentColumns([]string{"type", "title"}),
}).Create(title)
if result.Error != nil {
logger.Errorf("Meta", "Failed to create or update title: %v", result.Error)
return 0, errors.New("failed to create or update title")
}
return title.ID, nil
}
func GetAllImagesMapped() (map[string]uint, error) {
var images []entities.SimpleImage
if err := DB.Select("id, image_url").Find(&images).Error; err != nil {
return nil, err
}
m := make(map[string]uint, len(images))
for _, img := range images {
m[img.ImageURL] = img.ID
}
return m, nil
}
func GetAllTitlesMapped() (map[string]uint, error) {
var titles []entities.SimpleTitle
if err := DB.Select("id, type, title").Find(&titles).Error; err != nil {
return nil, err
}
m := make(map[string]uint, len(titles))
for _, t := range titles {
m[t.Type+":"+t.Title] = t.ID
}
return m, nil
}
func CreateOrUpdateExternalURL(url *entities.ExternalURL) (uint, error) {
result := DB.Clauses(clause.OnConflict{
Columns: []clause.Column{{Name: "name"}, {Name: "url"}},
DoUpdates: clause.AssignmentColumns([]string{"name", "url"}),
}).Create(url)
if result.Error != nil {
logger.Errorf("Meta", "Failed to create or update external URL: %v", result.Error)
return 0, errors.New("failed to create or update external URL")
}
return url.ID, nil
}
|
