SqlParser\Tests\Builder\CreateStatementTest::testBuilderTrigger PHP Method

    public function testBuilderTrigger()
    {
        $stmt = new CreateStatement();
        $stmt->options = new OptionsArray(array('TRIGGER'));
        $stmt->name = new Expression('ins_sum');
        $stmt->entityOptions = new OptionsArray(array('BEFORE', 'INSERT'));
        $stmt->table = new Expression('account');
        $stmt->body = 'SET @sum = @sum + NEW.amount';
        $this->assertEquals('CREATE TRIGGER ins_sum BEFORE INSERT ON account ' . 'FOR EACH ROW SET @sum = @sum + NEW.amount', $stmt->build());
    }