-
Notifications
You must be signed in to change notification settings - Fork 6
/
postgis_helpers_test.go
84 lines (72 loc) · 2.14 KB
/
postgis_helpers_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
package tilenol
import (
"bytes"
"testing"
"time"
"github.com/DATA-DOG/go-sqlmock"
"github.com/stretchr/testify/assert"
"github.com/paulmach/orb"
"github.com/paulmach/orb/encoding/wkb"
)
const (
FakeSQL = "SELECT blah FROM doesnt.matter"
)
func TestRowsToMap(t *testing.T) {
db, mock, err := sqlmock.New()
assert.Nil(t, err, "Failed to create mock DB: %s", err)
cols := []string{"id", "height", "some_flag", "msg", "bmsg", "geometry", "timestamp", "empty"}
fakeRows := mock.NewRows(cols)
now := time.Now()
point := orb.Point{0, 1}
var pointWKB bytes.Buffer
enc := wkb.NewEncoder(&pointWKB)
encErr := enc.Encode(point)
assert.Nil(t, encErr, "Failed to encode point to WKB")
expectedRow := map[string]interface{}{
"id": int64(123),
"height": 1.23,
"some_flag": true,
"msg": "HELLO",
"bmsg": []byte("HOLA"),
"geometry": point,
"timestamp": now,
"empty": nil,
}
fakeRows.AddRow(
123,
1.23,
true,
"HELLO",
[]byte("HOLA"),
pointWKB.Bytes(),
now,
nil,
)
mock.ExpectQuery(FakeSQL).WillReturnRows(fakeRows)
rows, err := db.Query(FakeSQL)
assert.Nil(t, err, "Failed to run mock query: %s", err)
records, err := RowsToMaps(rows, "geometry")
assert.Nil(t, err, "Failed to map rows to a record map: %s", err)
assert.Len(t, records, 1, "Should only map one row to one output records")
actualRow := records[0]
assert.Len(t, actualRow, len(expectedRow), "Mapped record has fewer columns than expected")
for k, actual := range actualRow {
expected := expectedRow[k]
assert.Equal(t, expected, actual, "Invalid row to record mapping: %s => %v (expected = %v)", k, actual, expected)
}
}
func TestRowsToMapErr(t *testing.T) {
db, mock, mockErr := sqlmock.New()
assert.Nil(t, mockErr, "Failed to create mock DB: %s", mockErr)
cols := []string{"id", "geometry"}
fakeRows := mock.NewRows(cols)
fakeRows.AddRow(
123,
[]byte("INVALID GEOMETRY"),
)
mock.ExpectQuery(FakeSQL).WillReturnRows(fakeRows)
rows, sqlErr := db.Query(FakeSQL)
assert.Nil(t, sqlErr, "Failed to run mock query: %s", sqlErr)
_, err := RowsToMaps(rows, "geometry")
assert.NotNil(t, err, "Expected to fail decoding the geometry")
}