GetTablesAliasTestTrait::testGetTableNamesIsFromObjectgenerateException() - Code Metrics - Inspection of "Ability to disable auto slave select for all read..." - yiisoft/db - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( f4eeb8...0d22ee )

by Sergei

created 2022-03-25 12:55 UTC

testGetTableNamesIsFromObjectgenerateException() A

↳ Parent: GetTablesAliasTestTrait

Complexity

Conditions	1
Paths	1

Size

Total Lines	9
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	5
CRAP Score	1

Importance

Changes

Metric	Value
cc	1
eloc	4
nc	1
nop	0
dl	0
loc	9
ccs	5
cts	5
cp	1
crap	1
rs	10
c	0
b	0
f	0

<?php

declare(strict_types=1);

namespace Yiisoft\Db\TestUtility;

use stdClass;
use Yiisoft\Db\Exception\InvalidArgumentException;
use Yiisoft\Db\Exception\InvalidConfigException;
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 testGetTableNamesIsFromObjectgenerateException(): void
    {
        $query = $this->createQuery();

        $query->from(new stdClass());
        $query->from(/** @scrutinizer ignore-type */ new stdClass());

        $this->expectException(InvalidConfigException::class);
               expectException(InvalidConfigException::class);

        $query->getTablesUsedInFrom();
    }

    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);
        $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

Push — master ( f4eeb8...0d22ee )

testGetTableNamesIsFromObjectgenerateException() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like