DeveelDB  20151217
complete SQL database system, primarly developed for .NET/Mono frameworks
Static Public Member Functions | List of all members
Deveel.Data.Sql.Parser.PlSqlBlockTests Class Reference

Static Public Member Functions

static void ParseCreateSimpleTrigger ()
 

Detailed Description

Definition at line 21 of file PlSqlBlockTests.cs.

Member Function Documentation

static void Deveel.Data.Sql.Parser.PlSqlBlockTests.ParseCreateSimpleTrigger ( )
inlinestatic

Definition at line 23 of file PlSqlBlockTests.cs.

23  {
24  const string sql = @"CREATE OR REPLACE TRIGGER test_trigger BEFORE INSERT ON test_table FOR EACH ROW
25  DECLARE
26  a BOOLEAN NOT NULL;
27  BEGIN
28  SELECT INTO a FROM table2 WHERE b = 22;
29  END";
30 
31  SqlParseResult result = null;
32  Assert.DoesNotThrow(() => result = SqlParsers.Default.Parse(sql));
33  Assert.IsNotNull(result);
34  Assert.IsFalse(result.HasErrors);
35  }

The documentation for this class was generated from the following file: