MTP20_IF/db/db.go

package db

import (
	"fmt"

	"mtp2_if/config"

	"github.com/xormplus/core"
	"github.com/xormplus/xorm"
)

//var driverName = "oci8"
//var dataSourceName = "mtp2_test18/muchinfo@192.168.31.117:1521/orcl"
var Engine *xorm.Engine

// NewDbDriver 创建数据库驱动
func InitDbEngine() error {
	driverName := config.SerCfg.GetDbDriver()
	dataSourceName := config.SerCfg.GetDbSource()

	var err error
	Engine, err = xorm.NewOracle(driverName, dataSourceName)
	if err != nil {
		fmt.Println("create db engine failed:", err)
		return err
	}

	Engine.SetMaxIdleConns(10)
	Engine.SetMaxOpenConns(100)
	Engine.ShowSQL(true)
	Engine.SetTableMapper(core.SameMapper{})

	return nil
}

func GetEngine() *xorm.Engine {
	return Engine
}

func Close() {
	Engine.Close()
}