Yiisoft\Db\Sqlite\Tests\QueryTest

Complexity

Total Complexity

2

Size/Duplication

Total Lines	38
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	testLimitOffsetWithExpression()	0	14	1
A	testUnion()	0	18	1

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Sqlite\Tests;

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

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

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

        $query = new Query($db);

        $query->select(['id', 'name'])
            ->from('item')
            ->union(
                (new Query($db))
                    ->select(['id', 'name'])
                    ->from(['category'])
            );

        $result = $query->all();

        $this->assertNotEmpty($result);
        $this->assertCount(7, $result);
    }

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

        $query
            ->limit(new Expression('1 + 1'))
            ->offset(new Expression('1 + 0'));

        $result = $query->column();

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