Addiks\StoredSQL\Tests\Behaviour\ParseSqlTest

Complexity

Total Complexity

6

Size/Duplication

Total Lines	64
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	shouldParseConditionalSql()	0	28	3
A	shouldParseSelectSql()	0	30	3

<?php
/**
 * Copyright (C) 2019  Gerrit Addiks.
 * This package (including this file) was released under the terms of the GPL-3.0.
 * You should have received a copy of the GNU General Public License along with this program.
 * If not, see <http://www.gnu.org/licenses/> or send me a mail so i can send you a copy.
 *
 * @license GPL-3.0
 * @author Gerrit Addiks <gerrit@addiks.de>
 */

namespace Addiks\StoredSQL\Tests\Behaviour;

use Addiks\StoredSQL\Exception\UnlexableSqlException;
use Addiks\StoredSQL\Exception\UnparsableSqlException;
use Addiks\StoredSQL\Parsing\AbstractSyntaxTree\SqlAstJoin;
use Addiks\StoredSQL\Parsing\AbstractSyntaxTree\SqlAstNode;
use Addiks\StoredSQL\Parsing\AbstractSyntaxTree\SqlAstSelect;
use Addiks\StoredSQL\Parsing\AbstractSyntaxTree\SqlAstWhereCondition;
use Addiks\StoredSQL\Parsing\SqlParser;
use Addiks\StoredSQL\Parsing\SqlParserClass;
use PHPUnit\Framework\TestCase;

final class ParseSqlTest extends TestCase
{
    /** @test */
    public function shouldParseSelectSql(): void
    {
        /** @var SqlParser $parser */
        $parser = SqlParserClass::defaultParser();

        try {
            /** @var array<SqlAstNode> $detectedContent */
            $detectedContent = $parser->parseSql("
                SELECT u.name, u.email, f.name, f.size
                FROM users u
                LEFT JOIN files f ON(u.id = f.owner_id)
                WHERE f.name LIKE '%.pdf'
                AND f.type = 'symbolic'
                OR f.foo IS NULL
                ORDER BY f.size DESC, f.owner ASC
            ", [SqlAstSelect::class]);

        } catch (UnparsableSqlException $exception) {
            echo $exception->asciiLocationDump();

            throw $exception;

        } catch (UnlexableSqlException $exception) {
            echo $exception->asciiLocationDump();

            throw $exception;
        }

        $this->assertEquals(1, count($detectedContent));
        $this->assertTrue($detectedContent[0] instanceof SqlAstSelect);
    }

    /** @test */
    public function shouldParseConditionalSql(): void
    {
        /** @var SqlParser $parser */
        $parser = SqlParserClass::defaultParser();

        try {
            /** @var array<SqlAstNode> $detectedContent */
            $detectedContent = $parser->parseSql("
                LEFT JOIN files f ON(u.id = f.owner_id)
                WHERE f.name LIKE '%.pdf'
                AND f.type = 'symbolic'
                OR f.foo IS NULL
            ", [SqlAstJoin::class, SqlAstWhereCondition::class]);

        } catch (UnparsableSqlException $exception) {
            echo $exception->asciiLocationDump();

            throw $exception;

        } catch (UnlexableSqlException $exception) {
            echo $exception->asciiLocationDump();

            throw $exception;
        }

        $this->assertEquals(2, count($detectedContent));
        $this->assertTrue($detectedContent[0] instanceof SqlAstJoin);
        $this->assertTrue($detectedContent[1] instanceof SqlAstWhereCondition);
    }
}