TheCodingMachine\TDBM\OrderByAnalyzerTest::testAnalyzeOrderBy()

Complexity

Conditions	1
Paths	1

Size

Total Lines	35
Code Lines	32

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function testAnalyzeOrderBy(): void
    {
        $analyzer = new OrderByAnalyzer(new VoidCache(), '');

The class Doctrine\Common\Cache\VoidCache has been deprecated: Deprecated without replacement in doctrine/cache 1.11. This class will be dropped in 2.0

        $results = $analyzer->analyzeOrderBy('`a`, b desc, rand() DESC, masc, mytable.mycol');

        $this->assertCount(5, $results);
        $this->assertEquals([
            'type' => 'colref',
            'table' => null,
            'column' => 'a',
            'direction' => 'ASC',
        ], $results[0]);
        $this->assertEquals([
            'type' => 'colref',
            'table' => null,
            'column' => 'b',
            'direction' => 'DESC',
        ], $results[1]);
        $this->assertEquals([
            'type' => 'expr',
            'expr' => 'rand()',
            'direction' => 'DESC',
        ], $results[2]);
        $this->assertEquals([
            'type' => 'colref',
            'table' => null,
            'column' => 'masc',
            'direction' => 'ASC',
        ], $results[3]);
        $this->assertEquals([
            'type' => 'colref',
            'table' => 'mytable',
            'column' => 'mycol',
            'direction' => 'ASC',
        ], $results[4]);
    }