Yiisoft\Db\Mysql\Tests\QueryTest

Complexity

Total Complexity

2

Size/Duplication

Total Lines	31
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	testLimitOffsetWithExpression()	0	13	1
A	testQueryIndexHint()	0	9	1

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Mysql\Tests;

use Yiisoft\Db\Querys\Query;
use Yiisoft\Db\Expressions\Expression;
use Yiisoft\Db\Tests\QueryTest as AbstractQueryTest;

class QueryTest extends AbstractQueryTest
{
    protected ?string $driverName = 'mysql';

    /**
     * Tests MySQL specific syntax for index hints.
     */
    public function testQueryIndexHint(): void
    {
        $query = (new Query($this->getConnection()))->from([new Expression('{{%customer}} USE INDEX (primary)')]);

        $row = $query->one();

        $this->assertArrayHasKey('id', $row);

It seems like $row can also be of type false; however, parameter $array of PHPUnit\Framework\Assert::assertArrayHasKey() does only seem to accept ArrayAccess|array, maybe add an additional type check?

        $this->assertArrayHasKey('name', $row);
        $this->assertArrayHasKey('email', $row);
    }

    public function testLimitOffsetWithExpression(): void
    {
        $query = (new Query($this->getConnection()))->from('customer')->select('id')->orderBy('id');

        // In MySQL limit and offset arguments must both be non negative integer constant
        $query->limit(new Expression('2'))->offset(new Expression('1'));

        $result = $query->column();

        $this->assertCount(2, $result);
        $this->assertContains("2", $result);
        $this->assertContains("3", $result);
        $this->assertNotContains("1", $result);
    }
}