Deveel.Data.Sql.Statements.CreateFunctionStringFormatTests.WithNoParameters C# (CSharp) Метод

        public static void WithNoParameters()
        {
            var body = new PlSqlBlockStatement();
            body.Declarations.Add(new DeclareVariableStatement("a", PrimitiveTypes.Integer()));
            body.Statements.Add(new AssignVariableStatement(SqlExpression.VariableReference("a"), SqlExpression.Constant(3)));
            body.Statements.Add(new ReturnStatement(SqlExpression.VariableReference("a")));
            var statement = new CreateFunctionStatement(ObjectName.Parse("SYS.func1"), PrimitiveTypes.Integer(), body);

            var sql = statement.ToString();
            var expected = new SqlStringBuilder();
            expected.Append("CREATE FUNCTION SYS.func1() ");
            expected.AppendLine("RETURN INTEGER IS");
            expected.AppendLine("  DECLARE");
            expected.AppendLine("    a INTEGER");
            expected.AppendLine("  BEGIN");
            expected.AppendLine("    :a := 3");
            expected.AppendLine("    RETURN :a");
            expected.Append("  END");

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