package models

import (
	"fmt"
	"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",
		username, password, addr, dbName)
	fmt.Println(sqlServer)
	// 打开数据库连接
	//db, err = gorm.Open("mssql", "sqlserver://sa:LZdba@)@)@10.6.201.7:1433?database=LZGS")
	db, err = gorm.Open("mssql", sqlServer)
	if err != nil {
		return err
	}

	return nil
}

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

// CloseDB .
func CloseDB() {
	if db != nil {
		db.Close()
	}
}