-
Notifications
You must be signed in to change notification settings - Fork 39
/
store.go
60 lines (50 loc) · 1.49 KB
/
store.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 bsdb
import (
"fmt"
syslog "log"
"os"
"time"
"gorm.io/driver/mysql"
"gorm.io/gorm"
"gorm.io/gorm/logger"
"github.com/bnb-chain/greenfield-storage-provider/base/gfspconfig"
"github.com/bnb-chain/greenfield-storage-provider/pkg/log"
"github.com/bnb-chain/greenfield-storage-provider/store/config"
)
var _ BSDB = &BsDBImpl{}
// BsDBImpl block syncer database, implements BSDB interface
type BsDBImpl struct {
db *gorm.DB
}
// NewBsDB return a block syncer db instance or a block syncer db backup instance based on the isBackup flag
func NewBsDB(cfg *gfspconfig.GfSpConfig, isBackup bool) (*BsDBImpl, error) {
//LoadDBConfigFromEnv(config)
dbConfig := cfg.BsDB
if isBackup {
dbConfig = cfg.BsDBBackup
}
db, err := InitDB(&dbConfig)
if err != nil {
return nil, err
}
return &BsDBImpl{db: db}, nil
}
// InitDB init a block syncer db instance
func InitDB(config *config.SQLDBConfig) (*gorm.DB, error) {
dsn := fmt.Sprintf("%s:%s@tcp(%s)/%s?charset=utf8mb4&parseTime=True&loc=Local",
config.User, config.Passwd, config.Address, config.Database)
newLogger := logger.New(
syslog.New(os.Stdout, "\r\n", syslog.LstdFlags), // io writer
logger.Config{
SlowThreshold: time.Second, // Slow SQL threshold
LogLevel: logger.Info, // Log level
Colorful: true, // Disable color
},
)
db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{Logger: newLogger})
if err != nil {
log.Errorw("gorm failed to open db", "error", err)
return nil, err
}
return db, nil
}