Deveel.Data.CreateFunctionTests.SimpleReturn C# (CSharp) Method

        public void SimpleReturn()
        {
            var body = new PlSqlBlockStatement();

            body.Declarations.Add(new DeclareVariableStatement("a", PrimitiveTypes.Integer()));
            body.Statements.Add(new ReturnStatement(SqlExpression.VariableReference("a")));

            var funName = ObjectName.Parse("APP.fun1");
            AdminQuery.CreateFunction(funName, PrimitiveTypes.Numeric(), body);

            var exists = AdminQuery.Access().RoutineExists(funName);

            Assert.IsTrue(exists);

            var function = AdminQuery.Access().GetObject(DbObjectType.Routine, funName);
            Assert.IsNotNull(function);
            Assert.IsInstanceOf<PlSqlFunction>(function);

            var userFunction = (PlSqlFunction) function;
            Assert.IsNotNull(userFunction.Body);
        }