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

Completed

Pull Request — master (#8)

by Chito

created 2020-01-02 15:57 UTC

SqliteCompilerTest::setUp() A

↳ Parent: SqliteCompilerTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	4
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	1	Features	0

Metric	Value
eloc	2
c	1
b	1
f	0
dl	0
loc	4
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.* 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())
            ->unionAll(/** @scrutinizer ignore-type */ $posts->query()->func()->now())
            ->sql();

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


lampager / lampager-cakephp

Pull Request — master (#8)

SqliteCompilerTest::setUp() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like