Yiisoft\Db\Mysql\Tests\QueryTest

Complexity

Total Complexity

2

Size/Duplication

Total Lines	28
Duplicated Lines	0 %

Importance

Changes

0

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

    public function testQueryIndexHint(): void
    {
        $query = (new Query($this->getConnection()))->from([new Expression('{{%customer}} USE INDEX (primary)')]);

        $row = $query->one();

        $this->assertArrayHasKey('id', $row);
        $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);
    }