singlestore-go-bookstore database connection

db.go

package database

import (
	"bookstore/config"
	"bookstore/model"
	"fmt"
	"log"

	"gorm.io/driver/mysql"
	"gorm.io/gorm"
)

var DB *gorm.DB

func InitializeDB() {
	dsn := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s?charset=utf8mb4&parseTime=True&loc=UTC", config.Database.Username, config.Database.Password, config.Database.Host, config.Database.Port, config.Database.Database)
	db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
	if err != nil {
		log.Fatalf("Failed to connect to database: %v", err)
	}
	log.Println("Connected to database")
	db.AutoMigrate(&model.Book{}, &model.Order{}, &model.OrderItem{})
	DB = db
}