-
Notifications
You must be signed in to change notification settings - Fork 0
/
mysql.go
123 lines (101 loc) · 2.27 KB
/
mysql.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
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
package session
import (
"database/sql"
"encoding/json"
"github.com/go-sql-driver/mysql"
"log"
"sync"
)
const DefaultMySQLTableName = "session"
type MySQLProvider struct {
*sql.DB
Table string
}
func NewMySQLProvider(db *sql.DB, table string) (*MySQLProvider, error) {
p := &MySQLProvider{
db,
table,
}
if err := p.MySQLSetupCheck(); err != nil {
log.Println(err.Error())
return nil, err
}
return p, nil
}
func (p *MySQLProvider) Read(sid string) (*Session, error) {
var sess Session
var d []byte
q := "SELECT * FROM " + p.Table + " WHERE uuid=?"
row := p.QueryRow(q, sid)
if err := row.Scan(&sess.UUID, &d, &sess.Expire); err != nil {
return nil, err
}
err := json.Unmarshal(d, &sess.Data)
if err != nil {
return nil, err
}
sess.Lock = sync.Mutex{}
return &sess, nil
}
func (p *MySQLProvider) Save(session *Session) error {
q := "INSERT INTO " + p.Table + " SET uuid=?, data=?, expire=? " +
"ON DUPLICATE KEY UPDATE data=?, expire=?"
stmt, err := p.Prepare(q)
if err != nil {
return err
}
data, err := json.Marshal(session.Data)
if err != nil {
return err
}
_, err = stmt.Exec(session.UUID, data, session.Expire, data, session.Expire)
if err != nil {
return err
}
return nil
}
func (p *MySQLProvider) Destroy(sid string) error {
q := "DELETE FROM " + p.Table + " WHERE uuid=?"
stmt, err := p.Prepare(q)
if err != nil {
return err
}
_, err = stmt.Exec(sid)
if err != nil {
return err
}
return nil
}
func (p *MySQLProvider) GarbageCollect() {
q := "DELETE FROM " + p.Table + " WHERE expire < CURRENT_TIMESTAMP"
stmt, err := p.Prepare(q)
if err != nil {
log.Println(err.Error())
return
}
//exp := time.Now()
if _, err = stmt.Exec(); err != nil {
log.Println(err.Error())
}
}
func (p *MySQLProvider) MySQLSetupCheck() error {
q := "DESCRIBE " + p.Table
if _, err := p.Exec(q); err != nil {
if e, ok := err.(*mysql.MySQLError); ok && e.Number == 1146 {
// create the table
q = "CREATE TABLE IF NOT EXISTS " + p.Table + " (" +
"uuid varchar(36) not null," +
"data blob null," +
"expire datetime default CURRENT_TIMESTAMP not null," +
"constraint " + p.Table + "_pk " +
"primary key (uuid))"
_, err := p.Exec(q)
if err != nil {
return err
}
} else {
return err
}
}
return nil
}