-
Notifications
You must be signed in to change notification settings - Fork 0
/
zeroxorm.go
127 lines (101 loc) · 2.88 KB
/
zeroxorm.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
124
125
126
127
package zeroxorm
import (
"database/sql"
"time"
"github.com/tal-tech/go-zero/core/breaker"
"github.com/tal-tech/go-zero/core/stores/sqlx"
"github.com/xormplus/xorm"
)
type (
zeroxormConn struct {
driverName string
dataSource string
beginTx beginnable
brk breaker.Breaker
accept func(error) bool
}
ZeroxormOption func(*zeroxormConn)
)
const slowThreshold = time.Millisecond * 500
func NewZeroxormConn(driverName, dataSource string, opts ...ZeroxormOption) sqlx.SqlConn {
conn := &zeroxormConn{
driverName: driverName,
dataSource: dataSource,
beginTx: begin,
brk: breaker.NewBreaker(),
}
for _, opt := range opts {
opt(conn)
}
return conn
}
func (db *zeroxormConn) Exec(query string, args ...interface{}) (result sql.Result, err error) {
err = db.brk.DoWithAcceptable(func() error {
var conn *xorm.Engine
conn, err = getSqlConn(db.driverName, db.dataSource)
if err != nil {
logInstanceError(db.dataSource, err)
return err
}
sess := conn.Prepare()
result, err = exec(sess, query, args...)
return err
}, db.acceptable)
return
}
func (db *zeroxormConn) Prepare(query string) (stmt sqlx.StmtSession, err error) {
err = db.brk.DoWithAcceptable(func() error {
var conn *xorm.Engine
conn, err = getSqlConn(db.driverName, db.dataSource)
if err != nil {
logInstanceError(db.dataSource, err)
return err
}
stmt = newStmtSession(conn, query)
return nil
}, db.acceptable)
return
}
func (db *zeroxormConn) QueryRow(v interface{}, query string, args ...interface{}) error {
return db.queryRows(v, query, args...)
}
func (db *zeroxormConn) QueryRowPartial(v interface{}, query string, args ...interface{}) error {
return db.queryRows(v, query, args...)
}
func (db *zeroxormConn) QueryRows(v interface{}, query string, args ...interface{}) error {
return db.queryRows(v, query, args...)
}
func (db *zeroxormConn) QueryRowsPartial(v interface{}, query string, args ...interface{}) error {
return db.queryRows(v, query, args...)
}
func (db *zeroxormConn) Transact(fn func(session sqlx.Session) error) error {
return db.brk.DoWithAcceptable(func() error {
conn, err := getSqlConn(db.driverName, db.dataSource)
if err != nil {
logInstanceError(db.dataSource, err)
return err
}
return transactOnConn(conn, db.beginTx, fn)
}, db.acceptable)
}
func (db *zeroxormConn) acceptable(err error) bool {
ok := err == nil || err == sql.ErrNoRows || err == sql.ErrTxDone
if db.accept == nil {
return ok
} else {
return ok || db.accept(err)
}
}
func (db *zeroxormConn) queryRows(v interface{}, q string, args ...interface{}) error {
return db.brk.DoWithAcceptable(func() error {
conn, err := getSqlConn(db.driverName, db.dataSource)
if err != nil {
logInstanceError(db.dataSource, err)
return err
}
sess := conn.Prepare()
return query(sess, v, q, args...)
}, func(err error) bool {
return db.acceptable(err)
})
}