-
Notifications
You must be signed in to change notification settings - Fork 0
/
db.go
141 lines (121 loc) · 2.64 KB
/
db.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
128
129
130
131
132
133
134
135
136
137
138
139
140
141
package db
import (
"context"
"github.com/allanwei/gcwebapis-config"
//Add mssql driver
"database/sql"
//Add mssql driver
_ "github.com/denisenkom/go-mssqldb"
//Add mssql driver
//_ "github.com/jinzhu/gorm/dialects/mssql"
)
//DBcon ... Project DB type
type DBcon struct {
DB *sql.DB
Ctx context.Context
Qstmt *sql.Stmt
cancel context.CancelFunc
}
//ExecuteResult ...
type ExecuteResult struct {
LastInsertId int64 `json:"last_insert_id,omitempty"`
RowsAffected int64 `json:"rows_affected,omitempty"`
}
//ExecuteQuery ...
func (c *DBcon) ExecuteQuery(sqlquery string) (*ExecuteResult, error) {
err := c.DB.PingContext(c.Ctx)
if err != nil {
return nil, err
}
c.Qstmt, err = c.DB.PrepareContext(c.Ctx, sqlquery)
if err != nil {
return nil, err
}
defer c.Qstmt.Close()
r, err := c.Qstmt.ExecContext(c.Ctx)
if err != nil {
return nil, err
}
iid, err := r.LastInsertId()
if err != nil {
iid = 0
}
rc, err := r.RowsAffected()
if err != nil {
rc = 0
}
return &ExecuteResult{LastInsertId: iid, RowsAffected: rc}, nil
}
//GetResultRow ...
func (c *DBcon) GetResultRow(sqlquery string) (*sql.Row, error) {
//defer c.DB.Close()
err := c.DB.PingContext(c.Ctx)
if err != nil {
return nil, err
}
c.Qstmt, err = c.DB.PrepareContext(c.Ctx, sqlquery)
if err != nil {
return nil, err
}
defer c.Qstmt.Close()
row := c.Qstmt.QueryRowContext(c.Ctx)
return row, nil
}
//GetResultRows ...
func (c *DBcon) GetResultRows(sqlquery string) (*sql.Rows, error) {
//defer c.DB.Close()
err := c.DB.PingContext(c.Ctx)
if err != nil {
return nil, err
}
c.Qstmt, err = c.DB.PrepareContext(c.Ctx, sqlquery)
if err != nil {
return nil, err
}
defer c.Qstmt.Close()
rows, err := c.Qstmt.QueryContext(c.Ctx)
if err != nil {
return nil, err
}
return rows, nil
}
//Close ... Close dbConntions
func (c *DBcon) Close() {
c.Qstmt.Close()
c.DB.Close()
c.cancel()
}
//CreateDBCon ... Create Project DB Connection
func CreateDBCon(dbconnectionstring *string) (*DBcon, error) {
var cs string
var err error
if dbconnectionstring != nil {
cs = *dbconnectionstring
} else {
cs, err = config.GetDatabaseConf()
if err != nil {
return nil, err
}
}
db, err := sql.Open("mssql", cs)
if err != nil {
return nil, err
}
//Set db MaxIdleConns
//db.SetMaxIdleConns(10)
//Set db MaxOpenConns
//db.SetMaxOpenConns(100)
//defer db.Close()
// make sure connection is available
//ctx := context.Background()
//err = db.Ping(Context(ctx))
err = db.Ping()
if err != nil {
return nil, err
}
c := DBcon{}
c.DB = db
c.Ctx, c.cancel = context.WithCancel(context.Background())
//c := DBcon{DB: db, Ctx: context.TODO()}
return &c, nil
}