package db

import (
	"fmt"

	"sdkCompare/config"

	"basic.com/valib/logger.git"
	"gorm.io/driver/mysql"
	"gorm.io/gorm"
)

var db *gorm.DB

func ConnectDB() error {
	var err error

	dsn := fmt.Sprintf("%s:%s@tcp(%s)/%s?charset=utf8mb4",
		config.MainConf.Username,
		config.MainConf.Password,
		config.MainConf.MysqlAddr,
		config.MainConf.Database)

	db, err = gorm.Open(mysql.Open(dsn), &gorm.Config{
		// 禁用外键(指定外键时不会在mysql创建真实的外键约束)
		DisableForeignKeyConstraintWhenMigrating: true,
		//// 指定表前缀
		//NamingStrategy: schema.NamingStrategy{
		//	TablePrefix: config.Conf.Mysql.TablePrefix + "_",
		//},
	})

	if err != nil {
		logger.Error("mysql database open err: %s", err.Error())
		return err
	}

	return nil
}