/
club_poc.go
95 lines (78 loc) · 2.97 KB
/
club_poc.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
85
86
87
88
89
90
91
92
93
94
95
package transactions
import (
stdliberrors "errors"
"github.com/GenerateNU/sac/backend/src/errors"
"github.com/GenerateNU/sac/backend/src/models"
"github.com/google/uuid"
"gorm.io/gorm"
)
func GetClubPointOfContacts(db *gorm.DB, clubID uuid.UUID) ([]models.PointOfContact, *errors.Error) {
var pointOfContacts []models.PointOfContact
result := db.Preload("PhotoFile").Where("club_id = ?", clubID).Find(&pointOfContacts)
if result.Error != nil {
if stdliberrors.Is(result.Error, gorm.ErrRecordNotFound) {
return nil, &errors.PointOfContactsNotFound
} else {
return nil, &errors.FailedToGetClubPointOfContacts
}
}
return pointOfContacts, nil
}
func GetClubPointOfContact(db *gorm.DB, clubID uuid.UUID, pocID uuid.UUID) (*models.PointOfContact, *errors.Error) {
var pointOfContact models.PointOfContact
if err := db.Preload("PhotoFile").First(&pointOfContact, "id = ? AND club_id = ?", pocID, clubID).Error; err != nil {
if stdliberrors.Is(err, gorm.ErrRecordNotFound) {
return nil, &errors.PointOfContactNotFound
} else {
return nil, &errors.FailedToGetClubPointOfContact
}
}
return &pointOfContact, nil
}
func GetClubPointOfContactByClubIDAndEmail(db *gorm.DB, clubID uuid.UUID, email string) (*models.PointOfContact, *errors.Error) {
var pointOfContact models.PointOfContact
if err := db.First(&pointOfContact, "email = ? AND club_id = ?", email, clubID).Error; err != nil {
if stdliberrors.Is(err, gorm.ErrRecordNotFound) {
return nil, &errors.PointOfContactNotFound
} else {
return nil, &errors.FailedToGetClubPointOfContact
}
}
return &pointOfContact, nil
}
func CreateClubPointOfContact(db *gorm.DB, clubID uuid.UUID, pointOfContactBody models.CreatePointOfContactBody) (*models.PointOfContact, *errors.Error) {
pointOfContact := models.PointOfContact{
Name: pointOfContactBody.Name,
Email: pointOfContactBody.Email,
Position: pointOfContactBody.Position,
ClubID: clubID,
}
if err := db.Create(&pointOfContact).Error; err != nil {
return nil, &errors.FailedToCreatePointOfContact
}
return &pointOfContact, nil
}
func UpdateClubPointOfContact(db *gorm.DB, clubID uuid.UUID, pocID uuid.UUID, pointOfContactBody models.UpdatePointOfContactBody) (*models.PointOfContact, *errors.Error) {
pointOfContact, err := GetClubPointOfContact(db, clubID, pocID)
if err != nil {
return nil, err
}
if err := db.Model(&pointOfContact).Updates(models.PointOfContact{
Name: pointOfContactBody.Name,
Email: pointOfContactBody.Email,
Position: pointOfContactBody.Position,
}).Error; err != nil {
return nil, &errors.FailedToUpdateClubPointOfContact
}
return pointOfContact, nil
}
func DeleteClubPointOfContact(db *gorm.DB, clubID uuid.UUID, pocID uuid.UUID) *errors.Error {
if result := db.Delete(&models.PointOfContact{}, "id = ? AND club_id = ?", pocID, clubID); result.RowsAffected == 0 {
if result.Error == nil {
return &errors.PointOfContactNotFound
} else {
return &errors.FailedToDeleteClubPointOfContact
}
}
return nil
}