C# (CSharp) Deveel.Data.Sql.Statements DropFunctionStatement Examples

Example #1

 protected virtual SqlStatement VisitDropFunction(DropFunctionStatement statement)
 {
     return(new DropFunctionStatement(statement.FunctionName)
     {
         IfExists = statement.IfExists
     });
 }

Example #2

File: DropStringFormatTests.cs Project: deveel/deveeldb

        public static void DropFunction_IfExists()
        {
            var statement = new DropFunctionStatement(ObjectName.Parse("APP.func1"), true);

            var sql = statement.ToString();
            var expected = "DROP FUNCTION IF EXISTS APP.func1";

            Assert.AreEqual(expected, sql);
        }

Example #3

File: DropStringFormatTests.cs Project: svg-useful-backup/deveeldb

        public static void DropFunction_IfExists()
        {
            var statement = new DropFunctionStatement(ObjectName.Parse("APP.func1"), true);

            var sql      = statement.ToString();
            var expected = "DROP FUNCTION IF EXISTS APP.func1";

            Assert.AreEqual(expected, sql);
        }

Example #4

File: StatementVisitor.cs Project: deveel/deveeldb

 protected virtual SqlStatement VisitDropFunction(DropFunctionStatement statement)
 {
     return new DropFunctionStatement(statement.FunctionName) {
         IfExists = statement.IfExists
     };
 }