generated from CyanAsterisk/.github
/
db.go
45 lines (41 loc) · 1.12 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
package initialize
import (
"fmt"
"time"
"github.com/CyanAsterisk/TikGok/server/cmd/video/config"
"github.com/CyanAsterisk/TikGok/server/shared/consts"
"github.com/cloudwego/kitex/pkg/klog"
"gorm.io/driver/mysql"
"gorm.io/gorm"
"gorm.io/gorm/logger"
"gorm.io/gorm/schema"
"gorm.io/plugin/opentelemetry/logging/logrus"
"gorm.io/plugin/opentelemetry/tracing"
)
// InitDB to init database
func InitDB() *gorm.DB {
c := config.GlobalServerConfig.MysqlInfo
dsn := fmt.Sprintf(consts.MySqlDSN, c.User, c.Password, c.Host, c.Port, c.Name)
newLogger := logger.New(
logrus.NewWriter(), // io writer
logger.Config{
SlowThreshold: time.Second, // Slow SQL Threshold
LogLevel: logger.Silent, // Log level
Colorful: true, // Disable color printing
},
)
// global mode
db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{
NamingStrategy: schema.NamingStrategy{
SingularTable: true,
},
Logger: newLogger,
})
if err != nil {
klog.Fatalf("init gorm failed: %s", err)
}
if err = db.Use(tracing.NewPlugin()); err != nil {
klog.Fatalf("use tracing plugin failed: %s", err)
}
return db
}