OrderByAnalyzerTest::testExprWithAsc() - Code Metrics - thecodingmachine/tdbm - Measure and Improve Code Quality continuously with Scrutinizer

OrderByAnalyzerTest::testExprWithAsc() A
last analyzed 2025-08-27 09:41 UTC

↳ Parent: OrderByAnalyzerTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	11
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	8
dl	0
loc	11
rs	10
c	0
b	0
f	0
cc	1
nc	1
nop	0

<?php

declare(strict_types=1);

namespace TheCodingMachine\TDBM;

use Doctrine\Common\Cache\ArrayCache;
use Doctrine\Common\Cache\VoidCache;
use PHPUnit\Framework\TestCase;

class OrderByAnalyzerTest extends TestCase
{
    public function testAnalyzeOrderBy(): void
    {
        $analyzer = new OrderByAnalyzer(new VoidCache(), '');
        $analyzer = new OrderByAnalyzer(/** @scrutinizer ignore-deprecated */ new VoidCache(), '');
        $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]);
    }

    public function testExprWithAsc(): void
    {
        $analyzer = new OrderByAnalyzer(new VoidCache(), '');
        $analyzer = new OrderByAnalyzer(/** @scrutinizer ignore-deprecated */ new VoidCache(), '');
        $results = $analyzer->analyzeOrderBy('foodesc + barasc');

        $this->assertCount(1, $results);
        $this->assertEquals([
            'type' => 'expr',
            'expr' => 'foodesc + barasc',
            'direction' => 'ASC',
        ], $results[0]);
    }

    public function testCache(): void
    {
        $analyzer = new OrderByAnalyzer(new ArrayCache(), '');
        $analyzer = new OrderByAnalyzer(/** @scrutinizer ignore-deprecated */ new ArrayCache(), '');
        $results = $analyzer->analyzeOrderBy('foo');
        $results2 = $analyzer->analyzeOrderBy('foo');
        // For code coverage purpose
        $this->assertSame($results, $results2);
    }
}


thecodingmachine / tdbm

OrderByAnalyzerTest::testExprWithAsc() A last analyzed 2025-08-27 09:41 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

OrderByAnalyzerTest::testExprWithAsc() A
last analyzed 2025-08-27 09:41 UTC