// Copyright 2024 Dolthub, Inc. // // 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 types import ( "github.com/dolthub/go-mysql-server/sql" "github.com/dolthub/doltgresql/postgres/parser/timeofday" "github.com/dolthub/doltgresql/postgres/parser/timetz" "github.com/dolthub/doltgresql/utils" "github.com/dolthub/doltgresql/core/id" ) // TimeTZ is the time with a time zone. Precision is unbounded. var TimeTZ = &DoltgresType{ ID: toInternal("timetz"), TypLength: int16(12), PassedByVal: true, TypType: TypeType_Base, TypCategory: TypeCategory_DateTimeTypes, IsPreferred: false, IsDefined: true, Delimiter: ",", RelID: id.Null, SubscriptFunc: toFuncID("-"), Elem: internalNullType, Array: internalNullType, InputFunc: toFuncID("timetz_in", toInternal("cstring"), toInternal("oid"), toInternal("int4")), OutputFunc: toFuncID("timetz_out", toInternal("timetz")), ReceiveFunc: toFuncID("timetz_recv", toInternal("internal"), toInternal("oid"), toInternal("int4")), SendFunc: toFuncID("timetz_send", toInternal("timetz")), ModInFunc: toFuncID("timetztypmodin", toInternal("_cstring")), ModOutFunc: toFuncID("timetztypmodout", toInternal("int4")), AnalyzeFunc: toFuncID("-"), Align: TypeAlignment_Double, Storage: TypeStorage_Plain, NotNull: false, BaseTypeType: internalNullType, TypMod: -1, NDims: 0, TypCollation: id.NullCollation, DefaulBin: "", Default: "", Acl: nil, Checks: nil, attTypMod: -1, CompareFunc: toFuncID("timetz_cmp", toInternal("timetz"), toInternal("timetz")), SerializationFunc: serializeTypeTimeTZ, DeserializationFunc: deserializeTypeTimeTZ, } // NewTimeTZType returns TimeTZ type with typmod set. // TODO: implement precision func NewTimeTZType(precision int32) (*DoltgresType, error) { typmod, err := GetTypmodFromTimePrecision(precision) if err != nil { return nil, err } newType := *TimeTZ.WithAttTypMod(typmod) return &newType, nil } // serializeTypeTimeTZ handles serialization from the standard representation to our serialized representation that is // written in Dolt. func serializeTypeTimeTZ(ctx *sql.Context, t *DoltgresType, val any) ([]byte, error) { v := val.(timetz.TimeTZ) writer := utils.NewWriter(12) writer.Int64(int64(v.TimeOfDay)) writer.Int32(v.OffsetSecs) return writer.Data(), nil } // deserializeTypeTimeTZ handles deserialization from the Dolt serialized format to our standard representation used by // expressions and nodes. func deserializeTypeTimeTZ(ctx *sql.Context, _ *DoltgresType, data []byte) (any, error) { if len(data) == 0 { return nil, nil } reader := utils.NewReader(data) tod := reader.Int64() offset := reader.Int32() return timetz.MakeTimeTZ(timeofday.TimeOfDay(tod), offset), nil }