-
Notifications
You must be signed in to change notification settings - Fork 0
/
db.go
99 lines (84 loc) · 1.66 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
package db
import (
"errors"
"strings"
"time"
_ "github.com/go-sql-driver/mysql"
"github.com/jmoiron/sqlx"
_ "github.com/lib/pq"
)
const (
postgresProto = "postgres"
mySQLProto = "mysql"
MaxMySQLPlaceholders = 65535
)
type Storer interface {
Type() string
InnerDB() *sqlx.DB
Close() error
}
type database struct {
*sqlx.DB
statsPollerCloseChan chan struct{}
dbType string
}
func SetupRDBMS(dsn string) (_ Storer, err error) {
var (
db *sqlx.DB
)
splitted := strings.Split(dsn, "://")
if len(splitted) < 2 {
return &database{}, errors.New("can't parse DSN")
}
proto := splitted[0]
source := splitted[1]
switch proto {
case mySQLProto:
db, err = sqlx.Connect(mySQLProto, source)
case postgresProto:
db, err = sqlx.Connect(postgresProto, dsn)
if err != nil {
err = errors.New(strings.Replace(err.Error(), dsn, "DSN", -1))
}
default:
return &database{}, errors.New("unknown database protocol")
}
if err != nil {
return &database{}, err
}
db.SetMaxOpenConns(200)
db.SetMaxIdleConns(25)
db.SetConnMaxIdleTime(time.Hour)
db.SetConnMaxLifetime(time.Hour)
if err = db.Ping(); err != nil {
return nil, err
}
statsPollerCloseChan := make(chan struct{})
return &database{
DB: db,
dbType: proto,
statsPollerCloseChan: statsPollerCloseChan,
}, nil
}
func (d *database) Type() string {
if d == nil {
return ""
}
return d.dbType
}
func (d *database) InnerDB() *sqlx.DB {
if d == nil {
return nil
}
return d.DB
}
func (d *database) Close() error {
if d == nil {
return nil
}
if d.DB == nil {
return nil
}
close(d.statsPollerCloseChan)
return d.DB.Close()
}