package kingdee

import (
	"fmt"

	"kingdee-dbapi/logger"

	//"gorm.io/driver/sqlserver"
	//"gorm.io/gorm"

	"github.com/jinzhu/gorm"
	_ "github.com/jinzhu/gorm/dialects/mssql"
)

var db *gorm.DB
var err error

// Init .
func Init(username, password, addr, dbName string) error {
	var err error

	sqlServer := fmt.Sprintf("sqlserver://%s:%s@%s:1433?database=%s;encrypt=disable;",
		username, password, addr, dbName)

	logger.Debug("sqlServer地址:%s", sqlServer)
	// 打开数据库连接
	db, err = gorm.Open("mssql", sqlServer)
	// gorm 2.0
	//db, err = gorm.Open(sqlserver.Open(sqlServer), &gorm.Config{})
	if err != nil {
		return err
	}

	return nil
}

func GetDB() *gorm.DB {
	return db
}

// 2.0 CloseDB .
//func CloseDB() {
//	sqlDB, err := db.DB()
//	if err != nil {
//		return
//	}
//
//	sqlDB.Close()
//}

func CloseDB() {
	db.Close()
}