-
Notifications
You must be signed in to change notification settings - Fork 0
/
sqlreader_test.go
51 lines (45 loc) · 1.25 KB
/
sqlreader_test.go
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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
package gofSQL
import (
"reflect"
"testing"
)
func TestParseFile(t *testing.T) {
tests := []struct {
name string
args string
want Queries
}{
{name: "Empty", args: "testfiles/test_empty.sql"},
{name: "Complex", args: "testfiles/test_complex.sql",
want: Queries{
"sample": "SELECT * FROM dummy;",
"yet_another_query": "SELECT column_name(s) FROM table_name WHERE column_name operator ALL (SELECT column_name FROM table_name WHERE condition);",
},
},
}
for _, tt := range tests {
t.Run(tt.name, func(t *testing.T) {
if got, _ := ParseFile(tt.args); reflect.DeepEqual(got, tt.want) {
t.Errorf("expected: %v, got: %v", tt.want, got)
}
})
}
}
var queries Queries
func benchmarkParseFile(file string, b *testing.B) {
for i := 0; i < b.N; i++ {
queries, _ = ParseFile(file)
}
}
func BenchmarkParseFile10Rows(b *testing.B) {
benchmarkParseFile("benchfiles/bench_10-rows.sql", b)
}
func BenchmarkParseFile10000Rows(b *testing.B) {
benchmarkParseFile("benchfiles/bench_10000-rows.sql", b)
}
func BenchmarkParseFile50000Rows(b *testing.B) {
benchmarkParseFile("benchfiles/bench_50000-rows.sql", b)
}
func BenchmarkParseFile10000RowsSkip(b *testing.B) {
benchmarkParseFile("benchfiles/bench_10000-rows-skip.sql", b)
}