package dm

import (
	"database/sql"
	"fmt"
	"testing"
)

func Test_Connect(t *testing.T) {
	//dsn := "dm://SYSDBA:SYSDBA001@172.16.224.146:5236?schema=SYSDBA&appName=DM8_Test_Connect&connectTimeout=3000&logLevel=all"
	dsn := "dm://SYSDBA:SYSDBA001@172.16.224.146:5236?appName=DM8_Test_Connect&connectTimeout=3000&logLevel=all"
	db, err := sql.Open("dm", dsn)
	if err != nil {
		t.Error(err)
		return
	}
	sqlText := "select sf_get_unicode_flag()"
	var charSet string

	err = db.QueryRow(sqlText).Scan(&charSet)
	if err != nil {
		t.Error(err)
		return
	}
	fmt.Println("charSet:", charSet)
}