MTP20_IF/db/db.go

package db

import (
	"fmt"

	"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 {
	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
}