SqlInvokedFunctionTestUtils.java

/*
 * 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 com.facebook.presto.functionNamespace.testing;

import com.facebook.presto.common.CatalogSchemaName;
import com.facebook.presto.common.QualifiedObjectName;
import com.facebook.presto.spi.function.Parameter;
import com.facebook.presto.spi.function.RoutineCharacteristics;
import com.facebook.presto.spi.function.SqlInvokedFunction;
import com.google.common.collect.ImmutableList;

import static com.facebook.presto.common.type.StandardTypes.ARRAY;
import static com.facebook.presto.common.type.StandardTypes.BOOLEAN;
import static com.facebook.presto.common.type.StandardTypes.DOUBLE;
import static com.facebook.presto.common.type.StandardTypes.INTEGER;
import static com.facebook.presto.common.type.StandardTypes.VARCHAR;
import static com.facebook.presto.common.type.TypeSignature.parseTypeSignature;
import static com.facebook.presto.spi.function.FunctionVersion.notVersioned;
import static com.facebook.presto.spi.function.RoutineCharacteristics.Determinism.DETERMINISTIC;
import static com.facebook.presto.spi.function.RoutineCharacteristics.NullCallClause.RETURNS_NULL_ON_NULL_INPUT;

public class SqlInvokedFunctionTestUtils
{
    private SqlInvokedFunctionTestUtils()
    {
    }

    public static final String TEST_CATALOG = "unittest";
    public static final String TEST_SCHEMA = "memory";

    public static final QualifiedObjectName POWER_TOWER = QualifiedObjectName.valueOf(new CatalogSchemaName(TEST_CATALOG, TEST_SCHEMA), "power_tower");
    public static final QualifiedObjectName TANGENT = QualifiedObjectName.valueOf(new CatalogSchemaName(TEST_CATALOG, TEST_SCHEMA), "tangent");
    public static final QualifiedObjectName ABS = QualifiedObjectName.valueOf(new CatalogSchemaName(TEST_CATALOG, TEST_SCHEMA), "abs");
    public static final QualifiedObjectName REVERSE = QualifiedObjectName.valueOf(new CatalogSchemaName(TEST_CATALOG, TEST_SCHEMA), "reverse");
    public static final QualifiedObjectName BOOL_AND = QualifiedObjectName.valueOf(new CatalogSchemaName(TEST_CATALOG, TEST_SCHEMA), "bool_and");
    public static final QualifiedObjectName ARRAY_SUM = QualifiedObjectName.valueOf(new CatalogSchemaName(TEST_CATALOG, TEST_SCHEMA), "array_sum");

    public static final SqlInvokedFunction FUNCTION_ABS_INT = new SqlInvokedFunction(
            ABS,
            ImmutableList.of(new Parameter("x", parseTypeSignature(INTEGER))),
            parseTypeSignature(INTEGER),
            "abs",
            RoutineCharacteristics.builder().setDeterminism(DETERMINISTIC).setNullCallClause(RETURNS_NULL_ON_NULL_INPUT).build(),
            "RETURN abs(x)",
            notVersioned());

    public static final SqlInvokedFunction FUNCTION_REV_STRING = new SqlInvokedFunction(
            REVERSE,
            ImmutableList.of(new Parameter("x", parseTypeSignature(VARCHAR))),
            parseTypeSignature(VARCHAR),
            "reverse",
            RoutineCharacteristics.builder().setDeterminism(DETERMINISTIC).setNullCallClause(RETURNS_NULL_ON_NULL_INPUT).build(),
            "RETURN reverse(x)",
            notVersioned());

    public static final SqlInvokedFunction FUNCTION_BOOL_AND = new SqlInvokedFunction(
            BOOL_AND,
            ImmutableList.of(new Parameter("x", parseTypeSignature(BOOLEAN))),
            parseTypeSignature(BOOLEAN),
            "bool_and",
            RoutineCharacteristics.builder().setDeterminism(DETERMINISTIC).setNullCallClause(RETURNS_NULL_ON_NULL_INPUT).build(),
            "RETURN bool_and(x)",
            notVersioned());

    public static final SqlInvokedFunction FUNCTION_ARRAY_SUM = new SqlInvokedFunction(
            ARRAY_SUM,
            ImmutableList.of(new Parameter("x", parseTypeSignature(INTEGER))),
            parseTypeSignature(ARRAY),
            "array_sum",
            RoutineCharacteristics.builder().setDeterminism(DETERMINISTIC).setNullCallClause(RETURNS_NULL_ON_NULL_INPUT).build(),
            "RETURN array_sum(x)",
            notVersioned());

    public static final SqlInvokedFunction FUNCTION_POWER_TOWER_DOUBLE = new SqlInvokedFunction(
            POWER_TOWER,
            ImmutableList.of(new Parameter("x", parseTypeSignature(DOUBLE))),
            parseTypeSignature(DOUBLE),
            "power tower",
            RoutineCharacteristics.builder().setDeterminism(DETERMINISTIC).build(),
            "RETURN pow(x, x)",
            notVersioned());

    public static final SqlInvokedFunction FUNCTION_POWER_TOWER_DOUBLE_UPDATED = new SqlInvokedFunction(
            POWER_TOWER,
            ImmutableList.of(new Parameter("x", parseTypeSignature(DOUBLE))),
            parseTypeSignature(DOUBLE),
            "power tower",
            RoutineCharacteristics.builder().setDeterminism(DETERMINISTIC).setNullCallClause(RETURNS_NULL_ON_NULL_INPUT).build(),
            "RETURN pow(x, x)",
            notVersioned());

    public static final SqlInvokedFunction FUNCTION_POWER_TOWER_INT = new SqlInvokedFunction(
            POWER_TOWER,
            ImmutableList.of(new Parameter("x", parseTypeSignature(INTEGER))),
            parseTypeSignature(INTEGER),
            "power tower",
            RoutineCharacteristics.builder().setDeterminism(DETERMINISTIC).setNullCallClause(RETURNS_NULL_ON_NULL_INPUT).build(),
            "RETURN pow(x, x)",
            notVersioned());

    public static final SqlInvokedFunction FUNCTION_TANGENT = new SqlInvokedFunction(
            TANGENT,
            ImmutableList.of(new Parameter("x", parseTypeSignature(DOUBLE))),
            parseTypeSignature(DOUBLE),
            "tangent",
            RoutineCharacteristics.builder()
                    .setDeterminism(DETERMINISTIC)
                    .setNullCallClause(RETURNS_NULL_ON_NULL_INPUT)
                    .build(),
            "RETURN sin(x) / cos(x)",
            notVersioned());
}