-
Notifications
You must be signed in to change notification settings - Fork 5
/
database_manager.go
106 lines (91 loc) · 2.6 KB
/
database_manager.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 common
import (
"fmt"
"os"
"github.com/jeremyhahn/tradebot/entity"
"github.com/jinzhu/gorm"
_ "github.com/jinzhu/gorm/dialects/sqlite"
)
type DatabaseManager interface {
ConnectCoreDB() *gorm.DB
MigrateCoreDB()
DropCoreDB()
ConnectPriceDB() *gorm.DB
MigratePriceDB()
DropPriceDB()
Close(*gorm.DB)
}
type DatabaseImpl struct {
directory string
prefix string
debugMode bool
DatabaseManager
}
func NewDatabase() DatabaseManager {
return CreateDatabase("", "./db", false)
}
func CreateDatabase(directory, prefix string, debugMode bool) DatabaseManager {
return &DatabaseImpl{
directory: directory,
prefix: prefix,
debugMode: debugMode}
}
func (database *DatabaseImpl) MigrateCoreDB() {
coreDB := database.ConnectCoreDB()
if coreDB == nil {
panic("Database: CoreDB database pointer is nil")
}
coreDB.AutoMigrate(&entity.ChartIndicator{})
coreDB.AutoMigrate(&entity.ChartStrategy{})
coreDB.AutoMigrate(&entity.Chart{})
coreDB.AutoMigrate(&entity.Trade{})
coreDB.AutoMigrate(&entity.UserCryptoExchange{})
coreDB.AutoMigrate(&entity.Plugin{})
coreDB.AutoMigrate(&entity.Profit{})
coreDB.AutoMigrate(&entity.MarketCap{})
coreDB.AutoMigrate(&entity.GlobalMarketCap{})
coreDB.AutoMigrate(&entity.Transaction{})
coreDB.AutoMigrate(&entity.Trade{})
coreDB.AutoMigrate(&entity.User{})
coreDB.AutoMigrate(&entity.UserWallet{})
coreDB.AutoMigrate(&entity.UserToken{})
coreDB.AutoMigrate(&entity.UserCryptoExchange{})
coreDB.AutoMigrate(&entity.PriceHistory{})
}
func (database *DatabaseImpl) MigratePriceDB() {
priceDB := database.ConnectPriceDB()
priceDB.AutoMigrate(&entity.PriceHistory{})
}
func (database *DatabaseImpl) ConnectCoreDB() *gorm.DB {
return database.newSQLite(fmt.Sprintf("%s/%s%s.db", database.directory, database.prefix, APPNAME))
}
func (database *DatabaseImpl) DropCoreDB() {
os.Remove(fmt.Sprintf("%s/%s%s.db", database.directory, database.prefix, APPNAME))
}
func (database *DatabaseImpl) ConnectPriceDB() *gorm.DB {
return database.newSQLite(fmt.Sprintf("%s/%sprices.db", database.directory, database.prefix))
}
func (database *DatabaseImpl) DropPriceDB() {
os.Remove(fmt.Sprintf("%s/%sprices.db", database.directory, database.prefix))
}
func (database *DatabaseImpl) Close(db *gorm.DB) {
db.Close()
}
func (database *DatabaseImpl) newSQLite(dbname string) *gorm.DB {
db, err := gorm.Open("sqlite3", dbname)
db.LogMode(database.debugMode)
if err != nil {
panic(err)
}
return db
}
/*
func NewMySQL() *gorm.DB {
db, err := gorm.Open("mysql", "user:pass@tcp(ip:3306)/mydb?charset=utf8&parseTime=True")
db.LogMode(true)
if err != nil {
panic(err)
}
return db
}
*/