QueryTest::testLimitOffsetWithExpression() - Code Metrics - Inspection of "Fix tests (#5)" - yiisoft/db-sqlite - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 5adaea...ab4b97 )

by Alexander

created 2020-02-26 05:42 UTC

QueryTest::testLimitOffsetWithExpression() A

↳ Parent: QueryTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	14
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	9
c	0
b	0
f	0
nc	1
nop	0
dl	0
loc	14
rs	9.9666

<?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);
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace Yiisoft\Db\Sqlite\Tests;
6
7			use Yiisoft\Db\Expressions\Expression;
8			use Yiisoft\Db\Querys\Query;
9			use Yiisoft\Db\Tests\QueryTest as AbstractQueryTest;
10
11			class QueryTest extends AbstractQueryTest
12			{
13			protected ?string $driverName = 'sqlite';
14
15			public function testUnion(): void
16			{
17			$db = $this->getConnection();
18
19			$query = new Query($db);
20
21			$query->select(['id', 'name'])
22			->from('item')
23			->union(
24			(new Query($db))
25			->select(['id', 'name'])
26			->from(['category'])
27			);
28
29			$result = $query->all();
30
31			$this->assertNotEmpty($result);
32			$this->assertCount(7, $result);
33			}
34
35			public function testLimitOffsetWithExpression(): void
36			{
37			$query = (new Query($this->getConnection()))->from('customer')->select('id')->orderBy('id');
38
39			$query
40			->limit(new Expression('1 + 1'))
41			->offset(new Expression('1 + 0'));
42
43			$result = $query->column();
44
45			$this->assertCount(2, $result);
46			$this->assertContains("2", $result);
47			$this->assertContains("3", $result);
48			$this->assertNotContains("1", $result);
49			}
50			}
51

yiisoft / db-sqlite

Push — master ( 5adaea...ab4b97 )

QueryTest::testLimitOffsetWithExpression() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like