Lampager\Cake\Test\TestCase\Database\SqliteCompilerTest

Complexity

Total Complexity

3

Size/Duplication

Total Lines	65
Duplicated Lines	0 %

Importance

Changes	1
Bugs	1	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	testUnion()	0	32	1
A	testSelect()	0	19	1
A	setUp()	0	4	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.* AS "Posts__*"
                    FROM
                        posts Posts
                    ORDER BY
                        modified ASC
                )
            UNION ALL
            SELECT
                *
            FROM
                (
                    DATETIME(\'now\')
                )
        ';

        $actual = $posts->find()
            ->select(['*'])
            ->orderAsc('modified')
            ->unionAll($posts->query()->func()->now())

$posts->query()->func()->now() of type Cake\Database\Expression\FunctionExpression is incompatible with the type Cake\Database\Query|string expected by parameter $query of Cake\Database\Query::unionAll().

            ->sql();

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