106 lines
1.9 KiB
Go
106 lines
1.9 KiB
Go
|
package mysql
|
||
|
|
|
||
|
|
import (
|
||
|
|
"os"
|
||
|
|
"strconv"
|
||
|
|
"time"
|
||
|
|
|
||
|
|
"gorm.io/driver/mysql"
|
||
|
|
"gorm.io/gorm"
|
||
|
|
"gorm.io/gorm/logger"
|
||
|
|
"gorm.io/gorm/schema"
|
||
|
|
"gorm.io/plugin/dbresolver"
|
||
|
|
)
|
||
|
|
|
||
|
|
/*
|
||
|
|
docker配置
|
||
|
|
|
||
|
|
MYSQL_DSN=root:root@tcp(mysql:3306)/sample?charset=utf8mb4&parseTime=True&loc=Local \
|
||
|
|
MYSQL_MAXLIFETIME=2\
|
||
|
|
MYSQL_MAXIDLECONNS=2\
|
||
|
|
MYSQL_MAXOPENCONNS=200\
|
||
|
|
MYSQL_INIT=true \
|
||
|
|
*/
|
||
|
|
var (
|
||
|
|
_db *gorm.DB
|
||
|
|
)
|
||
|
|
|
||
|
|
// 创建实例
|
||
|
|
func newDB() (*gorm.DB, error) {
|
||
|
|
if _db != nil {
|
||
|
|
return _db, nil
|
||
|
|
}
|
||
|
|
|
||
|
|
dsn := os.Getenv("MYSQL_DSN")
|
||
|
|
if dsn == "" {
|
||
|
|
dsn = "root:root@tcp(127.0.0.1:3306)/mysql?charset=utf8&parseTime=True&loc=Local"
|
||
|
|
}
|
||
|
|
maxLifetime := func() int {
|
||
|
|
c := os.Getenv("MYSQL_MAXLIFETIME")
|
||
|
|
cc, err := strconv.Atoi(c)
|
||
|
|
if err != nil {
|
||
|
|
return 1
|
||
|
|
}
|
||
|
|
|
||
|
|
if cc <= 0 {
|
||
|
|
return 1
|
||
|
|
}
|
||
|
|
if cc >= 1000 {
|
||
|
|
cc = 1000
|
||
|
|
}
|
||
|
|
return cc
|
||
|
|
}()
|
||
|
|
maxIdleConns := func() int {
|
||
|
|
c := os.Getenv("MYSQL_MAXIDLECONNS")
|
||
|
|
cc, err := strconv.Atoi(c)
|
||
|
|
if err != nil {
|
||
|
|
return 1
|
||
|
|
}
|
||
|
|
|
||
|
|
if cc < 0 {
|
||
|
|
return 0
|
||
|
|
}
|
||
|
|
if cc >= 1000 {
|
||
|
|
cc = 1000
|
||
|
|
}
|
||
|
|
return cc
|
||
|
|
}()
|
||
|
|
maxOpenConns := func() int {
|
||
|
|
c := os.Getenv("MYSQL_MAXOPENCONNS")
|
||
|
|
cc, err := strconv.Atoi(c)
|
||
|
|
if err != nil {
|
||
|
|
return 1
|
||
|
|
}
|
||
|
|
|
||
|
|
if cc < 0 {
|
||
|
|
return 0
|
||
|
|
}
|
||
|
|
if cc >= 1000 {
|
||
|
|
cc = 1000
|
||
|
|
}
|
||
|
|
return cc
|
||
|
|
}()
|
||
|
|
|
||
|
|
var err error
|
||
|
|
_db, err = gorm.Open(mysql.Open(dsn), &gorm.Config{
|
||
|
|
SkipDefaultTransaction: true,
|
||
|
|
Logger: logger.Default.LogMode(logger.Silent),
|
||
|
|
NamingStrategy: schema.NamingStrategy{
|
||
|
|
SingularTable: true,
|
||
|
|
},
|
||
|
|
})
|
||
|
|
if err != nil {
|
||
|
|
return nil, err
|
||
|
|
}
|
||
|
|
_db.Use(
|
||
|
|
dbresolver.Register(dbresolver.Config{
|
||
|
|
Sources: []gorm.Dialector{mysql.Open(dsn)},
|
||
|
|
Replicas: []gorm.Dialector{mysql.Open(dsn)},
|
||
|
|
Policy: dbresolver.RandomPolicy{},
|
||
|
|
}).SetConnMaxIdleTime(time.Hour).
|
||
|
|
SetConnMaxLifetime(time.Duration(maxLifetime) * time.Hour).
|
||
|
|
SetMaxIdleConns(maxIdleConns).
|
||
|
|
SetMaxOpenConns(maxOpenConns))
|
||
|
|
return _db, nil
|
||
|
|
}
|