/
storage.go
87 lines (71 loc) · 1.57 KB
/
storage.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
82
83
84
85
86
87
package main
import (
"encoding/json"
_ "github.com/go-sql-driver/mysql"
"github.com/golang/glog"
"github.com/jmoiron/sqlx"
)
func init() {
initMysql()
}
//==== Memory Store
// var keyResultMap map[string]map[string]int
// func initMem() {
// keyResultMap = make(map[string]map[string]int)
// }
// func store(key string, result map[string]int) {
// keyResultMap[key] = result
// }
// func findKey(key string) map[string]int {
// if v, ok := keyResultMap[key]; ok {
// return v
// }
// return nil
// }
// ===== Mysql Store =====
var mysqlDB *sqlx.DB
var mysqlConn = ""
func initMysql() {
if len(mysqlConn) > 0 {
db, err := sqlx.Connect("mysql", mysqlConn)
if err != nil {
panic(err)
}
glog.Infof("connect to mysql success: %s", mysqlConn)
mysqlDB = db
} else {
glog.Infof("mysqlConn is empty")
}
}
func store(key string, result map[string]int) error {
b, err := json.Marshal(result)
if err != nil {
glog.Error(err)
return err
}
resultStr := string(b)
sql := "INSERT INTO resources (`key`, `result`) VALUES (?, ?) ON DUPLICATE KEY UPDATE result = ?"
_, err = mysqlDB.Exec(sql, key, resultStr, resultStr)
if err != nil {
glog.Error(err)
return err
}
return nil
}
func findKey(key string) map[string]int {
var result string
var resultMap map[string]int
sql := "select result from resources where `key` = ? limit 1"
row := mysqlDB.QueryRow(sql, key)
err := row.Scan(&result)
if err != nil {
glog.Error(err)
return nil
}
err = json.Unmarshal([]byte(result), &resultMap)
if err != nil {
glog.Error(err)
return nil
}
return resultMap
}