/
initializer.go
52 lines (46 loc) · 1.12 KB
/
initializer.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
package db
import (
_ "github.com/go-sql-driver/mysql"
"github.com/hetianyi/gox/logger"
"github.com/jinzhu/gorm"
"time"
)
var (
_driverName string
_args []interface{}
managedDB *gorm.DB
)
// InitConnection initializes db connection.
func InitConnection(dialect string, args ...interface{}) error {
_driverName = dialect
_args = args
db, err := gorm.Open(dialect, args...)
if err != nil {
return err
}
if err = db.DB().Ping(); err != nil {
return err
}
managedDB = db
managedDB.LogMode(logger.GetLogLevel() > logger.DebugLevel)
managedDB.SetLogger()
return nil
}
// SetConfig sets configuration of connection pool.
func SetConfig(maxIdleConns int, maxOpenConns int, connMaxLifetime time.Duration) {
managedDB.DB().SetMaxIdleConns(maxIdleConns)
managedDB.DB().SetMaxOpenConns(maxOpenConns)
managedDB.DB().SetConnMaxLifetime(connMaxLifetime)
}
// GetDB returns *gorm.DB for db operation.
func GetDB() *gorm.DB {
return managedDB
}
// Reconnect tries to reconnect to db.
func Reconnect() error {
if managedDB != nil {
managedDB.DB().Close()
}
managedDB = nil
return InitConnection(_driverName, _args...)
}