xg_autotest/internal/dbBase/db_test.go

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 := `<# C:\Program_GT\Code\Go\Work\xugu\xg_autotest\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(`C:\Program_GT\Code\Go\Work\xugu\xg_autotest\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"}
	ExecFiles(db, "     insert into t3 values(?,'a');", abc, "")
}