| // Copyright 2015 Google Inc. All Rights Reserved. |
| // |
| // Licensed under the Apache License, Version 2.0 (the "License"); |
| // you may not use this file except in compliance with the License. |
| // You may obtain a copy of the License at |
| // |
| // http://www.apache.org/licenses/LICENSE-2.0 |
| // |
| // Unless required by applicable law or agreed to in writing, software |
| // distributed under the License is distributed on an "AS IS" BASIS, |
| // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| // See the License for the specific language governing permissions and |
| // limitations under the License. |
| |
| package bigquery |
| |
| import ( |
| "testing" |
| |
| "github.com/google/go-cmp/cmp" |
| |
| "cloud.google.com/go/internal/pretty" |
| "cloud.google.com/go/internal/testutil" |
| |
| "golang.org/x/net/context" |
| ) |
| |
| type testSaver struct { |
| ir *insertionRow |
| err error |
| } |
| |
| func (ts testSaver) Save() (map[string]Value, string, error) { |
| return ts.ir.Row, ts.ir.InsertID, ts.err |
| } |
| |
| func TestRejectsNonValueSavers(t *testing.T) { |
| client := &Client{projectID: "project-id"} |
| u := Uploader{t: client.Dataset("dataset-id").Table("table-id")} |
| inputs := []interface{}{ |
| 1, |
| []int{1, 2}, |
| []interface{}{ |
| testSaver{ir: &insertionRow{"a", map[string]Value{"one": 1}}}, |
| 1, |
| }, |
| StructSaver{}, |
| } |
| for _, in := range inputs { |
| if err := u.Put(context.Background(), in); err == nil { |
| t.Errorf("put value: %v; got nil, want error", in) |
| } |
| } |
| } |
| |
| type insertRowsRecorder struct { |
| rowBatches [][]*insertionRow |
| service |
| } |
| |
| func (irr *insertRowsRecorder) insertRows(ctx context.Context, projectID, datasetID, tableID string, rows []*insertionRow, conf *insertRowsConf) error { |
| irr.rowBatches = append(irr.rowBatches, rows) |
| return nil |
| } |
| |
| func TestInsertsData(t *testing.T) { |
| testCases := []struct { |
| data [][]*insertionRow |
| }{ |
| { |
| data: [][]*insertionRow{ |
| { |
| &insertionRow{"a", map[string]Value{"one": 1}}, |
| }, |
| }, |
| }, |
| { |
| |
| data: [][]*insertionRow{ |
| { |
| &insertionRow{"a", map[string]Value{"one": 1}}, |
| &insertionRow{"b", map[string]Value{"two": 2}}, |
| }, |
| }, |
| }, |
| { |
| |
| data: [][]*insertionRow{ |
| { |
| &insertionRow{"a", map[string]Value{"one": 1}}, |
| }, |
| { |
| &insertionRow{"b", map[string]Value{"two": 2}}, |
| }, |
| }, |
| }, |
| { |
| |
| data: [][]*insertionRow{ |
| { |
| &insertionRow{"a", map[string]Value{"one": 1}}, |
| &insertionRow{"b", map[string]Value{"two": 2}}, |
| }, |
| { |
| &insertionRow{"c", map[string]Value{"three": 3}}, |
| &insertionRow{"d", map[string]Value{"four": 4}}, |
| }, |
| }, |
| }, |
| } |
| for _, tc := range testCases { |
| irr := &insertRowsRecorder{} |
| client := &Client{ |
| projectID: "project-id", |
| service: irr, |
| } |
| u := client.Dataset("dataset-id").Table("table-id").Uploader() |
| for _, batch := range tc.data { |
| if len(batch) == 0 { |
| continue |
| } |
| var toUpload interface{} |
| if len(batch) == 1 { |
| toUpload = testSaver{ir: batch[0]} |
| } else { |
| savers := []testSaver{} |
| for _, row := range batch { |
| savers = append(savers, testSaver{ir: row}) |
| } |
| toUpload = savers |
| } |
| |
| err := u.Put(context.Background(), toUpload) |
| if err != nil { |
| t.Errorf("expected successful Put of ValueSaver; got: %v", err) |
| } |
| } |
| if got, want := irr.rowBatches, tc.data; !testutil.Equal(got, want) { |
| t.Errorf("got: %v, want: %v", got, want) |
| } |
| } |
| } |
| |
| type uploadOptionRecorder struct { |
| received *insertRowsConf |
| service |
| } |
| |
| func (u *uploadOptionRecorder) insertRows(ctx context.Context, projectID, datasetID, tableID string, rows []*insertionRow, conf *insertRowsConf) error { |
| u.received = conf |
| return nil |
| } |
| |
| func TestUploadOptionsPropagate(t *testing.T) { |
| // we don't care for the data in this testcase. |
| dummyData := testSaver{ir: &insertionRow{}} |
| recorder := new(uploadOptionRecorder) |
| c := &Client{service: recorder} |
| table := &Table{ |
| ProjectID: "project-id", |
| DatasetID: "dataset-id", |
| TableID: "table-id", |
| c: c, |
| } |
| |
| tests := [...]struct { |
| ul *Uploader |
| conf insertRowsConf |
| }{ |
| { |
| // test zero options lead to zero value for insertRowsConf |
| ul: table.Uploader(), |
| }, |
| { |
| ul: func() *Uploader { |
| u := table.Uploader() |
| u.TableTemplateSuffix = "suffix" |
| return u |
| }(), |
| conf: insertRowsConf{ |
| templateSuffix: "suffix", |
| }, |
| }, |
| { |
| ul: func() *Uploader { |
| u := table.Uploader() |
| u.IgnoreUnknownValues = true |
| return u |
| }(), |
| conf: insertRowsConf{ |
| ignoreUnknownValues: true, |
| }, |
| }, |
| { |
| ul: func() *Uploader { |
| u := table.Uploader() |
| u.SkipInvalidRows = true |
| return u |
| }(), |
| conf: insertRowsConf{ |
| skipInvalidRows: true, |
| }, |
| }, |
| { // multiple upload options combine |
| ul: func() *Uploader { |
| u := table.Uploader() |
| u.TableTemplateSuffix = "suffix" |
| u.IgnoreUnknownValues = true |
| u.SkipInvalidRows = true |
| return u |
| }(), |
| conf: insertRowsConf{ |
| templateSuffix: "suffix", |
| skipInvalidRows: true, |
| ignoreUnknownValues: true, |
| }, |
| }, |
| } |
| |
| for i, tc := range tests { |
| err := tc.ul.Put(context.Background(), dummyData) |
| if err != nil { |
| t.Fatalf("%d: expected successful Put of ValueSaver; got: %v", i, err) |
| } |
| |
| if recorder.received == nil { |
| t.Fatalf("%d: received no options at all!", i) |
| } |
| |
| want := tc.conf |
| got := *recorder.received |
| if got != want { |
| t.Errorf("%d: got %#v, want %#v, ul=%#v", i, got, want, tc.ul) |
| } |
| } |
| } |
| |
| func TestValueSavers(t *testing.T) { |
| ts := &testSaver{ir: &insertionRow{}} |
| type T struct{ I int } |
| schema, err := InferSchema(T{}) |
| if err != nil { |
| t.Fatal(err) |
| } |
| for _, test := range []struct { |
| in interface{} |
| want []ValueSaver |
| }{ |
| {ts, []ValueSaver{ts}}, |
| {T{I: 1}, []ValueSaver{&StructSaver{Schema: schema, Struct: T{I: 1}}}}, |
| {[]ValueSaver{ts, ts}, []ValueSaver{ts, ts}}, |
| {[]interface{}{ts, ts}, []ValueSaver{ts, ts}}, |
| {[]T{{I: 1}, {I: 2}}, []ValueSaver{ |
| &StructSaver{Schema: schema, Struct: T{I: 1}}, |
| &StructSaver{Schema: schema, Struct: T{I: 2}}, |
| }}, |
| {[]interface{}{T{I: 1}, &T{I: 2}}, []ValueSaver{ |
| &StructSaver{Schema: schema, Struct: T{I: 1}}, |
| &StructSaver{Schema: schema, Struct: &T{I: 2}}, |
| }}, |
| {&StructSaver{Struct: T{I: 3}, InsertID: "foo"}, |
| []ValueSaver{ |
| &StructSaver{Schema: schema, Struct: T{I: 3}, InsertID: "foo"}, |
| }}, |
| } { |
| got, err := valueSavers(test.in) |
| if err != nil { |
| t.Fatal(err) |
| } |
| if !testutil.Equal(got, test.want, cmp.AllowUnexported(testSaver{})) { |
| t.Errorf("%+v: got %v, want %v", test.in, pretty.Value(got), pretty.Value(test.want)) |
| } |
| // Make sure Save is successful. |
| for i, vs := range got { |
| _, _, err := vs.Save() |
| if err != nil { |
| t.Fatalf("%+v, #%d: got error %v, want nil", test.in, i, err) |
| } |
| } |
| } |
| } |