SqliteCompilerTest::testSelect() - Code Metrics - Inspection of "Add unit tests and fix bugs (#8)" - lampager/lampager-cakephp - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 383493...d29574 )

by Chito

created 2020-01-02 16:39 UTC

SqliteCompilerTest::testSelect() A

↳ Parent: SqliteCompilerTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	19
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	1	Features	0

Metric	Value
eloc	7
c	1
b	1
f	0
dl	0
loc	19
rs	10
cc	1
nc	1
nop	0

<?php

namespace Lampager\Cake\Test\TestCase\Database;

use Cake\Datasource\ConnectionManager;
use Cake\ORM\TableRegistry;
use Lampager\Cake\Test\TestCase\TestCase;

class SqliteCompilerTest extends TestCase
{
    public $fixtures = [
        'plugin.Lampager\\Cake.Posts',
    ];

    public function setUp()
    {
        $config = ConnectionManager::getConfig('test');
        $this->skipIf(strpos($config['driver'], 'Sqlite') === false, 'Not using Sqlite');
    }

    public function testSelect()
    {
        $posts = TableRegistry::getTableLocator()->get('Posts');

        $expected = '
            SELECT
                Posts.* AS "Posts__*"
            FROM
                posts Posts
            ORDER BY
                modified ASC
        ';

        $actual = $posts->find()
            ->select(['*'])
            ->orderAsc('modified')
            ->sql();

        $this->assertSqlEquals($expected, $actual);
    }

    public function testUnion()
    {
        $posts = TableRegistry::getTableLocator()->get('Posts');

        $expected = '
            SELECT
                *
            FROM
                (
                    SELECT
                        Posts.id AS "Posts__id",
                        Posts.modified AS "Posts__modified"
                    FROM
                        posts Posts
                    WHERE
                        id > :c0
                    ORDER BY
                        modified ASC
                )
            UNION ALL
            SELECT
                *
            FROM
                (
                    SELECT
                        Posts.id AS "Posts__id",
                        Posts.modified AS "Posts__modified"
                    FROM
                        posts Posts
                    ORDER BY
                        modified ASC
                )
        ';

        $subQuery = $posts->find()
            ->select(['id', 'modified'])
            ->orderAsc('modified');

        $mainQuery = $posts->find()
            ->select(['id', 'modified'])
            ->where(['id >' => 1])
            ->orderAsc('modified')
            ->unionAll($subQuery);

        $actual = $mainQuery->sql();
        $this->assertSqlEquals($expected, $actual);
    }
}


1			<?php
2
3			namespace Lampager\Cake\Test\TestCase\Database;
4
5			use Cake\Datasource\ConnectionManager;
6			use Cake\ORM\TableRegistry;
7			use Lampager\Cake\Test\TestCase\TestCase;
8
9			class SqliteCompilerTest extends TestCase
10			{
11			public $fixtures = [
12			'plugin.Lampager\\Cake.Posts',
13			];
14
15			public function setUp()
16			{
17			$config = ConnectionManager::getConfig('test');
18			$this->skipIf(strpos($config['driver'], 'Sqlite') === false, 'Not using Sqlite');
19			}
20
21			public function testSelect()
22			{
23			$posts = TableRegistry::getTableLocator()->get('Posts');
24
25			$expected = '
26			SELECT
27			Posts.* AS "Posts__*"
28			FROM
29			posts Posts
30			ORDER BY
31			modified ASC
32			';
33
34			$actual = $posts->find()
35			->select(['*'])
36			->orderAsc('modified')
37			->sql();
38
39			$this->assertSqlEquals($expected, $actual);
40			}
41
42			public function testUnion()
43			{
44			$posts = TableRegistry::getTableLocator()->get('Posts');
45
46			$expected = '
47			SELECT
48			*
49			FROM
50			(
51			SELECT
52			Posts.id AS "Posts__id",
53			Posts.modified AS "Posts__modified"
54			FROM
55			posts Posts
56			WHERE
57			id > :c0
58			ORDER BY
59			modified ASC
60			)
61			UNION ALL
62			SELECT
63			*
64			FROM
65			(
66			SELECT
67			Posts.id AS "Posts__id",
68			Posts.modified AS "Posts__modified"
69			FROM
70			posts Posts
71			ORDER BY
72			modified ASC
73			)
74			';
75
76			$subQuery = $posts->find()
77			->select(['id', 'modified'])
78			->orderAsc('modified');
79
80			$mainQuery = $posts->find()
81			->select(['id', 'modified'])
82			->where(['id >' => 1])
83			->orderAsc('modified')
84			->unionAll($subQuery);
85
86			$actual = $mainQuery->sql();
87			$this->assertSqlEquals($expected, $actual);
88			}
89			}
90

lampager / lampager-cakephp

Push — master ( 383493...d29574 )

SqliteCompilerTest::testSelect() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like