Deveel.Data.TriggerTests.CreateTriggers C# (CSharp) Method

        private void CreateTriggers(IQuery query, ObjectName tableName)
        {
            var triggerName = ObjectName.Parse("APP.trigger1");
            var eventTime = TriggerEventTime.Before;
            var eventType = TriggerEventType.Insert | TriggerEventType.Update;
            var body = new PlSqlBlockStatement();
            body.Declarations.Add(new DeclareVariableStatement("a", PrimitiveTypes.Integer()));
            body.Statements.Add(new AssignVariableStatement(SqlExpression.VariableReference("a"), SqlExpression.Constant(33)));
            var triggerInfo = new PlSqlTriggerInfo(triggerName, tableName, eventTime, eventType, body);
            query.Access().CreateObject(triggerInfo);
        }