]>
Commit | Line | Data |
---|---|---|
7a9e5112 | 1 | package db |
2 | ||
3 | import ( | |
4215df47 | 4 | migrate "github.com/go-pg/migrations" |
7a9e5112 | 5 | "github.com/go-pg/pg" |
6 | "github.com/go-pg/pg/orm" | |
323b7f40 | 7 | "github.com/go-redis/redis" |
7a9e5112 | 8 | "github.com/jloup/utils" |
9 | ) | |
10 | ||
7a9e5112 | 11 | var log = utils.StandardL().WithField("module", "db") |
12 | ||
323b7f40 | 13 | var ( |
14 | DB *pg.DB | |
15 | Redis *redis.Client | |
16 | ) | |
17 | ||
7a9e5112 | 18 | type DBConfig struct { |
19 | Address string | |
20 | Database string | |
21 | User string | |
22 | Password string | |
23 | } | |
24 | ||
323b7f40 | 25 | type RedisConfig struct { |
26 | Type string // tcp or unix | |
27 | Address string | |
28 | Password string | |
17b68539 | 29 | Database int |
323b7f40 | 30 | } |
31 | ||
32 | func Init(config DBConfig, redisConfig RedisConfig) { | |
7a9e5112 | 33 | var err error |
34 | ||
35 | DB = connect(config) | |
36 | ||
4215df47 | 37 | err = migratedb() |
7a9e5112 | 38 | if err != nil { |
4215df47 | 39 | log.Fatalf("cannot migratedb '%v'\n", err) |
7a9e5112 | 40 | } |
323b7f40 | 41 | |
42 | Redis = redis.NewClient(&redis.Options{ | |
43 | Network: redisConfig.Type, | |
44 | Addr: redisConfig.Address, | |
45 | Password: redisConfig.Password, | |
17b68539 | 46 | DB: redisConfig.Database, |
323b7f40 | 47 | }) |
48 | ||
49 | _, err = Redis.Ping().Result() | |
50 | ||
51 | if err != nil { | |
52 | log.Fatalf("redis init error %s", err) | |
53 | } | |
54 | ||
4215df47 | 55 | } |
7a9e5112 | 56 | |
4215df47 | 57 | func migratedb() error { |
58 | /* Remove after first MEP */ | |
59 | version, err := migrate.Version(DB) | |
7a9e5112 | 60 | if err != nil { |
4215df47 | 61 | return err |
62 | } | |
63 | ||
64 | if version == 0 { | |
65 | return migrate.SetVersion(DB, 1) | |
7a9e5112 | 66 | } |
4215df47 | 67 | /***/ |
68 | ||
69 | mig := make([]migrate.Migration, 0) | |
70 | ||
71 | for _, migration := range migrations { | |
72 | mig = append(mig, migrate.Migration{ | |
73 | Version: migration.Version, | |
74 | Up: func(db orm.DB) error { | |
75 | for _, query := range migration.Up { | |
76 | _, err := db.Exec(query) | |
77 | if err != nil { | |
78 | return err | |
79 | } | |
80 | } | |
81 | ||
82 | return nil | |
83 | }, | |
84 | Down: func(db orm.DB) error { | |
85 | for _, query := range migration.Down { | |
86 | _, err := db.Exec(query) | |
87 | if err != nil { | |
88 | return err | |
89 | } | |
90 | } | |
91 | ||
92 | return nil | |
93 | }, | |
94 | }) | |
95 | } | |
96 | ||
97 | oldVersion, newVersion, err := migrate.RunMigrations(DB, mig, "up") | |
98 | ||
99 | if oldVersion != newVersion { | |
100 | log.Infof("Migrate DB: %v -> %v", oldVersion, newVersion) | |
101 | } else { | |
102 | log.Infof("DB up-to-date: version '%v'", newVersion) | |
103 | } | |
104 | return err | |
7a9e5112 | 105 | } |
106 | ||
107 | func connect(config DBConfig) *pg.DB { | |
108 | return pg.Connect(&pg.Options{ | |
109 | User: config.User, | |
110 | Password: config.Password, | |
111 | Database: config.Database, | |
112 | Addr: config.Address, | |
113 | }) | |
114 | } |