Newer
Older
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
package model
import (
"code.electrolab.fr/it/vote.electrolab.fr/service/db"
"context"
"fmt"
"math/rand"
"time"
)
type Answer struct {
QuestionName string
Name string
Position int
Checked bool
Sentence string
VoteCount int
}
func FetchAnswers(ctx context.Context, db db.Service, questionName string) ([]*Answer, error) {
var result []*Answer
q := `
SELECT
question_name,
name,
position,
checked,
sentence,
vote_count
FROM answers
WHERE question_name = $1
`
rows, err := db.QueryContext(ctx, q, questionName)
if err != nil {
return nil, fmt.Errorf("Error fetching answers: %w", err)
}
defer rows.Close()
for rows.Next() {
answer := new(Answer)
err = rows.Scan(
&answer.QuestionName,
&answer.Name,
&answer.Position,
&answer.Checked,
&answer.Sentence,
&answer.VoteCount,
)
if err != nil {
return nil, fmt.Errorf("Error fetching answers: %w", err)
}
result = append(result, answer)
}
return result, nil
}
// Pseudorandom shuffle to prevent order bias in answers
func ShuffleAnswers(answers []*Answer) {
rnd := rand.New(rand.NewSource(time.Now().UnixNano()))
for i := len(answers) - 1; i > 0; i-- {
j := rnd.Intn(i + 1)
answers[i], answers[j] = answers[j], answers[i]
}
}