GroupByTest

Complexity

Total Complexity

6

Size/Duplication

Total Lines	45
Duplicated Lines	0 %

Importance

Changes

0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	testAddString()	0	6	1
A	testConstructArray()	0	5	1
A	testConstructString()	0	5	1
A	testName()	0	5	1
A	testAddArray()	0	6	1
A	testStringAddArray()	0	6	1

<?php

use PHPUnit\Framework\TestCase;
use HexMakina\Crudites\Grammar\Clause\GroupBy;

class GroupByTest extends TestCase
{
    public function testName()
    {
        $selected = 'column1';
        $groupBy = new GroupBy($selected);
        $this->assertEquals(GroupBy::GROUP, $groupBy->name());
    }

    public function testConstructString()
    {
        $selected = 'column1';
        $groupBy = new GroupBy($selected);
        $this->assertEquals('GROUP BY column1', (string)$groupBy);
    }

    public function testConstructArray()
    {
        $selected = ['table', 'column'];
        $groupBy = new GroupBy($selected);
        $this->assertEquals('GROUP BY `table`.`column`', (string)$groupBy);
    }

    public function testAddString()
    {
        $selected = 'column1';
        $groupBy = new GroupBy($selected);
        $groupBy->add('column2');
        $this->assertEquals('GROUP BY column1,column2', (string)$groupBy);
    }

    public function testAddArray()
    {
        $selected = ['table', 'column'];
        $groupBy = new GroupBy($selected);
        $groupBy->add(['table', 'column2']);
        $this->assertEquals('GROUP BY `table`.`column`,`table`.`column2`', (string)$groupBy);
    }

    public function testStringAddArray()
    {
        $selected = 'column';
        $groupBy = new GroupBy($selected);
        $groupBy->add(['table', 'column2']);
        $this->assertEquals('GROUP BY column,`table`.`column2`', (string)$groupBy);
    }
}