package dbBase

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

func TestDbLink2(t1 *testing.T) {

	db, err := sql.Open("xugusql", "IP=10.28.20.101;DB=SYSTEM;User=SYSDBA;"+"PWD=SYSDBA;Port=5190;AUTO_COMMIT=on;CHAR_SET=UTF8")

	err = db.Ping()
	if err != nil {
		fmt.Printf("connect xugu dbms ... failed\n")
	} else {

		fmt.Printf("connect xugu dbms ... ok\n")
	}

	err = db.Close()

}
func TestDbLink(t1 *testing.T) {

	InitDb("10.28.20.101", "5190", "TESTDB", "SYSDBA", "SYSDBA")
	db := GetDb()
	defer db.Close()

}

func TestIns(t1 *testing.T) {

	InitDb("10.28.20.101", "5190", "TESTDB", "SYSDBA", "SYSDBA")
	db := GetDb()
	defer db.Close()
	a := "<# /home/gtong/xugu_work/xgtest/file/test_pic_1.png;"
	ExecString(db, fmt.Sprintf("insert into t3 values(%s,'a');", a))
}

func TestInsPrepare(t1 *testing.T) {

	InitDb("10.28.20.101", "5190", "TESTDB", "SYSDBA", "SYSDBA")
	db := GetDb()
	defer db.Close()
	var args []interface{}
	// 读取图像文件
	imageData, err := os.ReadFile("/home/gtong/xugu_work/xgtest/file/test_pic_1.png")
	if err != nil {
		log.Fatal(err)
	}

	stmt, err := db.Prepare("insert into t3 values(?,'a')")
	if err != nil {
		log.Fatal(err)
	}
	args = append(args, imageData)
	_, err = stmt.Exec(args...)
	if err != nil {
		log.Fatal(err)
	}

	stmt.Close()
}

func TestInsPrepare2(t1 *testing.T) {

	InitDb("10.28.20.101", "5190", "TESTDB", "SYSDBA", "SYSDBA")
	db := GetDb()
	defer db.Close()
	abc := []string{" ../../file/test.txt"}
	ExecPrepareString(db, "     insert into t3 values(?,'a');", abc)
}