-
Notifications
You must be signed in to change notification settings - Fork 2
/
db.go
80 lines (67 loc) · 1.54 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
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
package migo
import (
"fmt"
"io/ioutil"
"encoding/json"
"github.com/ghodss/yaml"
"github.com/pkg/errors"
)
type DB struct {
User string `json:"user"`
Passwd string `json:"passwd"`
Addr string `json:"addr"`
DBName string `json:"dbname"`
}
type DatabaseConfigure struct {
Config map[string]DB
}
func NewDB(filePath, env string) (DB, error) {
c, err := NewDatabaseConfigure(filePath)
if err != nil {
return DB{}, errors.Wrap(err, "reading database config")
}
if !c.hasEnv(env) {
return DB{}, fmt.Errorf("%s is not in database config", env)
}
return c.Config[env], nil
}
func NewDatabaseConfigure(filePath string) (DatabaseConfigure, error) {
b, err := ioutil.ReadFile(filePath)
if err != nil {
return DatabaseConfigure{}, errors.Wrap(err, "YAML file open error")
}
m := map[string]interface{}{}
if err := yaml.Unmarshal(b, &m); err != nil {
return DatabaseConfigure{}, errors.Wrap(err, "YAML file parse error")
}
c := map[string]DB{}
for k, v := range m {
b, err := json.Marshal(v)
if err != nil {
return DatabaseConfigure{}, err
}
db := DB{}
if err := json.Unmarshal(b, &db); err != nil {
return DatabaseConfigure{}, err
}
c[k] = db
}
return DatabaseConfigure{Config: c}, nil
}
func (c DatabaseConfigure) hasEnv(env string) bool {
for k := range c.Config {
if k == env {
return true
}
}
return false
}
func (db DB) FormatDSN() string {
m := NewMySQLConfig(db)
return m.FormatDSN()
}
func (db DB) FormatDBUnspecifiedDSN() string {
m := NewMySQLConfig(db)
m.DBName = ""
return m.FormatDSN()
}