dolthub--doltgresql/server/functions/interval.go

// 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 functions

import (
	"github.com/dolthub/go-mysql-server/sql"
	"github.com/jackc/pgtype"

	"github.com/dolthub/doltgresql/utils"

	"github.com/dolthub/doltgresql/postgres/parser/duration"
	"github.com/dolthub/doltgresql/postgres/parser/sem/tree"
	"github.com/dolthub/doltgresql/server/functions/framework"
	pgtypes "github.com/dolthub/doltgresql/server/types"
)

// initInterval registers the functions to the catalog.
func initInterval() {
	framework.RegisterFunction(interval_in)
	framework.RegisterFunction(interval_out)
	framework.RegisterFunction(interval_recv)
	framework.RegisterFunction(interval_send)
	framework.RegisterFunction(intervaltypmodin)
	framework.RegisterFunction(intervaltypmodout)
	framework.RegisterFunction(interval_cmp)
}

// interval_in represents the PostgreSQL function of interval type IO input.
var interval_in = framework.Function3{
	Name:       "interval_in",
	Return:     pgtypes.Interval,
	Parameters: [3]*pgtypes.DoltgresType{pgtypes.Cstring, pgtypes.Oid, pgtypes.Int32},
	Strict:     true,
	Callable: func(ctx *sql.Context, _ [4]*pgtypes.DoltgresType, val1, val2, val3 any) (any, error) {
		input := val1.(string)
		//oid := val2.(id.Id)
		//typmod := val3.(int32)
		dInterval, err := tree.ParseDInterval(input)
		if err != nil {
			return nil, err
		}
		return dInterval.Duration, nil
	},
}

// interval_out represents the PostgreSQL function of interval type IO output.
var interval_out = framework.Function1{
	Name:       "interval_out",
	Return:     pgtypes.Cstring,
	Parameters: [1]*pgtypes.DoltgresType{pgtypes.Interval},
	Strict:     true,
	Callable: func(ctx *sql.Context, t [2]*pgtypes.DoltgresType, val any) (any, error) {
		return val.(duration.Duration).String(), nil
	},
}

// interval_recv represents the PostgreSQL function of interval type IO receive.
var interval_recv = framework.Function3{
	Name:       "interval_recv",
	Return:     pgtypes.Interval,
	Parameters: [3]*pgtypes.DoltgresType{pgtypes.Internal, pgtypes.Oid, pgtypes.Int32},
	Strict:     true,
	Callable: func(ctx *sql.Context, _ [4]*pgtypes.DoltgresType, val1, val2, val3 any) (any, error) {
		data := val1.([]byte)
		if data == nil {
			return nil, nil
		}
		var out pgtype.Interval
		err := out.DecodeBinary(nil, data)
		if err != nil {
			return nil, err
		}
		return duration.MakeDuration(out.Microseconds*1000, int64(out.Days), int64(out.Months)), nil
	},
}

// interval_send represents the PostgreSQL function of interval type IO send.
var interval_send = framework.Function1{
	Name:       "interval_send",
	Return:     pgtypes.Bytea,
	Parameters: [1]*pgtypes.DoltgresType{pgtypes.Interval},
	Strict:     true,
	Callable: func(ctx *sql.Context, _ [2]*pgtypes.DoltgresType, val any) (any, error) {
		dur := val.(duration.Duration)
		writer := utils.NewWireWriter()
		writer.WriteInt64(dur.Nanos() / 1000)
		writer.WriteInt32(int32(dur.Days))
		writer.WriteInt32(int32(dur.Months))
		return writer.BufferData(), nil
	},
}

// intervaltypmodin represents the PostgreSQL function of interval type IO typmod input.
var intervaltypmodin = framework.Function1{
	Name:       "intervaltypmodin",
	Return:     pgtypes.Int32,
	Parameters: [1]*pgtypes.DoltgresType{pgtypes.CstringArray},
	Strict:     true,
	Callable: func(ctx *sql.Context, _ [2]*pgtypes.DoltgresType, val any) (any, error) {
		// TODO: implement interval fields and precision
		return int32(0), nil
	},
}

// intervaltypmodout represents the PostgreSQL function of interval type IO typmod output.
var intervaltypmodout = framework.Function1{
	Name:       "intervaltypmodout",
	Return:     pgtypes.Cstring,
	Parameters: [1]*pgtypes.DoltgresType{pgtypes.Int32},
	Strict:     true,
	Callable: func(ctx *sql.Context, _ [2]*pgtypes.DoltgresType, val any) (any, error) {
		// TODO: implement interval fields and precision
		return "", nil
	},
}

// interval_cmp represents the PostgreSQL function of interval type compare.
var interval_cmp = framework.Function2{
	Name:       "interval_cmp",
	Return:     pgtypes.Int32,
	Parameters: [2]*pgtypes.DoltgresType{pgtypes.Interval, pgtypes.Interval},
	Strict:     true,
	Callable: func(ctx *sql.Context, _ [3]*pgtypes.DoltgresType, val1, val2 any) (any, error) {
		ab := val1.(duration.Duration)
		bb := val2.(duration.Duration)
		return int32(ab.Compare(bb)), nil
	},
}