801 lines
21 KiB
Go
801 lines
21 KiB
Go
|
// Copyright (c) 2011-2013, 'pq' Contributors Portions Copyright (C) 2011 Blake Mizerany. MIT license.
|
||
|
|
//
|
||
|
|
// Permission is hereby granted, free of charge, to any person obtaining
|
||
|
|
// a copy of this software and associated documentation files (the "Software"),
|
||
|
|
// to deal in the Software without restriction, including without limitation the
|
||
|
|
// rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
|
||
|
|
// copies of the Software, and to permit persons to whom the Software
|
||
|
|
// is furnished to do so, subject to the following conditions:
|
||
|
|
//
|
||
|
|
// The above copyright notice and this permission notice shall be included
|
||
|
|
// in all copies or substantial portions of the Software.
|
||
|
|
//
|
||
|
|
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED,
|
||
|
|
// INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A
|
||
|
|
// PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT
|
||
|
|
// HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
|
||
|
|
// OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE
|
||
|
|
// SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
|
||
|
|
|
||
|
|
package types
|
||
|
|
|
||
|
|
import (
|
||
|
|
"database/sql"
|
||
|
|
"database/sql/driver"
|
||
|
|
"math/rand"
|
||
|
|
"reflect"
|
||
|
|
"strings"
|
||
|
|
"testing"
|
||
|
|
)
|
||
|
|
|
||
|
|
func TestParseArray(t *testing.T) {
|
||
|
|
for _, tt := range []struct {
|
||
|
|
input string
|
||
|
|
delim string
|
||
|
|
dims []int
|
||
|
|
elems [][]byte
|
||
|
|
}{
|
||
|
|
{`{}`, `,`, nil, [][]byte{}},
|
||
|
|
{`{NULL}`, `,`, []int{1}, [][]byte{nil}},
|
||
|
|
{`{a}`, `,`, []int{1}, [][]byte{{'a'}}},
|
||
|
|
{`{a,b}`, `,`, []int{2}, [][]byte{{'a'}, {'b'}}},
|
||
|
|
{`{{a,b}}`, `,`, []int{1, 2}, [][]byte{{'a'}, {'b'}}},
|
||
|
|
{`{{a},{b}}`, `,`, []int{2, 1}, [][]byte{{'a'}, {'b'}}},
|
||
|
|
{`{{{a,b},{c,d},{e,f}}}`, `,`, []int{1, 3, 2}, [][]byte{
|
||
|
|
{'a'}, {'b'}, {'c'}, {'d'}, {'e'}, {'f'},
|
||
|
|
}},
|
||
|
|
{`{""}`, `,`, []int{1}, [][]byte{{}}},
|
||
|
|
{`{","}`, `,`, []int{1}, [][]byte{{','}}},
|
||
|
|
{`{",",","}`, `,`, []int{2}, [][]byte{{','}, {','}}},
|
||
|
|
{`{{",",","}}`, `,`, []int{1, 2}, [][]byte{{','}, {','}}},
|
||
|
|
{`{{","},{","}}`, `,`, []int{2, 1}, [][]byte{{','}, {','}}},
|
||
|
|
{`{{{",",","},{",",","},{",",","}}}`, `,`, []int{1, 3, 2}, [][]byte{
|
||
|
|
{','}, {','}, {','}, {','}, {','}, {','},
|
||
|
|
}},
|
||
|
|
{`{"\"}"}`, `,`, []int{1}, [][]byte{{'"', '}'}}},
|
||
|
|
{`{"\"","\""}`, `,`, []int{2}, [][]byte{{'"'}, {'"'}}},
|
||
|
|
{`{{"\"","\""}}`, `,`, []int{1, 2}, [][]byte{{'"'}, {'"'}}},
|
||
|
|
{`{{"\""},{"\""}}`, `,`, []int{2, 1}, [][]byte{{'"'}, {'"'}}},
|
||
|
|
{`{{{"\"","\""},{"\"","\""},{"\"","\""}}}`, `,`, []int{1, 3, 2}, [][]byte{
|
||
|
|
{'"'}, {'"'}, {'"'}, {'"'}, {'"'}, {'"'},
|
||
|
|
}},
|
||
|
|
{`{axyzb}`, `xyz`, []int{2}, [][]byte{{'a'}, {'b'}}},
|
||
|
|
} {
|
||
|
|
dims, elems, err := parseArray([]byte(tt.input), []byte(tt.delim))
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for %q, got %q", tt.input, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(dims, tt.dims) {
|
||
|
|
t.Errorf("Expected %v dimensions for %q, got %v", tt.dims, tt.input, dims)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(elems, tt.elems) {
|
||
|
|
t.Errorf("Expected %v elements for %q, got %v", tt.elems, tt.input, elems)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestParseArrayError(t *testing.T) {
|
||
|
|
for _, tt := range []struct {
|
||
|
|
input, err string
|
||
|
|
}{
|
||
|
|
{``, "expected '{' at offset 0"},
|
||
|
|
{`x`, "expected '{' at offset 0"},
|
||
|
|
{`}`, "expected '{' at offset 0"},
|
||
|
|
{`{`, "expected '}' at offset 1"},
|
||
|
|
{`{{}`, "expected '}' at offset 3"},
|
||
|
|
{`{}}`, "unexpected '}' at offset 2"},
|
||
|
|
{`{,}`, "unexpected ',' at offset 1"},
|
||
|
|
{`{,x}`, "unexpected ',' at offset 1"},
|
||
|
|
{`{x,}`, "unexpected '}' at offset 3"},
|
||
|
|
{`{""x}`, "unexpected 'x' at offset 3"},
|
||
|
|
{`{{a},{b,c}}`, "multidimensional arrays must have elements with matching dimensions"},
|
||
|
|
} {
|
||
|
|
_, _, err := parseArray([]byte(tt.input), []byte{','})
|
||
|
|
|
||
|
|
if err == nil {
|
||
|
|
t.Fatalf("Expected error for %q, got none", tt.input)
|
||
|
|
}
|
||
|
|
if !strings.Contains(err.Error(), tt.err) {
|
||
|
|
t.Errorf("Expected error to contain %q for %q, got %q", tt.err, tt.input, err)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestArrayScanner(t *testing.T) {
|
||
|
|
var s sql.Scanner
|
||
|
|
|
||
|
|
s = Array(&[]bool{})
|
||
|
|
if _, ok := s.(*BoolArray); !ok {
|
||
|
|
t.Errorf("Expected *BoolArray, got %T", s)
|
||
|
|
}
|
||
|
|
|
||
|
|
s = Array(&[]float64{})
|
||
|
|
if _, ok := s.(*Float64Array); !ok {
|
||
|
|
t.Errorf("Expected *Float64Array, got %T", s)
|
||
|
|
}
|
||
|
|
|
||
|
|
s = Array(&[]int64{})
|
||
|
|
if _, ok := s.(*Int64Array); !ok {
|
||
|
|
t.Errorf("Expected *Int64Array, got %T", s)
|
||
|
|
}
|
||
|
|
|
||
|
|
s = Array(&[]string{})
|
||
|
|
if _, ok := s.(*StringArray); !ok {
|
||
|
|
t.Errorf("Expected *StringArray, got %T", s)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestArrayValuer(t *testing.T) {
|
||
|
|
var v driver.Valuer
|
||
|
|
|
||
|
|
v = Array([]bool{})
|
||
|
|
if _, ok := v.(*BoolArray); !ok {
|
||
|
|
t.Errorf("Expected *BoolArray, got %T", v)
|
||
|
|
}
|
||
|
|
|
||
|
|
v = Array([]float64{})
|
||
|
|
if _, ok := v.(*Float64Array); !ok {
|
||
|
|
t.Errorf("Expected *Float64Array, got %T", v)
|
||
|
|
}
|
||
|
|
|
||
|
|
v = Array([]int64{})
|
||
|
|
if _, ok := v.(*Int64Array); !ok {
|
||
|
|
t.Errorf("Expected *Int64Array, got %T", v)
|
||
|
|
}
|
||
|
|
|
||
|
|
v = Array([]string{})
|
||
|
|
if _, ok := v.(*StringArray); !ok {
|
||
|
|
t.Errorf("Expected *StringArray, got %T", v)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestBoolArrayScanUnsupported(t *testing.T) {
|
||
|
|
var arr BoolArray
|
||
|
|
err := arr.Scan(1)
|
||
|
|
|
||
|
|
if err == nil {
|
||
|
|
t.Fatal("Expected error when scanning from int")
|
||
|
|
}
|
||
|
|
if !strings.Contains(err.Error(), "int to BoolArray") {
|
||
|
|
t.Errorf("Expected type to be mentioned when scanning, got %q", err)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
var BoolArrayStringTests = []struct {
|
||
|
|
str string
|
||
|
|
arr BoolArray
|
||
|
|
}{
|
||
|
|
{`{}`, BoolArray{}},
|
||
|
|
{`{t}`, BoolArray{true}},
|
||
|
|
{`{f,t}`, BoolArray{false, true}},
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestBoolArrayScanBytes(t *testing.T) {
|
||
|
|
for _, tt := range BoolArrayStringTests {
|
||
|
|
bytes := []byte(tt.str)
|
||
|
|
arr := BoolArray{true, true, true}
|
||
|
|
err := arr.Scan(bytes)
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for %q, got %v", bytes, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(arr, tt.arr) {
|
||
|
|
t.Errorf("Expected %+v for %q, got %+v", tt.arr, bytes, arr)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func BenchmarkBoolArrayScanBytes(b *testing.B) {
|
||
|
|
var a BoolArray
|
||
|
|
var x interface{} = []byte(`{t,f,t,f,t,f,t,f,t,f}`)
|
||
|
|
|
||
|
|
for i := 0; i < b.N; i++ {
|
||
|
|
a = BoolArray{}
|
||
|
|
a.Scan(x)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestBoolArrayScanString(t *testing.T) {
|
||
|
|
for _, tt := range BoolArrayStringTests {
|
||
|
|
arr := BoolArray{true, true, true}
|
||
|
|
err := arr.Scan(tt.str)
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for %q, got %v", tt.str, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(arr, tt.arr) {
|
||
|
|
t.Errorf("Expected %+v for %q, got %+v", tt.arr, tt.str, arr)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestBoolArrayScanError(t *testing.T) {
|
||
|
|
for _, tt := range []struct {
|
||
|
|
input, err string
|
||
|
|
}{
|
||
|
|
{``, "unable to parse array"},
|
||
|
|
{`{`, "unable to parse array"},
|
||
|
|
{`{{t},{f}}`, "cannot convert ARRAY[2][1] to BoolArray"},
|
||
|
|
{`{NULL}`, `could not parse boolean array index 0: invalid boolean ""`},
|
||
|
|
{`{a}`, `could not parse boolean array index 0: invalid boolean "a"`},
|
||
|
|
{`{t,b}`, `could not parse boolean array index 1: invalid boolean "b"`},
|
||
|
|
{`{t,f,cd}`, `could not parse boolean array index 2: invalid boolean "cd"`},
|
||
|
|
} {
|
||
|
|
arr := BoolArray{true, true, true}
|
||
|
|
err := arr.Scan(tt.input)
|
||
|
|
|
||
|
|
if err == nil {
|
||
|
|
t.Fatalf("Expected error for %q, got none", tt.input)
|
||
|
|
}
|
||
|
|
if !strings.Contains(err.Error(), tt.err) {
|
||
|
|
t.Errorf("Expected error to contain %q for %q, got %q", tt.err, tt.input, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(arr, BoolArray{true, true, true}) {
|
||
|
|
t.Errorf("Expected destination not to change for %q, got %+v", tt.input, arr)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestBoolArrayValue(t *testing.T) {
|
||
|
|
result, err := BoolArray(nil).Value()
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for nil, got %v", err)
|
||
|
|
}
|
||
|
|
if result != nil {
|
||
|
|
t.Errorf("Expected nil, got %q", result)
|
||
|
|
}
|
||
|
|
|
||
|
|
result, err = BoolArray([]bool{}).Value()
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for empty, got %v", err)
|
||
|
|
}
|
||
|
|
if expected := `{}`; !reflect.DeepEqual(result, expected) {
|
||
|
|
t.Errorf("Expected empty, got %q", result)
|
||
|
|
}
|
||
|
|
|
||
|
|
result, err = BoolArray([]bool{false, true, false}).Value()
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error, got %v", err)
|
||
|
|
}
|
||
|
|
if expected := `{f,t,f}`; !reflect.DeepEqual(result, expected) {
|
||
|
|
t.Errorf("Expected %q, got %q", expected, result)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func BenchmarkBoolArrayValue(b *testing.B) {
|
||
|
|
rand.Seed(1)
|
||
|
|
x := make([]bool, 10)
|
||
|
|
for i := 0; i < len(x); i++ {
|
||
|
|
x[i] = rand.Intn(2) == 0
|
||
|
|
}
|
||
|
|
a := BoolArray(x)
|
||
|
|
|
||
|
|
for i := 0; i < b.N; i++ {
|
||
|
|
a.Value()
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestBytesArrayScanUnsupported(t *testing.T) {
|
||
|
|
var arr BytesArray
|
||
|
|
err := arr.Scan(1)
|
||
|
|
|
||
|
|
if err == nil {
|
||
|
|
t.Fatal("Expected error when scanning from int")
|
||
|
|
}
|
||
|
|
if !strings.Contains(err.Error(), "int to BytesArray") {
|
||
|
|
t.Errorf("Expected type to be mentioned when scanning, got %q", err)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
var BytesArrayStringTests = []struct {
|
||
|
|
str string
|
||
|
|
arr BytesArray
|
||
|
|
}{
|
||
|
|
{`{}`, BytesArray{}},
|
||
|
|
{`{NULL}`, BytesArray{nil}},
|
||
|
|
{`{"\\xfeff"}`, BytesArray{{'\xFE', '\xFF'}}},
|
||
|
|
{`{"\\xdead","\\xbeef"}`, BytesArray{{'\xDE', '\xAD'}, {'\xBE', '\xEF'}}},
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestBytesArrayScanBytes(t *testing.T) {
|
||
|
|
for _, tt := range BytesArrayStringTests {
|
||
|
|
bytes := []byte(tt.str)
|
||
|
|
arr := BytesArray{{2}, {6}, {0, 0}}
|
||
|
|
err := arr.Scan(bytes)
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for %q, got %v", bytes, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(arr, tt.arr) {
|
||
|
|
t.Errorf("Expected %+v for %q, got %+v", tt.arr, bytes, arr)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func BenchmarkBytesArrayScanBytes(b *testing.B) {
|
||
|
|
var a BytesArray
|
||
|
|
var x interface{} = []byte(`{"\\xfe","\\xff","\\xdead","\\xbeef","\\xfe","\\xff","\\xdead","\\xbeef","\\xfe","\\xff"}`)
|
||
|
|
|
||
|
|
for i := 0; i < b.N; i++ {
|
||
|
|
a = BytesArray{}
|
||
|
|
a.Scan(x)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestBytesArrayScanString(t *testing.T) {
|
||
|
|
for _, tt := range BytesArrayStringTests {
|
||
|
|
arr := BytesArray{{2}, {6}, {0, 0}}
|
||
|
|
err := arr.Scan(tt.str)
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for %q, got %v", tt.str, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(arr, tt.arr) {
|
||
|
|
t.Errorf("Expected %+v for %q, got %+v", tt.arr, tt.str, arr)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestBytesArrayScanError(t *testing.T) {
|
||
|
|
for _, tt := range []struct {
|
||
|
|
input, err string
|
||
|
|
}{
|
||
|
|
{``, "unable to parse array"},
|
||
|
|
{`{`, "unable to parse array"},
|
||
|
|
{`{{"\\xfeff"},{"\\xbeef"}}`, "cannot convert ARRAY[2][1] to BytesArray"},
|
||
|
|
{`{"\\abc"}`, "could not parse bytea array index 0: could not parse bytea value"},
|
||
|
|
} {
|
||
|
|
arr := BytesArray{{2}, {6}, {0, 0}}
|
||
|
|
err := arr.Scan(tt.input)
|
||
|
|
|
||
|
|
if err == nil {
|
||
|
|
t.Fatalf("Expected error for %q, got none", tt.input)
|
||
|
|
}
|
||
|
|
if !strings.Contains(err.Error(), tt.err) {
|
||
|
|
t.Errorf("Expected error to contain %q for %q, got %q", tt.err, tt.input, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(arr, BytesArray{{2}, {6}, {0, 0}}) {
|
||
|
|
t.Errorf("Expected destination not to change for %q, got %+v", tt.input, arr)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestBytesArrayValue(t *testing.T) {
|
||
|
|
result, err := BytesArray(nil).Value()
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for nil, got %v", err)
|
||
|
|
}
|
||
|
|
if result != nil {
|
||
|
|
t.Errorf("Expected nil, got %q", result)
|
||
|
|
}
|
||
|
|
|
||
|
|
result, err = BytesArray([][]byte{}).Value()
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for empty, got %v", err)
|
||
|
|
}
|
||
|
|
if expected := `{}`; !reflect.DeepEqual(result, expected) {
|
||
|
|
t.Errorf("Expected empty, got %q", result)
|
||
|
|
}
|
||
|
|
|
||
|
|
result, err = BytesArray([][]byte{{'\xDE', '\xAD', '\xBE', '\xEF'}, {'\xFE', '\xFF'}, {}}).Value()
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error, got %v", err)
|
||
|
|
}
|
||
|
|
if expected := `{"\\xdeadbeef","\\xfeff","\\x"}`; !reflect.DeepEqual(result, expected) {
|
||
|
|
t.Errorf("Expected %q, got %q", expected, result)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func BenchmarkBytesArrayValue(b *testing.B) {
|
||
|
|
rand.Seed(1)
|
||
|
|
x := make([][]byte, 10)
|
||
|
|
for i := 0; i < len(x); i++ {
|
||
|
|
x[i] = make([]byte, len(x))
|
||
|
|
for j := 0; j < len(x); j++ {
|
||
|
|
x[i][j] = byte(rand.Int())
|
||
|
|
}
|
||
|
|
}
|
||
|
|
a := BytesArray(x)
|
||
|
|
|
||
|
|
for i := 0; i < b.N; i++ {
|
||
|
|
a.Value()
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestFloat64ArrayScanUnsupported(t *testing.T) {
|
||
|
|
var arr Float64Array
|
||
|
|
err := arr.Scan(true)
|
||
|
|
|
||
|
|
if err == nil {
|
||
|
|
t.Fatal("Expected error when scanning from bool")
|
||
|
|
}
|
||
|
|
if !strings.Contains(err.Error(), "bool to Float64Array") {
|
||
|
|
t.Errorf("Expected type to be mentioned when scanning, got %q", err)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
var Float64ArrayStringTests = []struct {
|
||
|
|
str string
|
||
|
|
arr Float64Array
|
||
|
|
}{
|
||
|
|
{`{}`, Float64Array{}},
|
||
|
|
{`{1.2}`, Float64Array{1.2}},
|
||
|
|
{`{3.456,7.89}`, Float64Array{3.456, 7.89}},
|
||
|
|
{`{3,1,2}`, Float64Array{3, 1, 2}},
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestFloat64ArrayScanBytes(t *testing.T) {
|
||
|
|
for _, tt := range Float64ArrayStringTests {
|
||
|
|
bytes := []byte(tt.str)
|
||
|
|
arr := Float64Array{5, 5, 5}
|
||
|
|
err := arr.Scan(bytes)
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for %q, got %v", bytes, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(arr, tt.arr) {
|
||
|
|
t.Errorf("Expected %+v for %q, got %+v", tt.arr, bytes, arr)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func BenchmarkFloat64ArrayScanBytes(b *testing.B) {
|
||
|
|
var a Float64Array
|
||
|
|
var x interface{} = []byte(`{1.2,3.4,5.6,7.8,9.01,2.34,5.67,8.90,1.234,5.678}`)
|
||
|
|
|
||
|
|
for i := 0; i < b.N; i++ {
|
||
|
|
a = Float64Array{}
|
||
|
|
a.Scan(x)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestFloat64ArrayScanString(t *testing.T) {
|
||
|
|
for _, tt := range Float64ArrayStringTests {
|
||
|
|
arr := Float64Array{5, 5, 5}
|
||
|
|
err := arr.Scan(tt.str)
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for %q, got %v", tt.str, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(arr, tt.arr) {
|
||
|
|
t.Errorf("Expected %+v for %q, got %+v", tt.arr, tt.str, arr)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestFloat64ArrayScanError(t *testing.T) {
|
||
|
|
for _, tt := range []struct {
|
||
|
|
input, err string
|
||
|
|
}{
|
||
|
|
{``, "unable to parse array"},
|
||
|
|
{`{`, "unable to parse array"},
|
||
|
|
{`{{5.6},{7.8}}`, "cannot convert ARRAY[2][1] to Float64Array"},
|
||
|
|
{`{NULL}`, "parsing array element index 0:"},
|
||
|
|
{`{a}`, "parsing array element index 0:"},
|
||
|
|
{`{5.6,a}`, "parsing array element index 1:"},
|
||
|
|
{`{5.6,7.8,a}`, "parsing array element index 2:"},
|
||
|
|
} {
|
||
|
|
arr := Float64Array{5, 5, 5}
|
||
|
|
err := arr.Scan(tt.input)
|
||
|
|
|
||
|
|
if err == nil {
|
||
|
|
t.Fatalf("Expected error for %q, got none", tt.input)
|
||
|
|
}
|
||
|
|
if !strings.Contains(err.Error(), tt.err) {
|
||
|
|
t.Errorf("Expected error to contain %q for %q, got %q", tt.err, tt.input, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(arr, Float64Array{5, 5, 5}) {
|
||
|
|
t.Errorf("Expected destination not to change for %q, got %+v", tt.input, arr)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestFloat64ArrayValue(t *testing.T) {
|
||
|
|
result, err := Float64Array(nil).Value()
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for nil, got %v", err)
|
||
|
|
}
|
||
|
|
if result != nil {
|
||
|
|
t.Errorf("Expected nil, got %q", result)
|
||
|
|
}
|
||
|
|
|
||
|
|
result, err = Float64Array([]float64{}).Value()
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for empty, got %v", err)
|
||
|
|
}
|
||
|
|
if expected := `{}`; !reflect.DeepEqual(result, expected) {
|
||
|
|
t.Errorf("Expected empty, got %q", result)
|
||
|
|
}
|
||
|
|
|
||
|
|
result, err = Float64Array([]float64{1.2, 3.4, 5.6}).Value()
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error, got %v", err)
|
||
|
|
}
|
||
|
|
if expected := `{1.2,3.4,5.6}`; !reflect.DeepEqual(result, expected) {
|
||
|
|
t.Errorf("Expected %q, got %q", expected, result)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func BenchmarkFloat64ArrayValue(b *testing.B) {
|
||
|
|
rand.Seed(1)
|
||
|
|
x := make([]float64, 10)
|
||
|
|
for i := 0; i < len(x); i++ {
|
||
|
|
x[i] = rand.NormFloat64()
|
||
|
|
}
|
||
|
|
a := Float64Array(x)
|
||
|
|
|
||
|
|
for i := 0; i < b.N; i++ {
|
||
|
|
a.Value()
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestInt64ArrayScanUnsupported(t *testing.T) {
|
||
|
|
var arr Int64Array
|
||
|
|
err := arr.Scan(true)
|
||
|
|
|
||
|
|
if err == nil {
|
||
|
|
t.Fatal("Expected error when scanning from bool")
|
||
|
|
}
|
||
|
|
if !strings.Contains(err.Error(), "bool to Int64Array") {
|
||
|
|
t.Errorf("Expected type to be mentioned when scanning, got %q", err)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
var Int64ArrayStringTests = []struct {
|
||
|
|
str string
|
||
|
|
arr Int64Array
|
||
|
|
}{
|
||
|
|
{`{}`, Int64Array{}},
|
||
|
|
{`{12}`, Int64Array{12}},
|
||
|
|
{`{345,678}`, Int64Array{345, 678}},
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestInt64ArrayScanBytes(t *testing.T) {
|
||
|
|
for _, tt := range Int64ArrayStringTests {
|
||
|
|
bytes := []byte(tt.str)
|
||
|
|
arr := Int64Array{5, 5, 5}
|
||
|
|
err := arr.Scan(bytes)
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for %q, got %v", bytes, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(arr, tt.arr) {
|
||
|
|
t.Errorf("Expected %+v for %q, got %+v", tt.arr, bytes, arr)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func BenchmarkInt64ArrayScanBytes(b *testing.B) {
|
||
|
|
var a Int64Array
|
||
|
|
var x interface{} = []byte(`{1,2,3,4,5,6,7,8,9,0}`)
|
||
|
|
|
||
|
|
for i := 0; i < b.N; i++ {
|
||
|
|
a = Int64Array{}
|
||
|
|
a.Scan(x)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestInt64ArrayScanString(t *testing.T) {
|
||
|
|
for _, tt := range Int64ArrayStringTests {
|
||
|
|
arr := Int64Array{5, 5, 5}
|
||
|
|
err := arr.Scan(tt.str)
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for %q, got %v", tt.str, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(arr, tt.arr) {
|
||
|
|
t.Errorf("Expected %+v for %q, got %+v", tt.arr, tt.str, arr)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestInt64ArrayScanError(t *testing.T) {
|
||
|
|
for _, tt := range []struct {
|
||
|
|
input, err string
|
||
|
|
}{
|
||
|
|
{``, "unable to parse array"},
|
||
|
|
{`{`, "unable to parse array"},
|
||
|
|
{`{{5},{6}}`, "cannot convert ARRAY[2][1] to Int64Array"},
|
||
|
|
{`{NULL}`, "parsing array element index 0:"},
|
||
|
|
{`{a}`, "parsing array element index 0:"},
|
||
|
|
{`{5,a}`, "parsing array element index 1:"},
|
||
|
|
{`{5,6,a}`, "parsing array element index 2:"},
|
||
|
|
} {
|
||
|
|
arr := Int64Array{5, 5, 5}
|
||
|
|
err := arr.Scan(tt.input)
|
||
|
|
|
||
|
|
if err == nil {
|
||
|
|
t.Fatalf("Expected error for %q, got none", tt.input)
|
||
|
|
}
|
||
|
|
if !strings.Contains(err.Error(), tt.err) {
|
||
|
|
t.Errorf("Expected error to contain %q for %q, got %q", tt.err, tt.input, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(arr, Int64Array{5, 5, 5}) {
|
||
|
|
t.Errorf("Expected destination not to change for %q, got %+v", tt.input, arr)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestInt64ArrayValue(t *testing.T) {
|
||
|
|
result, err := Int64Array(nil).Value()
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for nil, got %v", err)
|
||
|
|
}
|
||
|
|
if result != nil {
|
||
|
|
t.Errorf("Expected nil, got %q", result)
|
||
|
|
}
|
||
|
|
|
||
|
|
result, err = Int64Array([]int64{}).Value()
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for empty, got %v", err)
|
||
|
|
}
|
||
|
|
if expected := `{}`; !reflect.DeepEqual(result, expected) {
|
||
|
|
t.Errorf("Expected empty, got %q", result)
|
||
|
|
}
|
||
|
|
|
||
|
|
result, err = Int64Array([]int64{1, 2, 3}).Value()
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error, got %v", err)
|
||
|
|
}
|
||
|
|
if expected := `{1,2,3}`; !reflect.DeepEqual(result, expected) {
|
||
|
|
t.Errorf("Expected %q, got %q", expected, result)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func BenchmarkInt64ArrayValue(b *testing.B) {
|
||
|
|
rand.Seed(1)
|
||
|
|
x := make([]int64, 10)
|
||
|
|
for i := 0; i < len(x); i++ {
|
||
|
|
x[i] = rand.Int63()
|
||
|
|
}
|
||
|
|
a := Int64Array(x)
|
||
|
|
|
||
|
|
for i := 0; i < b.N; i++ {
|
||
|
|
a.Value()
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestStringArrayScanUnsupported(t *testing.T) {
|
||
|
|
var arr StringArray
|
||
|
|
err := arr.Scan(true)
|
||
|
|
|
||
|
|
if err == nil {
|
||
|
|
t.Fatal("Expected error when scanning from bool")
|
||
|
|
}
|
||
|
|
if !strings.Contains(err.Error(), "bool to StringArray") {
|
||
|
|
t.Errorf("Expected type to be mentioned when scanning, got %q", err)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
var StringArrayStringTests = []struct {
|
||
|
|
str string
|
||
|
|
arr StringArray
|
||
|
|
}{
|
||
|
|
{`{}`, StringArray{}},
|
||
|
|
{`{t}`, StringArray{"t"}},
|
||
|
|
{`{f,1}`, StringArray{"f", "1"}},
|
||
|
|
{`{"a\\b","c d",","}`, StringArray{"a\\b", "c d", ","}},
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestStringArrayScanBytes(t *testing.T) {
|
||
|
|
for _, tt := range StringArrayStringTests {
|
||
|
|
bytes := []byte(tt.str)
|
||
|
|
arr := StringArray{"x", "x", "x"}
|
||
|
|
err := arr.Scan(bytes)
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for %q, got %v", bytes, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(arr, tt.arr) {
|
||
|
|
t.Errorf("Expected %+v for %q, got %+v", tt.arr, bytes, arr)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func BenchmarkStringArrayScanBytes(b *testing.B) {
|
||
|
|
var a StringArray
|
||
|
|
var x interface{} = []byte(`{a,b,c,d,e,f,g,h,i,j}`)
|
||
|
|
var y interface{} = []byte(`{"\a","\b","\c","\d","\e","\f","\g","\h","\i","\j"}`)
|
||
|
|
|
||
|
|
for i := 0; i < b.N; i++ {
|
||
|
|
a = StringArray{}
|
||
|
|
a.Scan(x)
|
||
|
|
a = StringArray{}
|
||
|
|
a.Scan(y)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestStringArrayScanString(t *testing.T) {
|
||
|
|
for _, tt := range StringArrayStringTests {
|
||
|
|
arr := StringArray{"x", "x", "x"}
|
||
|
|
err := arr.Scan(tt.str)
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for %q, got %v", tt.str, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(arr, tt.arr) {
|
||
|
|
t.Errorf("Expected %+v for %q, got %+v", tt.arr, tt.str, arr)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestStringArrayScanError(t *testing.T) {
|
||
|
|
for _, tt := range []struct {
|
||
|
|
input, err string
|
||
|
|
}{
|
||
|
|
{``, "unable to parse array"},
|
||
|
|
{`{`, "unable to parse array"},
|
||
|
|
{`{{a},{b}}`, "cannot convert ARRAY[2][1] to StringArray"},
|
||
|
|
{`{NULL}`, "parsing array element index 0: cannot convert nil to string"},
|
||
|
|
{`{a,NULL}`, "parsing array element index 1: cannot convert nil to string"},
|
||
|
|
{`{a,b,NULL}`, "parsing array element index 2: cannot convert nil to string"},
|
||
|
|
} {
|
||
|
|
arr := StringArray{"x", "x", "x"}
|
||
|
|
err := arr.Scan(tt.input)
|
||
|
|
|
||
|
|
if err == nil {
|
||
|
|
t.Fatalf("Expected error for %q, got none", tt.input)
|
||
|
|
}
|
||
|
|
if !strings.Contains(err.Error(), tt.err) {
|
||
|
|
t.Errorf("Expected error to contain %q for %q, got %q", tt.err, tt.input, err)
|
||
|
|
}
|
||
|
|
if !reflect.DeepEqual(arr, StringArray{"x", "x", "x"}) {
|
||
|
|
t.Errorf("Expected destination not to change for %q, got %+v", tt.input, arr)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func TestStringArrayValue(t *testing.T) {
|
||
|
|
result, err := StringArray(nil).Value()
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for nil, got %v", err)
|
||
|
|
}
|
||
|
|
if result != nil {
|
||
|
|
t.Errorf("Expected nil, got %q", result)
|
||
|
|
}
|
||
|
|
|
||
|
|
result, err = StringArray([]string{}).Value()
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error for empty, got %v", err)
|
||
|
|
}
|
||
|
|
if expected := `{}`; !reflect.DeepEqual(result, expected) {
|
||
|
|
t.Errorf("Expected empty, got %q", result)
|
||
|
|
}
|
||
|
|
|
||
|
|
result, err = StringArray([]string{`a`, `\b`, `c"`, `d,e`}).Value()
|
||
|
|
|
||
|
|
if err != nil {
|
||
|
|
t.Fatalf("Expected no error, got %v", err)
|
||
|
|
}
|
||
|
|
if expected := `{"a","\\b","c\"","d,e"}`; !reflect.DeepEqual(result, expected) {
|
||
|
|
t.Errorf("Expected %q, got %q", expected, result)
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
func BenchmarkStringArrayValue(b *testing.B) {
|
||
|
|
x := make([]string, 10)
|
||
|
|
for i := 0; i < len(x); i++ {
|
||
|
|
x[i] = strings.Repeat(`abc"def\ghi`, 5)
|
||
|
|
}
|
||
|
|
a := StringArray(x)
|
||
|
|
|
||
|
|
for i := 0; i < b.N; i++ {
|
||
|
|
a.Value()
|
||
|
|
}
|
||
|
|
}
|