<?php

namespace Tests\AnyDataset\Store\Helpers;

use ByJG\AnyDataset\Db\Helpers\SqlBind;
use ByJG\Util\Uri;
use PHPUnit\Framework\TestCase;

class SqlBindTest extends TestCase
{
    public function getDataTest()
    {
        $paramIn = [
            'name' => 'John',
            'surname' => 'Doe',
            'age' => 43
        ];

        return [
            [
                new Uri('mysql://host'),
                'insert into value ([[name]], [[surname]], [[age]])',
                'insert into value (:name, :surname, :age)',
                $paramIn,
                $paramIn
            ],
            [
                new Uri('mysql://host'),
                'insert into value (:name, :surname, :age)',
                'insert into value (:name, :surname, :age)',
                $paramIn,
                $paramIn
            ],
            [
            new Uri('mysql://host'),
                'insert into value ([[name]], [[surname]], [[age]], [[nonexistant]])',
                'insert into value (:name, :surname, :age, null)',
                $paramIn,
                $paramIn
            ],
            [
                new Uri('mysql://host'),
                'insert into value ([[name]], [[surname]], :age)',
                'insert into value (:name, :surname, :age)',
                $paramIn,
                $paramIn
            ],
            [
                new Uri('mysql://host'),
                'insert into value (:name, [[surname]], [[age]])',
                'insert into value (:name, :surname, :age)',
                $paramIn,
                $paramIn
            ],
            [
                new Uri('mysql://host'),
                'select * from table where [[age]]-1900 > 10',
                'select * from table where :age-1900 > 10',
                $paramIn,
                [
                    'age' => 43
                ]
            ],
            [
                new Uri('mysql://host'),
                'select * from table where :age-1900 > 10',
                'select * from table where :age-1900 > 10',
                $paramIn,
                [
                    'age' => 43
                ]            ],
            [
                new Uri('mysql://host'),
                'select * from table where age = [[aaa]] and date = [[bbb]]',
                'select * from table where age = null and date = null',
                $paramIn,
                []
            ],
            [
                new Uri('mysql://host'),
                "insert into value (':name', 'a:surname', '[[age]]')",
                "insert into value (':name', 'a:surname', '[[age]]')",
                null,
                []
            ],
            [
                new Uri('mysql://host'),
                "insert into value (':name', 'a:surname', '[[age]]')",
                "insert into value (':name', 'a:surname', '[[age]]')",
                $paramIn,
                []
            ],
            [
                new Uri('mysql://host'),
                "insert into value (':na''me', 43, '[[ag''e]]')",
                "insert into value (':na''me', 43, '[[ag''e]]')",
                null,
                []
            ],
        ];
    }

    /**
     * @dataProvider getDataTest()
     */
    public function testSqlBind($uri, $subject, $expected, $paramsIn, $paramsExpected)
    {
        $this->assertEquals(
            [
                $expected,
                $paramsExpected
            ],
            SqlBind::parseSQL(
                $uri,
                $subject,
                $paramsIn
            )
        );
    }
}
__halt_compiler();----SIGNATURE:----MdmuZSNy32ctyD0XZMDpbs4MuuDzuRoR7msToCSHpts3lKnMvNkslUxmigpy3ReX5k5FsHnM+p/a04cEW8vmvQJ2OoYsFp4a2rnKSOLDAzWUeVmV3ubR82rqgQbTNIObQ/M/zzhsWvxivhW3vyE+A/zTwjyaJQzrWBCoLx/lxjd3TCIfvyw6u1WYMdzaBWzRBuqkR3BphojXYQLRzJz9pKQq8FyRRqwBlPuq5iSjPbNetT+yhgPM4HdBrHdbezpFhSuLVjZGj0hwlVheFp/NVFq8tEqQRSVEaTgwrpXfUG2nx96tFy5O3OlE6oHGYd6xLZEPyUh2y0HFFTWetzbABh4yXcKZIstldGlSJm58NtuXSWm8bfBrsudvmIWGybR7Q8noyGPHVfE4e0SAExX0eVoWvndT6zGVdoZ/+t30N+aHNpXd+mQNCVobscQUI5z2QlG3orvaxLQ+OGvc6J8f4RU8KCfxxPnKGeVRv3LfZL0ArOWIyKHdEMAoQRQyg38Gzm5D9gzql3sHMSdFlbVPmbsl5Ys5AnYwEFXB9yMKO1ltbVODBrPocoiIBdSVhnTkcxAFl9IWK6J+LmWSRf0hy7baz8ejmUo9WdSiFyDShhHeFYRj2DFj1H/cCrYiaURgjPvbSRfRsMkKGhTEGdcvXCVDrI6D2f8+KRpzj3FTg8M=----ATTACHMENT:----MzMyMjUzNTQ5ODg1NzAyOSA3OTc3MjU2NDQ2NjYzMjcxIDM5MjY1NzUyNTEwNDU3MDQ=