-
Notifications
You must be signed in to change notification settings - Fork 1
/
response.go
58 lines (53 loc) · 1.56 KB
/
response.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
package store
import (
"database/sql"
"time"
)
// A Response is an outgoing message that responds to a received message.
type Response struct {
LocalID string `yaml:"localID"`
ResponseTo string `yaml:"responseTo"`
To string `yaml:"to"`
Subject string `yaml:"subject"`
Body string `yaml:"body"`
SendTime time.Time `yaml:"sendTime"`
SenderCall string `yaml:"senderCall"`
SenderBBS string `yaml:"senderBBS"`
}
// GetResponses retrieves the responses for the specified message.
func (st *Store) GetResponses(to string) (responses []*Response) {
var (
rows *sql.Rows
err error
)
st.mutex.RLock()
defer st.mutex.RUnlock()
rows, err = st.dbh.Query(`SELECT id, sendto, subject, body, sendtime, sendercall, senderbbs FROM response WHERE responseto=? ORDER BY id`, to)
if err != nil {
panic(err)
}
for rows.Next() {
var r Response
err = rows.Scan(&r.LocalID, &r.To, &r.Subject, &r.Body, &r.SendTime, &r.SenderCall, &r.SenderBBS)
if err != nil {
panic(err)
}
r.ResponseTo = to
responses = append(responses, &r)
}
if err = rows.Err(); err != nil {
panic(err)
}
return responses
}
// SaveResponse saves an outgoing response to the database.
func (st *Store) SaveResponse(r *Response) {
var err error
st.mutex.Lock()
defer st.mutex.Unlock()
_, err = st.dbh.Exec("INSERT INTO response (id, responseto, sendto, subject, body, sendtime, sendercall, senderbbs) VALUES (?,?,?,?,?,?,?,?)",
r.LocalID, r.ResponseTo, r.To, r.Subject, r.Body, r.SendTime, r.SenderCall, r.SenderBBS)
if err != nil {
panic(err)
}
}