dmitriygnatenko-v2/internal/services/db/db.go

package db

import (
	"database/sql"

	"github.com/dmitriygnatenko/internal/interfaces"
)

func Init(env interfaces.IEnv) (*sql.DB, error) {
	dataSource := env.GetDBUser() + ":" + env.GetDBPassword() +
		"@tcp(" + env.GetDBHost() + ":" + env.GetDBPort() + ")/" + env.GetDBName()

	db, err := sql.Open("mysql", dataSource)
	if err != nil {
		return nil, err
	}

	if err = db.Ping(); err != nil {
		return nil, err
	}

	return db, nil
}