/
resources.go
55 lines (47 loc) · 1.39 KB
/
resources.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
package database
import (
"github.com/dmnyu/go-medialog/models"
"github.com/dmnyu/go-medialog/shared"
)
func FindResources() ([]models.Resource, error) {
resources := []models.Resource{}
if err := db.Find(&resources).Error; err != nil {
return []models.Resource{}, err
}
return resources, nil
}
func FindResourcesByRepoID(id int, pagination shared.Pagination) ([]models.Resource, error) {
resources := []models.Resource{}
offset := (pagination.Page - 1) * pagination.Limit
queryBuider := db.Limit(pagination.Limit).Offset(offset).Order(pagination.Sort)
err := queryBuider.Where("repository_id = ?", id).Find(&resources).Error
return resources, err
}
func FindResource(id int) (models.Resource, error) {
resource := models.Resource{}
if err := db.Find(&resource, "id = ?", id).Error; err != nil {
return resource, err
}
return resource, nil
}
func InsertResource(resource models.Resource) (int, error) {
if err := db.Create(&resource).Error; err != nil {
return 0, err
}
return int(resource.ID), nil
}
func DeleteResource(resource *models.Resource) error {
if err := db.Delete(resource).Error; err != nil {
return err
}
return nil
}
func GetResourceIdentifiers() *map[int]string {
resources := []models.Resource{}
db.Find(&resources)
var resourceMap = map[int]string{}
for _, resource := range resources {
resourceMap[int(resource.ID)] = resource.Identifiers
}
return &resourceMap
}