WhereTest

Complexity

Total Complexity

7

Size/Duplication

Total Lines	79
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	testAnd()	0	12	1
A	testAndIn()	0	5	1
A	testAndFields()	0	6	1
A	testAndIsNull()	0	13	1
A	testAndValue()	0	17	1
A	testConstructor()	0	5	1
A	testAndPredicate()	0	7	1

<?php

use PHPUnit\Framework\TestCase;
use HexMakina\Crudites\Grammar\Clause\Where;
use HexMakina\Crudites\Grammar\Predicate;

class WhereTest extends TestCase
{
    public function testConstructor()
    {
        $where = new Where();
        $this->assertInstanceOf(Where::class, $where);
        $this->assertEquals('', $where->__toString());
    }

    public function testAnd()
    {
        $where = new Where();
        $where->and('1 = 1');
        $this->assertEquals('WHERE 1 = 1', (string)$where);
        $this->assertEquals([], $where->bindings());


        $where = new Where();
        $where->and(new Predicate('1', '=', '1'));
        $this->assertEquals('WHERE 1 = 1', (string)$where);
        $this->assertEquals([], $where->bindings());
    }

    public function testAndPredicate()
    {
        $where = new Where();
        $this->assertEquals([], $where->bindings());

        $where->andPredicate((new Predicate(['table', 'field'], '='))->withValue(3));
        $this->assertEquals(['table_field' => 3], $where->bindings());
    }

    public function testAndIsNull()
    {
        $where = new Where();
        $where->andIsNull('expression');
        $this->assertEquals('WHERE expression IS NULL', (string)$where);

        $where = new Where();
        $where->andIsNull(['field']);
        $this->assertEquals('WHERE `field` IS NULL', (string)$where);

        $where = new Where();
        $where->andIsNull(['table', 'field']);
        $this->assertEquals('WHERE `table`.`field` IS NULL', (string)$where);
    }

    public function testAndFields()
    {
        $where = new Where();
        $where->andFields(['field' => 'value']);
        $this->assertEquals('WHERE `field` = :andFields_field', (string)$where);
        $this->assertEquals(['andFields_field' => 'value'], $where->bindings());
    }

    public function testAndIn()
    {
        $where = new Where();
        $where->andIn('field', ['value1', 'value2']);
        $this->assertEquals('WHERE field IN (:andIn_0,:andIn_1)', (string)$where);
    }

    public function testAndValue()
    {
        $where = new Where();
        
        $expression = 'expression + expression';
        $expected_bind_label = 'andValue_expression_bind_label';
        
        $where->andValue($expression, '>', 3, $expected_bind_label);
        $this->assertEquals('WHERE ' . $expression . ' > :' . $expected_bind_label, (string)$where);
        $this->assertEquals([$expected_bind_label => 3], $where->bindings());

        
        $where = new Where();
        
        $where->andValue(['field'], '>', 3);
        $this->assertEquals('WHERE `field` > :field', (string)$where);
        $this->assertEquals(['field' => 3], $where->bindings());
    }
}