/
builder_test.go
63 lines (47 loc) · 1.56 KB
/
builder_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
package postgres_backend
import (
"github.com/straumur/straumur"
"testing"
"time"
)
func TestWriteArray(t *testing.T) {
const expected = "foo @> ARRAY[$1, $2, $3]::text[]"
args := []interface{}{}
nextParam, s := writeArray(1, &args, "foo", []string{"a", "b", "c"})
if s != expected {
t.Fatalf("Expected %s, got %s", expected, s)
}
if nextParam != 4 {
t.Fatalf("Expected nextParam to be 4, got %d", nextParam)
}
}
func TestQueryBuilder(t *testing.T) {
const expected = `select * from event where key in ($1, $2) and origin = $3 and entities @> ARRAY[$4, $5]::text[] order by created desc;`
expectedArgs := []interface{}{"foo.bar", "bar.foo", "mysystem", "c/1", "c/2"}
q := straumur.Query{}
q.Origin = "mysystem"
q.Entities = []string{"c/1", "c/2"}
q.Key = "foo.bar OR bar.foo"
s, args := buildSelectQuery(q)
if s != expected {
t.Fatalf("Expected %s, got %s", expected, s)
}
if len(args) != len(expectedArgs) {
t.Fatalf("Expected %+v, got %+v", expectedArgs, args)
}
}
func TestDateRangeBuilder(t *testing.T) {
const expected = `select * from event where key in ($1) and created >= $2 and created < $3 order by created desc;`
q := straumur.Query{}
q.Key = "somekey"
q.From = time.Date(2013, time.September, 20, 9, 1, 45, 0, time.UTC)
q.To = time.Date(2013, time.September, 20, 9, 1, 47, 0, time.UTC)
expectedArgs := []interface{}{q.Key, q.From, q.To}
s, args := buildSelectQuery(q)
if s != expected {
t.Fatalf("Expected %s, got %s", expected, s)
}
if len(args) != len(expectedArgs) {
t.Fatalf("Expected %+v, got %+v", expectedArgs, args)
}
}