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
|
package mysql
import (
"database/sql"
"fmt"
_ "github.com/go-sql-driver/mysql"
"github.com/silvasur/mailremind/model"
"strconv"
)
type scanner interface {
Scan(dest ...interface{}) error
}
type DBID uint64
func (id DBID) String() string {
return strconv.FormatUint(uint64(id), 16)
}
func parseDBID(s string) (model.DBID, error) {
_id, err := strconv.ParseUint(s, 16, 64)
return DBID(_id), err
}
type MySQLDBCon struct {
con *sql.DB
stmt []*sql.Stmt
}
func connect(dbconf string) (model.DBCon, error) {
con, err := sql.Open("mysql", dbconf)
if err != nil {
return nil, err
}
dbc := &MySQLDBCon{
con: con,
stmt: make([]*sql.Stmt, qEnd),
}
for i := 0; i < qEnd; i++ {
stmt, err := con.Prepare(queries[i])
if err != nil {
con.Close()
return nil, fmt.Errorf("Failed to prepare statement %d : <%s>: %s", i, queries[i], err)
}
dbc.stmt[i] = stmt
}
return dbc, nil
}
func init() {
model.Register("mysql", model.DBInfo{
Connect: connect,
ParseDBID: parseDBID,
})
}
func (con *MySQLDBCon) Close() {
con.con.Close()
}
func rollbackAfterFail(err error, tx *sql.Tx) error {
if rberr := tx.Rollback(); rberr != nil {
return fmt.Errorf("Rollback error: <%s>, Original error: %s", rberr, err)
}
return err
}
func i2b(i int) bool {
if i == 0 {
return false
}
return true
}
func b2i(b bool) int {
if b {
return 1
}
return 0
}
|
