/
db.go
64 lines (50 loc) · 1.39 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
package db
import (
"fmt"
"time"
log "github.com/sirupsen/logrus"
"github.com/Xacor/fishing_company/pkg/models"
"gorm.io/driver/mysql"
"gorm.io/gorm"
"gorm.io/gorm/logger"
)
var DB *gorm.DB
func ConnectLoop(timeout time.Duration, dialecor gorm.Dialector) (db *gorm.DB, err error) {
ticker := time.NewTicker(1 * time.Second)
defer ticker.Stop()
timeoutExceeded := time.After(timeout)
for {
select {
case <-timeoutExceeded:
return nil, fmt.Errorf("db connection failed after %s timeout", timeout)
case <-ticker.C:
db, err := gorm.Open(dialecor, &gorm.Config{
Logger: logger.Default.LogMode(logger.Silent),
})
if err == nil {
return db, nil
}
log.Error(err)
}
}
}
func Init(url string) {
db, err := ConnectLoop(time.Second*30, mysql.Open(url))
if err != nil {
log.Fatalln(err)
}
if err = db.SetupJoinTable(&models.Trip{}, "FishTypes", &models.FishTypeTrip{}); err != nil {
log.Fatalln(err)
}
if err = db.AutoMigrate(&models.Boat{}, &models.FishTypeTrip{}, &models.Trip{}, &models.User{}, &models.Employee{}, &models.Position{}, &models.FishType{}, &models.SeaBank{}, &models.Btype{}); err != nil {
log.Fatalln(err)
}
result := db.Find(&[]models.Role{})
if result.RowsAffected == 0 {
result := db.Create(&models.Role{ID: 1, Name: "Admin"}).Create(&models.Role{ID: 2, Name: "User"})
if result.Error != nil {
log.Fatal(result.Error)
}
}
DB = db
}