Yiisoft\Db\Tests\AbstractQueryGetTableAliasTest

Complexity

Total Complexity

9

Size/Duplication

Total Lines	161
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

9 Methods

Rating	Name	Duplication	Size	Complexity
A	testNamesIsFromAliasedArrayWithExpression()	0	10	1
A	testNamesIsFromPrefixedTableName()	0	9	1
A	testAliasesFromString()	0	18	1
A	testNamesIsFromAliasedExpression()	0	14	1
A	testNamesIsFromTableNameWithDatabase()	0	9	1
A	testNamesIsFromArrayWithAlias()	0	12	1
A	testNamesIsFromArrayWithoutAlias()	0	9	1
A	testNamesIsFromString()	0	17	1
A	testGetTableNamesIsFromAliasedSubquery()	0	12	1

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Tests;

use PHPUnit\Framework\TestCase;
use Yiisoft\Db\Exception\InvalidArgumentException;
use Yiisoft\Db\Expression\Expression;
use Yiisoft\Db\Query\Query;
use Yiisoft\Db\Tests\Support\TestTrait;

abstract class AbstractQueryGetTableAliasTest extends TestCase
{
    use TestTrait;

    /**
     * @throws InvalidArgumentException
     */
    public function testAliasesFromString(): void
    {
        $db = $this->getConnection();

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

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

    /**
     * @throws InvalidArgumentException
     */
    public function testGetTableNamesIsFromAliasedSubquery(): void
    {
        $db = $this->getConnection();

        $query = new Query($db);
        $subQuery = new Query($db);
        $subQuery->from('user');
        $query->from(['x' => $subQuery]);
        $expected = ['{{x}}' => $subQuery];
        $tables = $query->getTablesUsedInFrom();

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

    /**
     * @throws InvalidArgumentException
     */
    public function testNamesIsFromAliasedArrayWithExpression(): void
    {
        $db = $this->getConnection();

        $query = new Query($db);
        $expression = new Expression('(SELECT id FROM user)');
        $query->from(['x' => $expression]);
        $tables = $query->getTablesUsedInFrom();

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

    public function testNamesIsFromAliasedExpression(): void
    {
        $db = $this->getConnection();

        $query = new Query($db);
        $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.');

        $tables = $query->getTablesUsedInFrom();

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

    /**
     * @throws InvalidArgumentException
     */
    public function testNamesIsFromArrayWithAlias(): void
    {
        $db = $this->getConnection();

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

        $tables = $query->getTablesUsedInFrom();

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

    /**
     * @throws InvalidArgumentException
     */
    public function testNamesIsFromArrayWithoutAlias(): void
    {
        $db = $this->getConnection();

        $query = new Query($db);
        $query->from(['{{profile}}', 'user']);
        $tables = $query->getTablesUsedInFrom();

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

    /**
     * {@link https://github.com/yiisoft/yii2/issues/14150}
     *
     * @throws InvalidArgumentException
     */
    public function testNamesIsFromPrefixedTableName(): void
    {
        $db = $this->getConnection();

        $query = new Query($db);
        $query->from('{{%order_item}}');
        $tables = $query->getTablesUsedInFrom();

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

    /**
     * @throws InvalidArgumentException
     */
    public function testNamesIsFromString(): void
    {
        $db = $this->getConnection();

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

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

    /**
     * {@link https://github.com/yiisoft/yii2/issues/14211}}
     *
     * @throws InvalidArgumentException
     */
    public function testNamesIsFromTableNameWithDatabase(): void
    {
        $db = $this->getConnection();

        $query = new Query($db);
        $query->from('tickets.workflows');
        $tables = $query->getTablesUsedInFrom();

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