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  }