forked from open-falcon/falcon-plus
/
database.go
113 lines (100 loc) · 2.17 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
107
108
109
110
111
112
113
package config
import (
"database/sql"
"fmt"
_ "github.com/go-sql-driver/mysql"
"github.com/jinzhu/gorm"
"github.com/spf13/viper"
)
type DBPool struct {
Falcon *gorm.DB
Graph *gorm.DB
Uic *gorm.DB
Dashboard *gorm.DB
Alarm *gorm.DB
}
var (
dbp DBPool
)
func Con() DBPool {
return dbp
}
func SetLogLevel(loggerlevel bool) {
dbp.Uic.LogMode(loggerlevel)
dbp.Graph.LogMode(loggerlevel)
dbp.Falcon.LogMode(loggerlevel)
dbp.Dashboard.LogMode(loggerlevel)
dbp.Alarm.LogMode(loggerlevel)
}
func InitDB(loggerlevel bool) (err error) {
var p *sql.DB
portal, err := gorm.Open("mysql", viper.GetString("db.falcon_portal"))
portal.Dialect().SetDB(p)
portal.LogMode(loggerlevel)
if err != nil {
return fmt.Errorf("connect to falcon_portal: %s", err.Error())
}
portal.SingularTable(true)
dbp.Falcon = portal
var g *sql.DB
graphd, err := gorm.Open("mysql", viper.GetString("db.graph"))
graphd.Dialect().SetDB(g)
graphd.LogMode(loggerlevel)
if err != nil {
return fmt.Errorf("connect to graph: %s", err.Error())
}
graphd.SingularTable(true)
dbp.Graph = graphd
var u *sql.DB
uicd, err := gorm.Open("mysql", viper.GetString("db.uic"))
uicd.Dialect().SetDB(u)
uicd.LogMode(loggerlevel)
if err != nil {
return fmt.Errorf("connect to uic: %s", err.Error())
}
uicd.SingularTable(true)
dbp.Uic = uicd
var d *sql.DB
dashd, err := gorm.Open("mysql", viper.GetString("db.dashboard"))
dashd.Dialect().SetDB(d)
dashd.LogMode(loggerlevel)
if err != nil {
return fmt.Errorf("connect to dashboard: %s", err.Error())
}
dashd.SingularTable(true)
dbp.Dashboard = dashd
var alm *sql.DB
almd, err := gorm.Open("mysql", viper.GetString("db.alarms"))
almd.Dialect().SetDB(alm)
almd.LogMode(loggerlevel)
if err != nil {
return fmt.Errorf("connect to alarms: %s", err.Error())
}
almd.SingularTable(true)
dbp.Alarm = almd
SetLogLevel(loggerlevel)
return
}
func CloseDB() (err error) {
err = dbp.Falcon.Close()
if err != nil {
return
}
err = dbp.Graph.Close()
if err != nil {
return
}
err = dbp.Uic.Close()
if err != nil {
return
}
err = dbp.Dashboard.Close()
if err != nil {
return
}
err = dbp.Alarm.Close()
if err != nil {
return
}
return
}