-
Notifications
You must be signed in to change notification settings - Fork 0
/
submission.go
128 lines (111 loc) · 3.77 KB
/
submission.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
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
package models
import (
"errors"
"strings"
"github.com/jinzhu/gorm"
"github.com/rank-a-thon/rank-a-thon/api/database"
"github.com/rank-a-thon/rank-a-thon/api/forms"
)
// Submission ...
type Submission struct {
gorm.Model
TeamID uint `gorm:"column:team_id;not null" json:"-"`
ProjectName string `gorm:"column:project_name" json:"project_name"`
Description string `gorm:"column:description" json:"description"`
Images string `gorm:"column:images" json:"images"` // comma separated list of image ids
Team Team `gorm:"column:team" json:"team"`
Likes int `gorm:"column:likes" json:"likes"`
}
// SubmissionModel ...
type SubmissionModel struct{}
// Create ...
func (m SubmissionModel) Create(teamID uint, form forms.SubmissionForm) (submissionID uint, err error) {
submission, err := m.OneByTeamID(teamID)
if err == nil {
return submission.ID, errors.New("team submission already exists")
}
submission = Submission{
TeamID: teamID,
ProjectName: form.ProjectName,
Description: form.Description,
Images: strings.Join(form.Images, ","),
}
err = database.GetDB().Table("public.submissions").Create(&submission).Error
return submission.ID, err
}
// One ...
func (m SubmissionModel) OneByTeamID(teamID uint) (submission Submission, err error) {
err = database.GetDB().Preload("Team").Table("public.submissions").
Where("submissions.team_id = ?", teamID).
Joins("left join public.teams on submissions.team_id = teams.id").
Take(&submission).Error
return submission, err
}
// One ...
func (m SubmissionModel) One(submissionID uint) (submission Submission, err error) {
err = database.GetDB().Preload("Team").Table("public.submissions").
Where("submissions.id = ?", submissionID).
Joins("left join public.teams on submissions.team_id = teams.id").
Take(&submission).Error
return submission, err
}
// All ...
func (m SubmissionModel) AllForUserID(userID uint) (submissions []Submission, err error) {
user, err := userModel.One(userID)
if err != nil {
return nil, err
}
teamIDForEvent := JsonStringToStringUintMap(user.TeamIDForEvent)
for _, teamID := range teamIDForEvent {
submission, err := m.OneByTeamID(teamID)
if err != nil {
return submissions, err
}
submissions = append(submissions, submission)
}
return submissions, err
}
func (m SubmissionModel) AllForEvent(event Event) (submissions []Submission, err error) {
err = database.GetDB().Preload("Team").Table("public.submissions").
Joins("left join public.teams on submissions.team_id = teams.id").
Where("teams.event = ?", event).
Order("submissions.id desc").
Find(&submissions).Error
return submissions, err
}
// Update ...
func (m SubmissionModel) Update(teamID uint, form forms.SubmissionForm) (err error) {
_, err = m.OneByTeamID(teamID)
if err != nil {
return errors.New("submission not found")
}
err = database.GetDB().Table("public.submissions").Model(&Submission{}).
Where("team_id = ?", teamID).
Updates(map[string]interface{}{
"project_name": form.ProjectName,
"description": form.Description,
"images": strings.Join(form.Images, ","),
}).Error
return err
}
func (m SubmissionModel) IncrementLike(submissionID uint, increment int) (err error) {
submission, err := m.One(submissionID)
if err != nil {
return errors.New("submission not found")
}
err = database.GetDB().Table("public.submissions").Model(&Submission{}).
Where("id = ?", submissionID).
Updates(map[string]interface{}{
"likes": submission.Likes + increment,
}).Error
return err
}
// Delete ...
func (m SubmissionModel) Delete(teamID uint) (err error) {
_, err = m.OneByTeamID(teamID)
if err != nil {
return errors.New("submission not found")
}
err = database.GetDB().Table("public.submissions").Where("team_id = ?", teamID).Delete(Submission{}).Error
return err
}