forked from mconintet/KiwiChat-Server
/
getBuddies.go
81 lines (67 loc) · 1.64 KB
/
getBuddies.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
package main
import (
"database/sql"
"github.com/bitly/go-simplejson"
_ "github.com/go-sql-driver/mysql"
"github.com/mconintet/kiwi"
)
func handGetBuddies(j *simplejson.Json, s kiwi.MessageSender, m *kiwi.Message) error {
uid, err := j.Get("uid").Int64()
if err != nil {
return ErrDeformedRequest
}
token, err := j.Get("token").String()
if err != nil {
return ErrDeformedRequest
}
db, err := sql.Open("mysql", dbConnInfo)
if err != nil {
return err
}
defer db.Close()
// valid user and his token
tokenIsValid, err := checkToken(uid, token)
if err != nil {
return err
}
if !tokenIsValid {
sendNeedsLogin("get-buddies-return", s)
return nil
}
// get buddies
stmtOut, err := db.Prepare(`SELECT U.id, U.nickname, U.network, U.avatar
FROM user AS U JOIN user_buddy as B ON U.id=B.buddy WHERE B.user=?`)
if err != nil {
return err
}
defer stmtOut.Close()
rows, err := stmtOut.Query(uid)
if err != nil {
return err
}
buddies := []*simplejson.Json{}
for rows.Next() {
var uid int
var nickname sql.NullString
var network sql.NullInt64
var avatar sql.RawBytes
err = rows.Scan(&uid, &nickname, &network, &avatar)
if err != nil {
return err
}
buddy := simplejson.New()
buddy.Set("uid", uid)
buddy.Set("nickname", nickname.String)
buddy.Set("network", network.Int64)
buddy.Set("avatar", encodeAvatar(avatar))
buddies = append(buddies, buddy)
}
retMsg := simplejson.New()
retMsg.Set("action", "get-buddies-return")
retMsg.Set("buddies", buddies)
retMsg.Set("errCode", ErrNone)
retMsg.Set("errMsg", ErrCodeMsg[ErrNone])
byts, _ := retMsg.MarshalJSON()
s.SendWholeBytes(byts, false)
return nil
}