/
gorm.go
60 lines (56 loc) · 1.28 KB
/
gorm.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
package gormx
import (
"github.com/go-bamboo/pkg/log"
"gorm.io/driver/mysql"
"gorm.io/driver/postgres"
"gorm.io/driver/sqlite"
"gorm.io/driver/sqlserver"
"gorm.io/gorm"
)
type DB = gorm.DB
func MustNew(c *Conf) *DB {
db, err := New(c)
if err != nil {
log.Fatal(err)
}
return db
}
func New(c *Conf) (*DB, error) {
var dialector gorm.Dialector
if DBType(c.Driver) == DBType_mysql {
dialector = mysql.Open(c.Source)
} else if DBType(c.Driver) == DBType_postgres {
dialector = postgres.Open(c.Source)
} else if DBType(c.Driver) == DBType_sqlite {
dialector = sqlite.Open(c.Source)
} else if DBType(c.Driver) == DBType_sqlserver {
dialector = sqlserver.Open(c.Source)
}
core := log.GetCore()
db, err := gorm.Open(dialector, &gorm.Config{
Logger: NewLogger(c.Logger, core),
})
if err != nil {
return nil, err
}
sqlDB, err := db.DB()
if err != nil {
return nil, err
}
if c.MaxOpenConns > 0 {
sqlDB.SetMaxOpenConns(int(c.MaxOpenConns))
}
if c.MaxIdleConns > 0 {
sqlDB.SetMaxIdleConns(int(c.MaxIdleConns))
}
if c.ConnMaxLifetime.AsDuration() > 0 {
sqlDB.SetConnMaxLifetime(c.ConnMaxLifetime.AsDuration())
}
if err = db.Use(NewGormTracer()); err != nil {
return nil, err
}
if err = db.Use(NewGormError()); err != nil {
return nil, err
}
return db, nil
}