/
emailStore.go
63 lines (45 loc) · 1.5 KB
/
emailStore.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
package storage
import (
_ "embed"
"github.com/google/uuid"
"github.com/cmsgov/mint-app/pkg/email"
)
//go:embed SQL/email/solution_selected_details_get.sql
var solutionSelectedDetailsGet string
//go:embed SQL/email/discussion_reply_to_originator_details_get.sql
var discussionReplyToOriginatorDetailsGet string
// GetSolutionSelectedDetails queries the database to return information that is useful
func (s *Store) GetSolutionSelectedDetails(solutionID uuid.UUID) (*email.SolutionSelectedDB, error) {
stmt, err := s.db.PrepareNamed(solutionSelectedDetailsGet)
if err != nil {
return nil, err
}
defer stmt.Close()
arg := map[string]interface{}{
"sol_id": solutionID,
}
solDetails := email.SolutionSelectedDB{}
err = stmt.Get(&solDetails, arg)
if err != nil {
return nil, err
}
return &solDetails, nil
}
// GetDiscussionReplyDetailsForEmail returns Discussion replies along with user account information for each reply.
// It is sorted by the database with the newest replies going to oldest replies.
func (s *Store) GetDiscussionReplyDetailsForEmail(discussionID uuid.UUID) ([]*email.DiscussionReplyEmailContentDB, error) {
var discRSlice []*email.DiscussionReplyEmailContentDB
stmt, err := s.db.PrepareNamed(discussionReplyToOriginatorDetailsGet)
if err != nil {
return nil, err
}
defer stmt.Close()
arg := map[string]interface{}{
"disc_id": discussionID,
}
err = stmt.Select(&discRSlice, arg) // This returns more than one
if err != nil {
return nil, err
}
return discRSlice, nil
}