-
Notifications
You must be signed in to change notification settings - Fork 0
/
stmt.go
89 lines (71 loc) · 2.03 KB
/
stmt.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
package zeroxorm
import (
"database/sql"
"github.com/tal-tech/go-zero/core/logx"
"github.com/tal-tech/go-zero/core/stores/sqlx"
"github.com/tal-tech/go-zero/core/timex"
"github.com/xormplus/xorm"
)
type zeroStmt struct {
session *xorm.Session
query string
}
func newStmtSession(conn *xorm.Engine, query string) sqlx.StmtSession {
sess := conn.NewSession()
sess = sess.Prepare()
return &zeroStmt{sess, query}
}
func (s *zeroStmt) Close() error {
return s.session.Close()
}
func (s *zeroStmt) Exec(args ...interface{}) (sql.Result, error) {
return exec(s.session, s.query, args...)
}
func (s *zeroStmt) QueryRow(v interface{}, args ...interface{}) error {
return query(s.session, v, s.query, args...)
}
func (s *zeroStmt) QueryRowPartial(v interface{}, args ...interface{}) error {
return s.QueryRow(v, args...)
}
func (s *zeroStmt) QueryRows(v interface{}, args ...interface{}) error {
return s.QueryRow(v, args...)
}
func (s *zeroStmt) QueryRowsPartial(v interface{}, args ...interface{}) error {
return s.QueryRows(v, args...)
}
func exec(session *xorm.Session, query string, args ...interface{}) (sql.Result, error) {
stmt, err := format(query, args...)
if err != nil {
return nil, err
}
startTime := timex.Now()
result, err := session.Exec(query, args)
duration := timex.Since(startTime)
if duration > slowThreshold {
logx.WithDuration(duration).Slowf("[SQL] exec: slowcall - %s", stmt)
} else {
logx.WithDuration(duration).Infof("sql exec: %s", stmt)
}
if err != nil {
logSqlError(stmt, err)
}
return result, err
}
func query(session *xorm.Session, v interface{}, query string, args ...interface{}) error {
stmt, err := format(query, args...)
if err != nil {
return err
}
startTime := timex.Now()
err = session.SQL(query, args...).Find(v)
duration := timex.Since(startTime)
if duration > slowThreshold {
logx.WithDuration(duration).Slowf("[SQL] exec: slowcall - %s", stmt)
} else {
logx.WithDuration(duration).Infof("sql exec: %s", stmt)
}
if err != nil {
logSqlError(stmt, err)
}
return err
}