main.go

package model

import (
	"database/sql"
	"fmt"
	"time"

	"github.com/godror/godror"
	"github.com/godror/godror/dsn"

)

// DBFunc database function
type DBFunc struct {
	dbConn *sql.DB
}

//var GlobalDb * DBFunc
var (
	GlobalDb     *DBFunc
	dbConf       conf.DatabaseObject
	
)

// DialDB establishes a new connection to db
func DialDB() *DBFunc {
	db := &DBFunc{
		dbConn: &sql.DB{},
	}
	conf := getDBConnCredentials()

	dbConf := godror.ConnectionParams{
		CommonParams: dsn.CommonParams{
			Username: "user",
			Password: dsn.NewPassword("secret"),
			Timezone: time.Local,
		},
		// ConnParams: godror.ConnParams{
		// 	ConnClass: "POOLED",
		// },
		PoolParams: godror.PoolParams{
			MinSessions:      0,
			MaxSessions:      50,
			SessionIncrement: 1,
			SessionTimeout:   42 * time.Second,
			MaxLifeTime:      time.Hour,
		},
	}
  dbConf.ConnectString = "172.30.20.10:1521/testdb"

	db.dbConn = sql.OpenDB(godror.NewConnector(dbConf))
	


	return db
}

// GetDBInstance get db instance and checks if instance is going well
func GetDBInstance() *DBFunc {
	if GlobalDb == nil {
		GlobalDb = DialDB()
	}
	return GlobalDb
}