package produce

import (
	"fmt"
	"testing"
	"xgAutoTest/internal/dbBase"
)

func TestRun(t1 *testing.T) {
	//	global.Logs = logger.InitLogger()
	var im ImageInfo
	sqlResult := "insert into t4 values('2020-01-01','2021-01-01 10:10:10.111','2021-01-01 10:10:10.111 +8:00','10:10:10.111', '10:10:10.111 +8:00');"
	sqlResult += fmt.Sprintf("\nTotal 123 records.\n")

	sqlResult += fmt.Sprintf("\nUse time:3123 ms.")
	fmt.Println("sqlResult:", sqlResult)
	im.Runimage(sqlResult)
	im.SaveImage("./abcd.png")

}
func TestRunimage2(t1 *testing.T) {
	//global.Logs = logger.InitLogger()
	var im ImageInfo
	sqlResult := "create table  IF NOT EXISTS  t1(a int,b bigint,c float,d double,e tinyint,f smallint,g numeric(5,2))"
	sqlResult += fmt.Sprintf("\nTotal 123 records.\n")

	sqlResult += fmt.Sprintf("\nUse time:3123 ms.")
	fmt.Println("sqlResult:", sqlResult)
	im.Runimage2(sqlResult)
	im.SaveImage("./abcd.png")
}
func TestRunimageToDb(t1 *testing.T) {
	//global.Logs = logs.InitLogger()
	dbBase.InitDb("10.28.20.101", "5190", "TESTDB", "SYSDBA", "SYSDBA")
	db := dbBase.GetDb()
	sqlResult := dbBase.QueryString(db, "select * from t4;")
	var im ImageInfo

	fmt.Println("sqlResult:", sqlResult)
	im.Runimage2(sqlResult)
	im.SaveImage("./abcd.png")
}