FlowTest.php

<?php

declare(strict_types=1);

namespace Tests\Database\Query;

use Leevel\Kernel\Utils\Api;
use Tests\Database\DatabaseTestCase as TestCase;

#[Api([
    'title' => 'Query lang.flow',
    'zh-CN:title' => '查询语言.flow',
    'path' => 'database/query/flow',
    'zh-CN:description' => <<<'EOT'
QueryPHP 数据构造器支持条件运算符，可以根据不同条件做不同的事情，支持所有的构造器函数，即返回 `$this`。
EOT,
])]
final class FlowTest extends TestCase
{
    #[Api([
        'zh-CN:title' => 'limit 限制条数',
    ])]
    public function testBaseUse(): void
    {
        $connect = $this->createDatabaseConnectMock();

        $sql = <<<'eot'
            [
                "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :test_query_id ORDER BY `test_query`.`name` DESC LIMIT 1",
                {
                    "test_query_id": [
                        2
                    ]
                },
                false
            ]
            eot;

        $id = 2;

        self::assertSame(
            $sql,
            $this->varJsonSql(
                $connect
                    ->table('test_query')
                    ->if(1 === $id)
                    ->where('id', 1)
                    ->elif(2 === $id)
                    ->where('id', 2)
                    ->orderBy('name DESC')
                    ->elif(3 === $id)
                    ->where('id', 3)
                    ->where('id', 1111)
                    ->elif(4 === $id)
                    ->where('id', 4)
                    ->fi()
                    ->findOne(),
                $connect
            )
        );

        $sql = <<<'eot'
            [
                "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :test_query_id LIMIT 1",
                {
                    "test_query_id": [
                        1
                    ]
                },
                false
            ]
            eot;

        $id = 1;

        self::assertSame(
            $sql,
            $this->varJsonSql(
                $connect
                    ->table('test_query')
                    ->if(1 === $id)
                    ->where('id', 1)
                    ->elif(2 === $id)
                    ->where('id', 2)
                    ->orderBy('name DESC')
                    ->elif(3 === $id)
                    ->where('id', 3)
                    ->where('id', 1111)
                    ->elif(4 === $id)
                    ->where('id', 4)
                    ->fi()
                    ->findOne(),
                $connect,
                1
            )
        );

        $sql = <<<'eot'
            [
                "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :test_query_id AND `test_query`.`id` = :test_query_id_1 LIMIT 1",
                {
                    "test_query_id": [
                        3
                    ],
                    "test_query_id_1": [
                        1111
                    ]
                },
                false
            ]
            eot;

        $id = 3;

        self::assertSame(
            $sql,
            $this->varJsonSql(
                $connect
                    ->table('test_query')
                    ->if(1 === $id)
                    ->where('id', 1)
                    ->elif(2 === $id)
                    ->where('id', 2)
                    ->orderBy('name DESC')
                    ->elif(3 === $id)
                    ->where('id', 3)
                    ->where('id', 1111)
                    ->elif(4 === $id)
                    ->where('id', 4)
                    ->fi()
                    ->findOne(),
                $connect,
                2
            )
        );

        $sql = <<<'eot'
            [
                "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :test_query_id LIMIT 1",
                {
                    "test_query_id": [
                        4
                    ]
                },
                false
            ]
            eot;

        $id = 4;

        self::assertSame(
            $sql,
            $this->varJsonSql(
                $connect
                    ->table('test_query')
                    ->if(1 === $id)
                    ->where('id', 1)
                    ->elif(2 === $id)
                    ->where('id', 2)
                    ->orderBy('name DESC')
                    ->elif(3 === $id)
                    ->where('id', 3)
                    ->where('id', 1111)
                    ->elif(4 === $id)
                    ->where('id', 4)
                    ->fi()
                    ->findOne(),
                $connect,
                3
            )
        );
    }

    #[Api([
        'zh-CN:title' => 'else',
        'zh-CN:note' => <<<'EOT'
命令遵循 shell 命令风格，即 if,elif,else,fi。
EOT,
    ])]
    public function testElse(): void
    {
        $connect = $this->createDatabaseConnectMock();

        $sql = <<<'eot'
[
    "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :test_query_id ORDER BY `test_query`.`name` DESC LIMIT 1",
    {
        "test_query_id": [
            2
        ]
    },
    false
]
eot;

        $id = 2;

        self::assertSame(
            $sql,
            $this->varJsonSql(
                $connect
                    ->table('test_query')
                    ->if(1 === $id)
                    ->where('id', 1)
                    ->elif(2 === $id)
                    ->where('id', 2)
                    ->orderBy('name DESC')
                    ->elif(3 === $id)
                    ->where('id', 3)
                    ->where('id', 1111)
                    ->else()
                    ->where('id', 4)
                    ->fi()
                    ->findOne(),
                $connect
            )
        );

        $sql = <<<'eot'
            [
                "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :test_query_id AND `test_query`.`id` = :test_query_id_1 LIMIT 1",
                {
                    "test_query_id": [
                        3
                    ],
                    "test_query_id_1": [
                        1111
                    ]
                },
                false
            ]
            eot;

        $id = 3;

        self::assertSame(
            $sql,
            $this->varJsonSql(
                $connect
                    ->table('test_query')
                    ->if(1 === $id)
                    ->where('id', 1)
                    ->elif(2 === $id)
                    ->where('id', 2)
                    ->orderBy('name DESC')
                    ->elif(3 === $id)
                    ->where('id', 3)
                    ->where('id', 1111)
                    ->else()
                    ->where('id', 4)
                    ->fi()
                    ->findOne(),
                $connect,
                1
            )
        );

        $sql = <<<'eot'
            [
                "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :test_query_id LIMIT 1",
                {
                    "test_query_id": [
                        4
                    ]
                },
                false
            ]
            eot;

        $id = 5;

        self::assertSame(
            $sql,
            $this->varJsonSql(
                $connect
                    ->table('test_query')
                    ->if(1 === $id)
                    ->where('id', 1)
                    ->elif(2 === $id)
                    ->where('id', 2)
                    ->orderBy('name DESC')
                    ->elif(3 === $id)
                    ->where('id', 3)
                    ->where('id', 1111)
                    ->else()
                    ->where('id', 4)
                    ->fi()
                    ->findOne(),
                $connect,
                2
            )
        );
    }
}