查询语言.bind

Testing Is Documentation

tests/Database/Query/BindTest.php

Uses

<?php
use Leevel\Database\Condition;
use PDO;
use Tests\Database\DatabaseTestCase as TestCase;

命名参数绑定

public function testBaseUse(): void
{
    $connect = $this->createDatabaseConnectMock();
    $sql = <<<'eot'
        [
            "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :id",
            {
                "id": [
                    1
                ]
            },
            false
        ]
        eot;
    $this->assertSame(
        $sql,
        $this->varJson(
            $connect
                ->table('test_query')
                ->bind('id', 1)
                ->where('id', '=', Condition::raw(':id'))
                ->findAll(true)
        )
    );
}

命名参数绑定，支持绑定类型

public function testBindWithType(): void
{
    $connect = $this->createDatabaseConnectMock();
    $sql = <<<'eot'
        [
            "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :id",
            {
                "id": [
                    1,
                    1
                ]
            },
            false
        ]
        eot;
    $this->assertSame(
        $sql,
        $this->varJson(
            $connect
                ->table('test_query')
                ->bind('id', 1, PDO::PARAM_INT)
                ->where('id', '=', Condition::raw(':id'))
                ->findAll(true),
            1
        )
    );
}

命名参数绑定，绑定值支持类型定义

public function testWithTypeAndValueCanBeArray(): void
{
    $connect = $this->createDatabaseConnectMock();
    $sql = <<<'eot'
        [
            "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :id",
            {
                "id": [
                    1,
                    1
                ]
            },
            false
        ]
        eot;
    $this->assertSame(
        $sql,
        $this->varJson(
            $connect
                ->table('test_query')
                ->bind('id', [1, PDO::PARAM_INT])
                ->where('id', '=', Condition::raw(':id'))
                ->findAll(true),
            2
        )
    );
}

命名参数绑定，支持多个字段绑定

public function testNameBind(): void
{
    $connect = $this->createDatabaseConnectMock();
    $sql = <<<'eot'
        [
            "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = :id AND `test_query`.`hello` LIKE :name",
            {
                "id": [
                    1,
                    1
                ],
                "name": [
                    "小鸭子"
                ]
            },
            false
        ]
        eot;
    $this->assertSame(
        $sql,
        $this->varJson(
            $connect
                ->table('test_query')
                ->bind(['id' => [1, PDO::PARAM_INT], 'name'=>'小鸭子'])
                ->where('id', '=', Condition::raw(':id'))
                ->where('hello', 'like', Condition::raw(':name'))
                ->findAll(true),
            3
        )
    );
}

问号 ? 参数绑定，支持多个字段绑定

public function testQuestionMarkBind(): void
{
    $connect = $this->createDatabaseConnectMock();
    $sql = <<<'eot'
        [
            "SELECT `test_query`.* FROM `test_query` WHERE `test_query`.`id` = ? AND `test_query`.`hello` LIKE ?",
            [
                [
                    5,
                    1
                ],
                [
                    "小鸭子"
                ]
            ],
            false
        ]
        eot;
    $this->assertSame(
        $sql,
        $this->varJson(
            $connect
                ->table('test_query')
                ->bind([[5, PDO::PARAM_INT], '小鸭子'])
                ->where('id', '=', Condition::raw('?'))
                ->where('hello', 'like', Condition::raw('?'))
                ->findAll(true),
            4
        )
    );
}