github.com/ars0915/glossika-exercise@v0.0.0-20240904180321-a5617a00d892/pkg/db/db.go (about) 1 package db 2 3 import ( 4 "fmt" 5 "time" 6 7 "github.com/pkg/errors" 8 "gorm.io/driver/mysql" 9 "gorm.io/gorm" 10 11 "github.com/ars0915/glossika-exercise/config" 12 ) 13 14 func NewDB(config config.ConfENV) (db *gorm.DB, err error) { 15 dsn := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s?charset=utf8mb4&parseTime=True&loc=Local", 16 config.DB.Username, 17 config.DB.Password, 18 config.DB.Host, 19 config.DB.Port, 20 config.DB.Database, 21 ) 22 23 for i := 0; i < config.DB.MaxConnectionRetry; i++ { 24 db, err = gorm.Open(mysql.Open(dsn)) 25 if err != nil { 26 err = errors.Wrap(err, "init db") 27 time.Sleep(config.DB.RetryDelay) 28 continue 29 } 30 31 sqlDB, err := db.DB() 32 if err != nil { 33 err = errors.Wrap(err, "connect db") 34 time.Sleep(config.DB.RetryDelay) 35 continue 36 } 37 38 sqlDB.SetMaxIdleConns(config.DB.MaxIdleConns) 39 sqlDB.SetMaxOpenConns(config.DB.MaxOpenConns) 40 sqlDB.SetConnMaxLifetime(time.Hour) 41 42 err = sqlDB.Ping() 43 if err != nil { 44 err = errors.Wrap(err, "ping db") 45 time.Sleep(config.DB.RetryDelay) 46 continue 47 } 48 } 49 50 return db, err 51 }