Database session middleware for Golang Echo API

database.go

const (
	DatabaseConfigFile = "database.json"
	DatabaseDriver     = "mysql"
	DatabaseKey        = "db"
)

type DatabaseConfig struct {
	Driver struct {
		Database string `json:"dbname"`
		Host     string `json:"host"`
		Port     string `json:"port"`
		User     string `json:"user"`
		Pass     string `json:"pass"`
	} `json:"mysql"`
}

func LoadDatabaseConfiguration(file string) DatabaseConfig {
	var config DatabaseConfig
	configFile, err := os.Open(file)
	defer func() {
		err := configFile.Close()
		if err != nil {
			panic(err)
		}
	}()
	if err != nil {
		log.Println(err.Error())
	}
	jsonParser := json.NewDecoder(configFile)
	if err = jsonParser.Decode(&config); err != nil {
		panic(err)
	}
	return config
}

func CreateBoundedDatabaseConnection(configPath string) echo.MiddlewareFunc {
	config := LoadDatabaseConfiguration(configPath)
	databaseUri := fmt.Sprintf(
		"%s:%s@tcp(%s:%s)/%s?parseTime=true",
		config.Driver.User,
		config.Driver.Pass,
		config.Driver.Host,
		config.Driver.Port,
		config.Driver.Database,
	)
	return func(next echo.HandlerFunc) echo.HandlerFunc {
		return func(c echo.Context) error {
			db, err := sql.Open(DatabaseDriver, databaseUri)
			if err != nil {
				panic(err)
			}
			c.Set(DatabaseKey, db)

			c.Response().After(func() {
				db := c.Get(DatabaseKey).(*sql.DB)
				err := db.Close()
				if err != nil {
					panic(err)
				}
			})
			return next(c)
		}
	}
}