GetTablesAliasTestTrait::testGetTablesAliasesFromString() - Code Metrics - Inspection of "Apply fixes from StyleCI" - yiisoft/db - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Branch — psalm-3 (1add06)

by Wilmer

created 2022-03-04 18:52 UTC

testGetTablesAliasesFromString() A

↳ Parent: GetTablesAliasTestTrait

Complexity

Conditions	1
Paths	1

Size

Total Lines	18
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	11
c	1
b	0
f	0
dl	0
loc	18
rs	9.9
cc	1
nc	1
nop	0

<?php

declare(strict_types=1);

namespace Yiisoft\Db\TestSupport;

use Yiisoft\Db\Exception\InvalidArgumentException;
use Yiisoft\Db\Expression\Expression;
use Yiisoft\Db\Query\Query;

trait GetTablesAliasTestTrait
{
    abstract protected function createQuery(): Query;

    public function testGetTableNamesIsFromArrayWithAlias(): void
    {
        $query = $this->createQuery();

        $query->from([
            'prf' => 'profile',
            '{{usr}}' => '{{user}}',
            '{{a b}}' => '{{c d}}',
            'post AS p',
        ]);

        $tables = $query->getTablesUsedInFrom();

        $this->assertEquals(
               assertEquals(
            [
                '{{prf}}' => '{{profile}}',
                '{{usr}}' => '{{user}}',
                '{{a b}}' => '{{c d}}',
                '{{p}}' => '{{post}}',
            ],
            $tables
        );
    }

    public function testGetTableNamesIsFromArrayWithoutAlias(): void
    {
        $query = $this->createQuery();

        $query->from([
            '{{profile}}',
            'user',
        ]);

        $tables = $query->getTablesUsedInFrom();

        $this->assertEquals(['{{profile}}' => '{{profile}}', '{{user}}' => '{{user}}'], $tables);
    }

    public function testGetTableNamesIsFromString(): void
    {
        $query = $this->createQuery();

        $query->from('profile AS \'prf\', user "usr", `order`, "customer", "a b" as "c d"');

        $tables = $query->getTablesUsedInFrom();

        $this->assertEquals(
            [
                '{{prf}}' => '{{profile}}',
                '{{usr}}' => '{{user}}',
                '{{order}}' => '{{order}}',
                '{{customer}}' => '{{customer}}',
                '{{c d}}' => '{{a b}}',
            ],
            $tables
        );
    }

    public function testGetTablesAliasesFromString(): void
    {
        $query = $this->createQuery();

        $query->from('profile AS \'prf\', user "usr", service srv, order, [a b] [c d], {{something}} AS myalias');

        $tables = $query->getTablesUsedInFrom();

        $this->assertEquals(
            [
                '{{prf}}' => '{{profile}}',
                '{{usr}}' => '{{user}}',
                '{{srv}}' => '{{service}}',
                '{{order}}' => '{{order}}',
                '{{c d}}' => '{{a b}}',
                '{{myalias}}' => '{{something}}',
            ],
            $tables
        );
    }

    /**
     * {@see https://github.com/yiisoft/yii2/issues/14150}
     */
    public function testGetTableNamesIsFromPrefixedTableName(): void
    {
        $query = $this->createQuery();

        $query->from('{{%order_item}}');

        $tables = $query->getTablesUsedInFrom();

        $this->assertEquals(['{{%order_item}}' => '{{%order_item}}'], $tables);
    }

    /**
     * {@see https://github.com/yiisoft/yii2/issues/14211}}
     */
    public function testGetTableNamesIsFromTableNameWithDatabase(): void
    {
        $query = $this->createQuery();

        $query->from('tickets.workflows');

        $tables = $query->getTablesUsedInFrom();

        $this->assertEquals(['{{tickets.workflows}}' => '{{tickets.workflows}}'], $tables);
    }

    public function testGetTableNamesIsFromAliasedExpression(): void
    {
        $query = $this->createQuery();

        $expression = new Expression('(SELECT id FROM user)');

        $query->from($expression);

        $this->expectException(InvalidArgumentException::class);
               expectException(InvalidArgumentException::class);
        $this->expectExceptionMessage('To use Expression in from() method, pass it in array format with alias.');
               expectExceptionMessage('To use Expression in from() method, pass it in array format with alias.');

        $tables = $query->getTablesUsedInFrom();

        $this->assertEquals(['{{x}}' => $expression], $tables);
    }

    public function testGetTableNamesIsFromAliasedArrayWithExpression(): void
    {
        $query = $this->createQuery();

        $query->from(['x' => new Expression('(SELECT id FROM user)')]);

        $tables = $query->getTablesUsedInFrom();

        $this->assertEquals(['{{x}}' => '(SELECT id FROM user)'], $tables);
    }

    public function testGetTableNamesIsFromAliasedSubquery(): void
    {
        $query = $this->createQuery();

        $subQuery = $this->createQuery();

        $subQuery->from('user');
        $query->from(['x' => $subQuery]);

        $expected = ['{{x}}' => $subQuery];

        $tables = $query->getTablesUsedInFrom();

        $this->assertEquals($expected, $tables);
    }
}


yiisoft / db

Branch — psalm-3 (1add06)

testGetTablesAliasesFromString() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like