package databaseUtil

import (
	"database/sql"
	"os"

	go_ora "github.com/sijms/go-ora/v2"
)

func InitConn(user, pwd, server string, port int, database string, sid string, charset string) (*sql.DB, error) {
	var db *sql.DB
	err := os.Setenv("NLS_LANG", charset)
	if err != nil {
		return nil, err
	}
	var connStr string
	if database != "" {
		connStr = go_ora.BuildUrl(server, port, database, user, pwd, nil)
	}
	if sid != "" {
		urlOptions := map[string]string{"SID": sid}
		connStr = go_ora.BuildUrl(server, port, "", user, pwd, urlOptions)
	}

	db, err = sql.Open("oracle", connStr)
	if err != nil {
		return nil, err
	}
	err = db.Ping()

	return db, err
}