forked from rqlite/sql
-
Notifications
You must be signed in to change notification settings - Fork 0
/
rewriter_test.go
97 lines (90 loc) · 2.12 KB
/
rewriter_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
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
package sql_test
import (
"regexp"
"strings"
"testing"
"github.com/rqlite/sql"
)
func Test_Rewriter(t *testing.T) {
for i, tt := range []struct {
in string
exp string
rewriteRand bool
randFound bool
}{
{
in: `INSERT INTO foo(col1) VALUES (random())`,
exp: `INSERT INTO "foo" \("col1"\) VALUES \(random\(\)\)`,
rewriteRand: false,
randFound: false,
},
{
in: `INSERT INTO foo(col1) VALUES (random())`,
exp: `INSERT INTO \"foo\" \("col1"\) VALUES \(-?[0-9]+\)`,
rewriteRand: true,
randFound: true,
},
{
in: `INSERT INTO "names" VALUES (RANDOM(), 'bob', '123-45-678')`,
exp: `INSERT INTO "names" VALUES \(-?[0-9]+, 'bob', '123-45-678'\)`,
rewriteRand: true,
randFound: true,
},
{
in: `SELECT * FROM foo ORDER BY random()`,
exp: `SELECT \* FROM "foo" ORDER BY random\(\)`,
rewriteRand: true,
randFound: false,
},
{
in: `SELECT random()`,
exp: `SELECT -?[0-9]+`,
rewriteRand: true,
randFound: true,
},
{
in: `SELECT abs(random())`,
exp: `SELECT abs\(random\(\)\)`,
rewriteRand: false,
randFound: false,
},
{
in: `SELECT abs(random())`,
exp: `SELECT abs\(-?[0-9]+\)`,
rewriteRand: true,
randFound: true,
},
{
in: `SELECT random() + 1`,
exp: `SELECT -?[0-9]+ \+ 1`,
rewriteRand: true,
randFound: true,
},
{
in: `SELECT "v" FROM "foo"`,
exp: `SELECT "v" FROM "foo"`,
rewriteRand: true,
randFound: false,
},
} {
rw := &sql.Rewriter{
RewriteRand: tt.rewriteRand,
}
s, err := sql.NewParser(strings.NewReader(tt.in)).ParseStatement()
if err != nil {
t.Fatal(err)
}
s, f, err := rw.Do(s)
if err != nil {
t.Fatal(err)
}
match := regexp.MustCompile(tt.exp)
rendered := s.String()
if !match.MatchString(rendered) {
t.Fatalf("test %d failed, exp: '%s', got: '%s'", i, tt.exp, rendered)
}
if tt.randFound != f {
t.Fatalf("test %d randFound wrong, exp %t, got %t", i, tt.randFound, f)
}
}
}