123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168 |
- // 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 (
- "reflect"
- "testing"
- bq "google.golang.org/api/bigquery/v2"
- )
- func bqTableFieldSchema(desc, name, typ, mode string) *bq.TableFieldSchema {
- return &bq.TableFieldSchema{
- Description: desc,
- Name: name,
- Mode: mode,
- Type: typ,
- }
- }
- func fieldSchema(desc, name, typ string, repeated, required bool) *FieldSchema {
- return &FieldSchema{
- Description: desc,
- Name: name,
- Repeated: repeated,
- Required: required,
- Type: FieldType(typ),
- }
- }
- func TestSchemaConversion(t *testing.T) {
- testCases := []struct {
- schema Schema
- bqSchema *bq.TableSchema
- }{
- {
- // required
- bqSchema: &bq.TableSchema{
- Fields: []*bq.TableFieldSchema{
- bqTableFieldSchema("desc", "name", "STRING", "REQUIRED"),
- },
- },
- schema: Schema{
- fieldSchema("desc", "name", "STRING", false, true),
- },
- },
- {
- // repeated
- bqSchema: &bq.TableSchema{
- Fields: []*bq.TableFieldSchema{
- bqTableFieldSchema("desc", "name", "STRING", "REPEATED"),
- },
- },
- schema: Schema{
- fieldSchema("desc", "name", "STRING", true, false),
- },
- },
- {
- // nullable, string
- bqSchema: &bq.TableSchema{
- Fields: []*bq.TableFieldSchema{
- bqTableFieldSchema("desc", "name", "STRING", ""),
- },
- },
- schema: Schema{
- fieldSchema("desc", "name", "STRING", false, false),
- },
- },
- {
- // integer
- bqSchema: &bq.TableSchema{
- Fields: []*bq.TableFieldSchema{
- bqTableFieldSchema("desc", "name", "INTEGER", ""),
- },
- },
- schema: Schema{
- fieldSchema("desc", "name", "INTEGER", false, false),
- },
- },
- {
- // float
- bqSchema: &bq.TableSchema{
- Fields: []*bq.TableFieldSchema{
- bqTableFieldSchema("desc", "name", "FLOAT", ""),
- },
- },
- schema: Schema{
- fieldSchema("desc", "name", "FLOAT", false, false),
- },
- },
- {
- // boolean
- bqSchema: &bq.TableSchema{
- Fields: []*bq.TableFieldSchema{
- bqTableFieldSchema("desc", "name", "BOOLEAN", ""),
- },
- },
- schema: Schema{
- fieldSchema("desc", "name", "BOOLEAN", false, false),
- },
- },
- {
- // timestamp
- bqSchema: &bq.TableSchema{
- Fields: []*bq.TableFieldSchema{
- bqTableFieldSchema("desc", "name", "TIMESTAMP", ""),
- },
- },
- schema: Schema{
- fieldSchema("desc", "name", "TIMESTAMP", false, false),
- },
- },
- {
- // nested
- bqSchema: &bq.TableSchema{
- Fields: []*bq.TableFieldSchema{
- &bq.TableFieldSchema{
- Description: "An outer schema wrapping a nested schema",
- Name: "outer",
- Mode: "REQUIRED",
- Type: "RECORD",
- Fields: []*bq.TableFieldSchema{
- bqTableFieldSchema("inner field", "inner", "STRING", ""),
- },
- },
- },
- },
- schema: Schema{
- &FieldSchema{
- Description: "An outer schema wrapping a nested schema",
- Name: "outer",
- Required: true,
- Type: "RECORD",
- Schema: []*FieldSchema{
- &FieldSchema{
- Description: "inner field",
- Name: "inner",
- Type: "STRING",
- },
- },
- },
- },
- },
- }
- for _, tc := range testCases {
- bqSchema := tc.schema.asTableSchema()
- if !reflect.DeepEqual(bqSchema, tc.bqSchema) {
- t.Errorf("converting to TableSchema: got:\n%v\nwant:\n%v", bqSchema, tc.bqSchema)
- }
- schema := convertTableSchema(tc.bqSchema)
- if !reflect.DeepEqual(schema, tc.schema) {
- t.Errorf("converting to Schema: got:\n%v\nwant:\n%v", schema, tc.schema)
- }
- }
- }
|