main.go 8.7 KB
Newer Older
B
Bomin Zhang 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
package main

import (
	"database/sql"
	"encoding/json"
	"errors"
	"flag"
	"fmt"
	"math/rand"
	"os"
	"os/signal"
	"strings"
	"sync"
	"sync/atomic"
	"time"

	_ "github.com/taosdata/driver-go/taosSql"
)

type argument struct {
	Type string        `json:"type"`
	Min  int           `json:"min"`
	Max  int           `json:"max"`
	List []interface{} `json:"list, omitempty"`
}

B
Bomin Zhang 已提交
27
type testCase struct {
B
Bomin Zhang 已提交
28 29
	isQuery bool       `json:"-"`
	numArgs int        `json:"-"`
B
Bomin Zhang 已提交
30
	Weight  int        `json:"weight"`
31
	SQL     string     `json:"sql"`
B
Bomin Zhang 已提交
32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100
	Args    []argument `json:"args"`
}

func (arg *argument) check() (int, error) {
	if arg.Type == "list" {
		if len(arg.List) == 0 {
			return 0, errors.New("list cannot be empty")
		}
		return 1, nil
	}

	if arg.Max < arg.Min {
		return 0, errors.New("invalid min/max value")
	}

	if arg.Type == "string" {
		if arg.Min < 0 {
			return 0, errors.New("negative string length")
		}
	}

	if arg.Type == "int" && arg.Min == 0 && arg.Max == 0 {
		arg.Max = arg.Min + 100
	}

	if arg.Type == "range" {
		return 2, nil
	}

	return 1, nil
}

func (arg *argument) generate(args []interface{}) []interface{} {
	const chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789"

	switch arg.Type {
	case "bool":
		if rand.Intn(2) == 1 {
			args = append(args, true)
		} else {
			args = append(args, false)
		}

	case "int":
		v := rand.Intn(arg.Max-arg.Min+1) + arg.Min
		args = append(args, v)

	case "range":
		v := rand.Intn(arg.Max-arg.Min) + arg.Min
		args = append(args, v)
		v = rand.Intn(arg.Max-v+1) + v
		args = append(args, v)

	case "string":
		l := rand.Intn(arg.Max-arg.Min+1) + arg.Min
		sb := strings.Builder{}
		for i := 0; i < l; i++ {
			sb.WriteByte(chars[rand.Intn(len(chars))])
		}
		args = append(args, sb.String())

	case "list":
		v := arg.List[rand.Intn(len(arg.List))]
		args = append(args, v)
	}

	return args
}

B
Bomin Zhang 已提交
101 102 103 104 105
func (tc *testCase) buildSql() string {
	args := make([]interface{}, 0, tc.numArgs)
	for i := 0; i < len(tc.Args); i++ {
		args = tc.Args[i].generate(args)
	}
106
	return fmt.Sprintf(tc.SQL, args...)
B
Bomin Zhang 已提交
107 108
}

B
Bomin Zhang 已提交
109 110 111 112 113 114 115 116
type statitics struct {
	succeeded         int64
	failed            int64
	succeededDuration int64
	failedDuration    int64
}

var (
B
Bomin Zhang 已提交
117 118 119 120 121 122 123
	host     string
	port     uint
	database string
	user     string
	password string
	fetch    bool

B
Bomin Zhang 已提交
124 125
	chLog       chan string
	wgLog       sync.WaitGroup
B
Bomin Zhang 已提交
126 127
	startAt     time.Time
	shouldStop  int64
B
Bomin Zhang 已提交
128
	wgTest      sync.WaitGroup
B
Bomin Zhang 已提交
129 130 131
	stat        statitics
	totalWeight int
	cases       []testCase
B
Bomin Zhang 已提交
132 133
)

134 135
func loadTestCaseFromFile(file *os.File) error {
	if e := json.NewDecoder(file).Decode(&cases); e != nil {
B
Bomin Zhang 已提交
136 137 138
		return e
	}

139 140
	if len(cases) == 0 {
		return fmt.Errorf("no test case loaded.")
B
Bomin Zhang 已提交
141 142
	}

B
Bomin Zhang 已提交
143 144
	for i := 0; i < len(cases); i++ {
		c := &cases[i]
145 146
		c.SQL = strings.TrimSpace(c.SQL)
		c.isQuery = strings.ToLower(c.SQL[:6]) == "select"
B
Bomin Zhang 已提交
147 148 149 150
		if c.Weight < 0 {
			return fmt.Errorf("test %d: negative weight", i)
		}
		totalWeight += c.Weight
B
Bomin Zhang 已提交
151

B
Bomin Zhang 已提交
152 153
		for j := 0; j < len(c.Args); j++ {
			arg := &c.Args[j]
B
Bomin Zhang 已提交
154 155 156
			arg.Type = strings.ToLower(arg.Type)
			n, e := arg.check()
			if e != nil {
B
Bomin Zhang 已提交
157
				return fmt.Errorf("test case %d argument %d: %s", i, j, e.Error())
B
Bomin Zhang 已提交
158
			}
B
Bomin Zhang 已提交
159 160 161 162 163 164 165
			c.numArgs += n
		}
	}

	if totalWeight == 0 {
		for i := 0; i < len(cases); i++ {
			cases[i].Weight = 1
B
Bomin Zhang 已提交
166
		}
B
Bomin Zhang 已提交
167
		totalWeight = len(cases)
B
Bomin Zhang 已提交
168 169 170 171 172
	}

	return nil
}

173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194
func loadTestCase(pathOrSQL string) error {
	if f, e := os.Open(pathOrSQL); e == nil {
		defer f.Close()
		return loadTestCaseFromFile(f)
	}

	pathOrSQL = strings.TrimSpace(pathOrSQL)
	if strings.ToLower(pathOrSQL[:6]) != "select" {
		return fmt.Errorf("'%s' is not a valid file or SQL statement", pathOrSQL)
	}

	cases = append(cases, testCase{
		isQuery: true,
		Weight:  1,
		numArgs: 0,
		SQL:     pathOrSQL,
	})
	totalWeight = 1

	return nil
}

B
Bomin Zhang 已提交
195 196 197 198 199 200 201 202 203
func selectTestCase() *testCase {
	sum, target := 0, rand.Intn(totalWeight)
	var c *testCase
	for i := 0; i < len(cases); i++ {
		c = &cases[i]
		sum += c.Weight
		if sum > target {
			break
		}
B
Bomin Zhang 已提交
204
	}
B
Bomin Zhang 已提交
205
	return c
B
Bomin Zhang 已提交
206 207 208
}

func runTest() {
B
Bomin Zhang 已提交
209
	defer wgTest.Done()
B
Bomin Zhang 已提交
210
	db, e := sql.Open("taosSql", fmt.Sprintf("%s:%s@tcp(%s:%v)/%s", user, password, host, port, database))
B
Bomin Zhang 已提交
211 212 213 214 215 216 217
	if e != nil {
		fmt.Printf("failed to connect to database: %s\n", e.Error())
		return
	}
	defer db.Close()

	for atomic.LoadInt64(&shouldStop) == 0 {
B
Bomin Zhang 已提交
218 219
		c := selectTestCase()
		str := c.buildSql()
B
Bomin Zhang 已提交
220

B
Bomin Zhang 已提交
221 222
		start := time.Now()
		if c.isQuery {
B
Bomin Zhang 已提交
223 224 225 226 227 228 229 230 231 232 233 234
			var rows *sql.Rows
			if rows, e = db.Query(str); rows != nil {
				if fetch {
					for rows.Next() {
					}
				}
				rows.Close()
			}
		} else {
			_, e = db.Exec(str)
		}
		duration := time.Now().Sub(start).Microseconds()
B
Bomin Zhang 已提交
235

B
Bomin Zhang 已提交
236
		if e != nil {
B
Bomin Zhang 已提交
237 238 239
			if chLog != nil {
				chLog <- str + ": " + e.Error()
			}
B
Bomin Zhang 已提交
240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261
			atomic.AddInt64(&stat.failed, 1)
			atomic.AddInt64(&stat.failedDuration, duration)
		} else {
			atomic.AddInt64(&stat.succeeded, 1)
			atomic.AddInt64(&stat.succeededDuration, duration)
		}
	}
}

func getStatPrinter() func(tm time.Time) {
	var last statitics
	lastPrintAt := startAt

	return func(tm time.Time) {
		var current statitics

		current.succeeded = atomic.LoadInt64(&stat.succeeded)
		current.failed = atomic.LoadInt64(&stat.failed)
		current.succeededDuration = atomic.LoadInt64(&stat.succeededDuration)
		current.failedDuration = atomic.LoadInt64(&stat.failedDuration)

		seconds := int64(tm.Sub(startAt).Seconds())
B
Bomin Zhang 已提交
262
		format := "\033[47;30m %02v:%02v:%02v | TOTAL REQ | TOTAL TIME(us) | TOTAL AVG(us) | REQUEST |  TIME(us)  |  AVERAGE(us)  |\033[0m\n"
B
Bomin Zhang 已提交
263 264 265 266 267 268 269 270 271 272 273 274 275
		fmt.Printf(format, seconds/3600, seconds%3600/60, seconds%60)

		tr := current.succeeded + current.failed
		td := current.succeededDuration + current.failedDuration
		r := tr - last.succeeded - last.failed
		d := td - last.succeededDuration - last.failedDuration
		ta, a := 0.0, 0.0
		if tr > 0 {
			ta = float64(td) / float64(tr)
		}
		if r > 0 {
			a = float64(d) / float64(r)
		}
B
Bomin Zhang 已提交
276
		format = "    TOTAL | %9v | %14v | %13.2f | %7v | %10v | % 13.2f |\n"
B
Bomin Zhang 已提交
277 278 279 280 281 282 283 284 285 286 287 288 289
		fmt.Printf(format, tr, td, ta, r, d, a)

		tr = current.succeeded
		td = current.succeededDuration
		r = tr - last.succeeded
		d = td - last.succeededDuration
		ta, a = 0.0, 0.0
		if tr > 0 {
			ta = float64(td) / float64(tr)
		}
		if r > 0 {
			a = float64(d) / float64(r)
		}
B
Bomin Zhang 已提交
290
		format = "  SUCCESS | \033[32m%9v\033[0m | \033[32m%14v\033[0m | \033[32m%13.2f\033[0m | \033[32m%7v\033[0m | \033[32m%10v\033[0m | \033[32m%13.2f\033[0m |\n"
B
Bomin Zhang 已提交
291 292 293 294 295 296 297 298 299 300 301 302 303
		fmt.Printf(format, tr, td, ta, r, d, a)

		tr = current.failed
		td = current.failedDuration
		r = tr - last.failed
		d = td - last.failedDuration
		ta, a = 0.0, 0.0
		if tr > 0 {
			ta = float64(td) / float64(tr)
		}
		if r > 0 {
			a = float64(d) / float64(r)
		}
B
Bomin Zhang 已提交
304
		format = "     FAIL | \033[31m%9v\033[0m | \033[31m%14v\033[0m | \033[31m%13.2f\033[0m | \033[31m%7v\033[0m | \033[31m%10v\033[0m | \033[31m%13.2f\033[0m |\n"
B
Bomin Zhang 已提交
305 306 307 308 309 310 311
		fmt.Printf(format, tr, td, ta, r, d, a)

		last = current
		lastPrintAt = tm
	}
}

B
Bomin Zhang 已提交
312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337
func startLogger(path string) error {
	if len(path) == 0 {
		return nil
	}

	f, e := os.Create(path)
	if e != nil {
		return e
	}

	chLog = make(chan string, 100)
	wgLog.Add(1)
	go func() {
		for s := range chLog {
			if f != nil {
				f.WriteString(s)
				f.WriteString("\n")
			}
		}
		f.Close()
		wgLog.Done()
	}()

	return nil
}

B
Bomin Zhang 已提交
338
func main() {
B
Bomin Zhang 已提交
339
	var concurrency uint
B
Bomin Zhang 已提交
340
	var logPath string
B
Bomin Zhang 已提交
341 342 343 344 345 346 347
	flag.StringVar(&host, "h", "localhost", "host name or IP address of TDengine server")
	flag.UintVar(&port, "P", 0, "port (default 0)")
	flag.StringVar(&database, "d", "test", "database name")
	flag.StringVar(&user, "u", "root", "user name")
	flag.StringVar(&password, "p", "taosdata", "password")
	flag.BoolVar(&fetch, "f", true, "fetch result or not")
	flag.UintVar(&concurrency, "c", 4, "concurrency, number of goroutines for query")
B
Bomin Zhang 已提交
348
	flag.StringVar(&logPath, "l", "", "path of log file (default: no log)")
B
Bomin Zhang 已提交
349 350
	flag.Parse()

B
Bomin Zhang 已提交
351 352 353 354 355
	if e := startLogger(logPath); e != nil {
		fmt.Println("failed to open log file:", e.Error())
		return
	}

356 357 358
	pathOrSQL := flag.Arg(0)
	if len(pathOrSQL) == 0 {
		pathOrSQL = "cases.json"
B
Bomin Zhang 已提交
359
	}
360
	if e := loadTestCase(pathOrSQL); e != nil {
B
Bomin Zhang 已提交
361
		fmt.Println("failed to load test cases:", e.Error())
B
Bomin Zhang 已提交
362 363 364 365 366
		return
	}

	rand.Seed(time.Now().UnixNano())

B
Bomin Zhang 已提交
367
	fmt.Printf("\nSERVER: %s    DATABASE: %s    CONCURRENCY: %d    FETCH DATA: %v\n\n", host, database, concurrency, fetch)
B
Bomin Zhang 已提交
368 369 370 371 372

	startAt = time.Now()
	printStat := getStatPrinter()
	printStat(startAt)

B
Bomin Zhang 已提交
373
	for i := uint(0); i < concurrency; i++ {
B
Bomin Zhang 已提交
374
		wgTest.Add(1)
B
Bomin Zhang 已提交
375 376 377 378 379 380 381 382 383 384 385 386 387 388 389
		go runTest()
	}

	interrupt := make(chan os.Signal, 1)
	signal.Notify(interrupt, os.Interrupt)
	ticker := time.NewTicker(time.Second)

	fmt.Println("Ctrl + C to exit....\033[1A")

LOOP:
	for {
		select {
		case <-interrupt:
			break LOOP
		case tm := <-ticker.C:
B
Bomin Zhang 已提交
390
			fmt.Print("\033[4A")
B
Bomin Zhang 已提交
391 392 393 394 395 396
			printStat(tm)
		}
	}

	atomic.StoreInt64(&shouldStop, 1)
	fmt.Print("\033[100D'Ctrl + C' received, Waiting started query to stop...")
B
Bomin Zhang 已提交
397
	wgTest.Wait()
B
Bomin Zhang 已提交
398

B
Bomin Zhang 已提交
399 400 401 402 403
	if chLog != nil {
		close(chLog)
		wgLog.Wait()
	}
	fmt.Print("\033[4A\033[100D")
B
Bomin Zhang 已提交
404 405 406
	printStat(time.Now())
	fmt.Println()
}