MCP Toolbox for Databases

// Copyright 2025 Google LLC // // 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 bigquerycommon import ( "math/big" "reflect" "testing" ) func TestNormalizeValue(t *testing.T) { tests := []struct { name string input any expected any }{ { name: "big.Rat 1/3 (NUMERIC scale 9)", input: new(big.Rat).SetFrac64(1, 3), // 0.33333333333... expected: "0.33333333333333333333333333333333333333", // FloatString(38) }, { name: "big.Rat 19/2 (9.5)", input: new(big.Rat).SetFrac64(19, 2), expected: "9.5", }, { name: "big.Rat 12341/10 (1234.1)", input: new(big.Rat).SetFrac64(12341, 10), expected: "1234.1", }, { name: "big.Rat 10/1 (10)", input: new(big.Rat).SetFrac64(10, 1), expected: "10", }, { name: "string", input: "hello", expected: "hello", }, { name: "int", input: 123, expected: 123, }, { name: "nested slice of big.Rat", input: []any{ new(big.Rat).SetFrac64(19, 2), new(big.Rat).SetFrac64(1, 4), }, expected: []any{"9.5", "0.25"}, }, { name: "nested map of big.Rat", input: map[string]any{ "val1": new(big.Rat).SetFrac64(19, 2), "val2": new(big.Rat).SetFrac64(1, 2), }, expected: map[string]any{ "val1": "9.5", "val2": "0.5", }, }, { name: "complex nested structure", input: map[string]any{ "list": []any{ map[string]any{ "rat": new(big.Rat).SetFrac64(3, 2), }, }, }, expected: map[string]any{ "list": []any{ map[string]any{ "rat": "1.5", }, }, }, }, { name: "slice of *big.Rat", input: []*big.Rat{ new(big.Rat).SetFrac64(19, 2), new(big.Rat).SetFrac64(1, 4), }, expected: []any{"9.5", "0.25"}, }, { name: "slice of strings", input: []string{"a", "b"}, expected: []any{"a", "b"}, }, { name: "byte slice (BYTES)", input: []byte("hello"), expected: []byte("hello"), }, } for _, tt := range tests { t.Run(tt.name, func(t *testing.T) { got := NormalizeValue(tt.input) if !reflect.DeepEqual(got, tt.expected) { t.Errorf("NormalizeValue() = %v, want %v", got, tt.expected) } }) } }