-
Notifications
You must be signed in to change notification settings - Fork 0
/
database.go
106 lines (95 loc) · 2.41 KB
/
database.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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
package part
import (
"fmt"
"time"
"github.com/spf13/viper"
"gorm.io/driver/mysql"
"gorm.io/gorm"
"gorm.io/gorm/logger"
)
type IDataBase interface {
GetDB() *gorm.DB
GetTransaction(transId string) (result *gorm.DB, err error)
Commit(transId string) (err error)
Rollback(transId string) (err error)
}
type DataBase struct {
db *gorm.DB
transactionPool ILruCache
Enable bool
}
func NewDataBase(lruCache ILruCache) IDataBase {
instance := &DataBase{
transactionPool: lruCache,
}
// loadTime := time.Now()
enable := viper.GetBool("mysql.enable")
if enable {
instance.Enable = true
logLevel := logger.Silent
if ENV == ENUM_ENV_DEV {
logLevel = logger.Info
}
myLogger := logger.Default.LogMode(logLevel)
dsn := viper.GetString("mysql.server")
if mySqlDB, err := gorm.Open(mysql.Open(dsn), &gorm.Config{
Logger: myLogger,
DisableForeignKeyConstraintWhenMigrating: true,
}); err == nil {
mySqlDB.Set("gorm:table_options", fmt.Sprintf("ENGINE=%s DEFAULT CHARSET=%s", viper.GetString("mysql.engine"), viper.GetString("mysql.charset")))
if db, err := mySqlDB.DB(); err == nil {
db.SetMaxIdleConns(10)
db.SetMaxOpenConns(100)
db.SetConnMaxLifetime(time.Minute * 30)
}
instance.db = mySqlDB
} else {
fmt.Println("Connect to MySQL error", err)
return nil
}
}
// if ENV == ENUM_ENV_DEV {
// misc.ServiceLoadInfo("DataBase", enable, loadTime)
// }
return instance
}
func (m *DataBase) checkMe() {
if !m.Enable {
panic("DataBase is Disabled.\n")
}
}
func (m *DataBase) GetDB() *gorm.DB {
m.checkMe()
return m.db
}
func (m *DataBase) GetTransaction(transId string) (result *gorm.DB, err error) {
m.checkMe()
if exists := m.transactionPool.Contains(transId); exists {
if intface, success := m.transactionPool.Get(transId); success {
result = intface.(*gorm.DB)
}
}
if result == nil {
result = m.db.Begin().SavePoint(transId)
m.transactionPool.Add(transId, result)
}
return
}
func (m *DataBase) Commit(transId string) (err error) {
if tx, gErr := m.GetTransaction(transId); gErr == nil {
err = tx.Commit().Error
m.transactionPool.Remove(transId)
} else {
err = gErr
}
return
}
func (m *DataBase) Rollback(transId string) (err error) {
if tx, gErr := m.GetTransaction(transId); gErr == nil {
err = tx.RollbackTo(transId).Error
m.transactionPool.Remove(transId)
} else {
err = gErr
}
return
}