Doctrine\Tests\DBAL\Query\Expression\CompositeExpressionTest

Complexity

Total Complexity

4

Size/Duplication

Total Lines	94
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes	1
Bugs	0	Features	1

4 Methods

Rating	Name	Duplication	Size	Complexity
A	testCount()	0	10	1
A	testCompositeUsageAndGeneration()	0	6	1
A	provideDataForConvertToString()	0	47	1
A	testAdd()	0	22	1

<?php

namespace Doctrine\Tests\DBAL\Query\Expression;

use Doctrine\DBAL\Query\Expression\CompositeExpression;

/**
 * @group DBAL-12
 */
class CompositeExpressionTest extends \Doctrine\Tests\DbalTestCase
{
    public function testCount()
    {
        $expr = new CompositeExpression(CompositeExpression::TYPE_OR, array('u.group_id = 1'));

        $this->assertEquals(1, count($expr));

        $expr->add('u.group_id = 2');

        $this->assertEquals(2, count($expr));
    }

    public function testAdd()
    {
        $expr = new CompositeExpression(CompositeExpression::TYPE_OR, array('u.group_id = 1'));

        $this->assertCount(1, $expr);

        $expr->add(new CompositeExpression(CompositeExpression::TYPE_AND, array()));

        $this->assertCount(1, $expr);

        $expr->add(new CompositeExpression(CompositeExpression::TYPE_OR, array('u.user_id = 1')));

        $this->assertCount(2, $expr);

        $expr->add(null);

        $this->assertCount(2, $expr);

        $expr->add('u.user_id = 1');

        $this->assertCount(3, $expr);
    }

    /**
     * @dataProvider provideDataForConvertToString
     */
    public function testCompositeUsageAndGeneration($type, $parts, $expects)
    {
        $expr = new CompositeExpression($type, $parts);

        $this->assertEquals($expects, (string) $expr);
    }

    public function provideDataForConvertToString()
    {
        return array(
            array(
                CompositeExpression::TYPE_AND,
                array('u.user = 1'),
                'u.user = 1'
            ),
            array(
                CompositeExpression::TYPE_AND,
                array('u.user = 1', 'u.group_id = 1'),
                '(u.user = 1) AND (u.group_id = 1)'
            ),
            array(
                CompositeExpression::TYPE_OR,
                array('u.user = 1'),
                'u.user = 1'
            ),
            array(
                CompositeExpression::TYPE_OR,
                array('u.group_id = 1', 'u.group_id = 2'),
                '(u.group_id = 1) OR (u.group_id = 2)'
            ),
            array(
                CompositeExpression::TYPE_AND,
                array(
                    'u.user = 1',
                    new CompositeExpression(
                        CompositeExpression::TYPE_OR,
                        array('u.group_id = 1', 'u.group_id = 2')
                    )
                ),
                '(u.user = 1) AND ((u.group_id = 1) OR (u.group_id = 2))'
            ),
            array(
                CompositeExpression::TYPE_OR,
                array(
                    'u.group_id = 1',
                    new CompositeExpression(
                        CompositeExpression::TYPE_AND,
                        array('u.user = 1', 'u.group_id = 2')
                    )
                ),
                '(u.group_id = 1) OR ((u.user = 1) AND (u.group_id = 2))'
            ),
        );
    }
}