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
|
/*
* Course data structures and locking
*
* Copyright (C) 2024 Runxi Yu <https://runxiyu.org>
* SPDX-License-Identifier: BSD-2-Clause
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are
* met:
*
* 1. Redistributions of source code must retain the above copyright
* notice, this list of conditions and the following disclaimer.
*
* 2. Redistributions in binary form must reproduce the above copyright
* notice, this list of conditions and the following disclaimer in the
* documentation and/or other materials provided with the distribution.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS "AS IS" AND ANY
* EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR
* CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
* PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
* LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
* NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
package main
import (
"context"
"fmt"
"sync"
)
type coursetypeT string
type courseT struct {
ID int
Selected int
SelectedLock sync.RWMutex
Max int
Title string
Type coursetypeT
Teacher string
Location string
}
/*
* const (
* sport coursetypeT = "Sport"
* enrichment coursetypeT = "Enrichment"
* culture coursetypeT = "Culture"
* )
*/
/*
* The courses are simply stored in a map indexed by the course ID, although
* the course struct itself also contains an ID field. A lock is embedded
* inside the struct; we use a lock here instead of a pointer to a lock as
* it would be easy to forget to initialize the lock when creating the
* struct. However, this means that the struct could not be copied (though
* this should only ever happen during creation anyways), therefore we use a
* pointer to the struct as the value of the map, instead of the struct itself.
*/
var courses map[int](*courseT)
/*
* This RWMutex is only for massive modifications of the course struct, since
* locking it on every write would be inefficient; in normal operation the only
* write that could occur to the courses struct is changing the Selected
* number, which should be handled with courseT.SelectedLock.
*/
var coursesLock sync.RWMutex
/*
* Read course information from the database. This should be called during
* setup. Failure to do so before accessing course information may lead to
* a null pointer dereference.
*/
func setupCourses() error {
coursesLock.Lock()
defer coursesLock.Unlock()
courses = make(map[int](*courseT))
rows, err := db.Query(
context.Background(),
"SELECT id, nmax, title, ctype, teacher, location FROM courses",
)
if err != nil {
return fmt.Errorf("error fetching courses: %w", err)
}
for {
if !rows.Next() {
err := rows.Err()
if err != nil {
return fmt.Errorf("error fetching courses: %w", err)
}
break
}
currentCourse := courseT{} //exhaustruct:ignore
err = rows.Scan(
¤tCourse.ID,
¤tCourse.Max,
¤tCourse.Title,
¤tCourse.Type,
¤tCourse.Teacher,
¤tCourse.Location,
)
if err != nil {
return fmt.Errorf("error fetching courses: %w", err)
}
courses[currentCourse.ID] = ¤tCourse
}
/* TODO: Populate currentCourse.Selected from the database */
return nil
}
|