-
Notifications
You must be signed in to change notification settings - Fork 0
/
setEvents.go
220 lines (178 loc) · 5.58 KB
/
setEvents.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
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
package main
import (
"encoding/json"
"errors"
"fmt"
"io"
"log"
"net/http"
"strconv"
"strings"
"time"
"github.com/gorilla/mux"
)
var ErrClash error = fmt.Errorf("clashing events")
var ErrPermission error = fmt.Errorf("permission denied")
// EventCreator expans an Event to include the ability to not attach the user's
// name to the event during creation
type EventCreator struct {
Event
NoNameAttached bool `json:"noNameAttached"`
}
// EventCreatorFromAPI also includes a Repeat field, to create several of the same
// event, repeating weekly
type EventCreatorFromAPI struct {
EventCreator
Repeat int `json:"repeat"`
}
// addEvent will add an EventCreator to the DB, having checked it for clashes and permissions
func addEvent(event EventCreator) error {
// Check the user can make this type of event
allowed := false
if event.Type == TypeTrainingAutoAddedFromMyRadio {
allowed = true
} else {
for _, v := range bookingsUserCanCreate(event.User) {
if v == event.Type {
allowed = true
break
}
}
}
if !allowed {
return ErrPermission
}
// Find clashes
rows, err := db.Query(
"SELECT * FROM events WHERE (start_time >= $1 AND start_time < $2) OR (end_time > $1 AND end_time <= $2) OR (start_time < $1 AND end_time > $2)",
event.StartTime, event.EndTime)
if err != nil {
return err
}
defer rows.Close()
if rows.Next() {
return ErrClash
}
// Create the name of the booking
if !event.NoNameAttached {
if event.Title == "" {
event.Title = fmt.Sprintf("%s - %s", event.Type, getNameOfUser(event.User))
} else {
event.Title = fmt.Sprintf("%s - %s", event.Title, getNameOfUser(event.User))
}
}
creatingUser := getNameOfUser(event.User)
// deal with bookings from the MyRadio sync, rather than user requests
if event.Type == TypeTrainingAutoAddedFromMyRadio {
event.Type = TypeTraining
creatingUser = "MyRadio Auto-Sync"
event.Title = fmt.Sprintf("Training - %s 📻", getNameOfUser(event.User)) // add a radio emoji for things that are added because they're on myradio
}
// Insert the event into the database
err = db.QueryRow(
"INSERT INTO events(event_type, event_title, user_id, start_time, end_time) VALUES($1, $2, $3, $4, $5) RETURNING event_id",
string(event.Type), event.Title, event.User, event.StartTime, event.EndTime).Scan(&event.ID)
encodedEventsCache = ""
log.Printf("%s created %s at %v (ID %v)\n", creatingUser, event.Title, event.StartTime, event.ID)
return err
}
// createEventHandler will let us create bookings from the API (including
// repeating bookings)
func createEventHandler(w http.ResponseWriter, r *http.Request) {
// Parse the request body and create a new event
// Parse event data from the request body
defer r.Body.Close()
body, err := io.ReadAll(r.Body)
if err != nil {
panic(err)
// TODO
}
var event EventCreatorFromAPI
json.Unmarshal(body, &event)
var ok bool
event.User, ok = r.Context().Value(UserCtxKey).(int)
if !ok {
// TODO
panic("TODO")
}
event.parseTimes()
if event.Type == TypeTrainingAutoAddedFromMyRadio {
// this type is only for the automatic adding, not for users
http.Error(w, "wrong training type", http.StatusBadRequest)
return
}
if event.Repeat < 1 {
// this event won't happen, so can't be created
http.Error(w, "invalid number of repetitions", http.StatusBadRequest)
return
}
// deal with repeating events, and add events
// NOTE: events should "repeat" at least once (as in, they happen once)
firstStartTime := event.StartTime
firstEndTime := event.EndTime
for i := 0; i < event.Repeat; i++ {
event.StartTime = firstStartTime.Add(time.Duration(i*24*7) * time.Hour)
event.EndTime = firstEndTime.Add(time.Duration(i*24*7) * time.Hour)
err = addEvent(event.EventCreator)
if err != nil {
if errors.Is(err, ErrClash) {
w.WriteHeader(http.StatusBadRequest)
fmt.Fprint(w, err)
return
}
w.WriteHeader(http.StatusInternalServerError)
fmt.Fprint(w, err)
return
}
}
w.Header().Add("Content-Type", "application/json")
w.WriteHeader(http.StatusCreated)
w.Write([]byte("{\"status\": \"OK\"}"))
}
// deleteEventHandler deals with removing bookings, once dealt with permissions
func deleteEventHandler(w http.ResponseWriter, r *http.Request) {
vars := mux.Vars(r)
eventID := vars["id"]
id, err := strconv.Atoi(eventID)
if err != nil {
// TODO
panic(err)
}
if !hasPermissionToDelete(r.Context().Value(UserCtxKey).(int), id) {
// TODO
panic("TODO")
}
_, err = db.Exec("DELETE FROM events WHERE event_id=$1", id)
encodedEventsCache = ""
if err != nil {
w.WriteHeader(http.StatusInternalServerError)
return
}
log.Printf("%s deleted event %v", getNameOfUser(r.Context().Value(UserCtxKey).(int)), id)
w.WriteHeader(http.StatusNoContent)
}
// claimEventsForStationHandler allows events to have the user's personal name
// removed, so it isn't associated with a single person, instead, the station as
// a whole
func claimEventForStationHandler(w http.ResponseWriter, r *http.Request) {
vars := mux.Vars(r)
eventID := vars["id"]
id, err := strconv.Atoi(eventID)
if err != nil {
// TODO
panic(err)
}
if !canClaimEventForStation(r.Context().Value(UserCtxKey).(int), id) {
panic("TODO")
}
var event Event
db.QueryRow("SELECT * FROM events WHERE event_id = $1", eventID).Scan(
&event.ID, &event.Type, &event.Title, &event.User, &event.StartTime, &event.EndTime)
newTitle, _, _ := strings.Cut(event.Title, fmt.Sprintf("- %s", getNameOfUser(event.User)))
_, err = db.Exec("UPDATE events SET event_title = $1 WHERE event_id = $2", newTitle, id)
if err != nil {
panic(err)
}
encodedEventsCache = ""
w.WriteHeader(http.StatusNoContent)
}