Deveel.Data.CreateTriggerTests.PlSqlTrigger C# (CSharp) Method

        public void PlSqlTrigger()
        {
            var body = new PlSqlBlockStatement();
            body.Statements.Add(new CallStatement(ObjectName.Parse("system.output"), new[] {
                new InvokeArgument(SqlExpression.Constant("One row was inserted"))
            }));
            var triggerName = new ObjectName("trigger1");
            var tableName = ObjectName.Parse("APP.test_table");

            AdminQuery.CreateTrigger(triggerName, tableName, body, TriggerEventTime.After, TriggerEventType.Insert);

            var exists = AdminQuery.Access().TriggerExists(ObjectName.Parse("APP.trigger1"));

            Assert.IsTrue(exists);
        }