monitor/db/db_test.go

package db

import (
	"fmt"
	"testing"
)

func TestQuery(t *testing.T) {
	var (
		userName  = "root"
		password  = "jEER3Dc="
		ipAddrees = "47.110.138.172"
		port      = 3306
		dbName    = "newDB"
		charset   = "utf8"
	)
	config := Config{
		UserName: userName, Password: password, Ip: ipAddrees, Port: port, DbName: dbName, Charset: charset,
	}
	var Db = ConnectMysql(&config)
	defer Db.Close()
	info := UserInfo{}
	data, err := info.SelectData(Db)
	if err != nil {
		fmt.Printf("error:[%v]", err)
	}

	for _, d := range data {
		fmt.Println(d.UserName, "=>", d.UserId)
	}

}