Lampager\Cake\Test\TestCase\Database\SqliteCompilerTest::testUnion()

Complexity

Conditions	1
Paths	1

Size

Total Lines	46
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	1	Features	0

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