Lampager\Cake\Test\TestCase\Database\SqliteCompilerTest

Complexity

Total Complexity

3

Size/Duplication

Total Lines	79
Duplicated Lines	0 %

Importance

Changes	2
Bugs	1	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	testSelect()	0	19	1
A	setUp()	0	4	1
A	testUnion()	0	46	1

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