Exemplos de Deveel.Data.Sql.Statements CreateExternalFunctionStatement em C# (CSharp)

Exemplo n.º 1

 protected virtual SqlStatement VisitCreateExternFunction(CreateExternalFunctionStatement statement)
 {
     return(new CreateExternalFunctionStatement(statement.FunctionName, statement.ReturnType, statement.Parameters,
                                                statement.ExternalReference)
     {
         ReplaceIfExists = statement.ReplaceIfExists
     });
 }

Exemplo n.º 2

Arquivo: CreateFunctionStringFormatTests.cs Projeto: deveel/deveeldb

        public static void ExternalWithNoArguments()
        {
            var statement = new CreateExternalFunctionStatement(ObjectName.Parse("SYS.ext_func2"), PrimitiveTypes.String(), "Deveel.Data.ExtFunctions.Func1()");

            var sql = statement.ToString();
            var expected = new StringBuilder();
            expected.Append("CREATE EXTERNAL FUNCTION SYS.ext_func2() ");
            expected.AppendLine("RETURN STRING IS");
            expected.Append("  LANGUAGE DOTNET NAME 'Deveel.Data.ExtFunctions.Func1()'");

            Assert.AreEqual(expected.ToString(), sql);
        }

Exemplo n.º 3

        public static void ExternalWithNoArguments()
        {
            var statement = new CreateExternalFunctionStatement(ObjectName.Parse("SYS.ext_func2"), PrimitiveTypes.String(), "Deveel.Data.ExtFunctions.Func1()");

            var sql      = statement.ToString();
            var expected = new StringBuilder();

            expected.Append("CREATE EXTERNAL FUNCTION SYS.ext_func2() ");
            expected.AppendLine("RETURN STRING IS");
            expected.Append("  LANGUAGE DOTNET NAME 'Deveel.Data.ExtFunctions.Func1()'");

            Assert.AreEqual(expected.ToString(), sql);
        }

Exemplo n.º 4

Arquivo: StatementVisitor.cs Projeto: deveel/deveeldb

 protected virtual SqlStatement VisitCreateExternFunction(CreateExternalFunctionStatement statement)
 {
     return new CreateExternalFunctionStatement(statement.FunctionName, statement.ReturnType, statement.Parameters,
         statement.ExternalReference) {
             ReplaceIfExists = statement.ReplaceIfExists
         };
 }