sqlx.go

package dao

import (
	"crm-server/configs"
	"fmt"
	"log"
	"github.com/jmoiron/sqlx"
)



func GetDb()(*sqlx.DB)  {
	db1 := configs.GetDBOne()
	db, err := sqlx.Open(db1.Engine, fmt.Sprintf("%s:%s@tcp(%s:%s)/%s?charset=utf8", db1.User, db1.Pass, db1.Ip, db1.Port, db1.Table))
	if err != nil {
		log.Fatalln(err)
	}
	return db
}

func GetCmsDb()(*sqlx.DB)  {
	db1 := configs.GetDBCms()
	db, err := sqlx.Open(db1.Engine, fmt.Sprintf("%s:%s@tcp(%s:%s)/%s?charset=utf8", db1.User, db1.Pass, db1.Ip, db1.Port, db1.Table))
	if err != nil {
		log.Fatalln(err)
	}
	return db
}