<?php

namespace Medoo\Tests;

use InvalidArgumentException;

/**
 * @coversDefaultClass \Medoo\Medoo
 */
class ReplaceTest extends MedooTestCase
{
    /**
     * @covers ::replace()
     * @dataProvider typesProvider
     */
    public function testReplace($type)
    {
        $this->setType($type);

        $this->database->replace("account", [
            "type" => [
                "user" => "new_user",
                "business" => "new_business"
            ],
            "column" => [
                "old_value" => "new_value"
            ]
        ], [
            "user_id[>]" => 1000
        ]);

        $this->assertQuery(
            "UPDATE "account"\nSET "type" = REPLACE("type", 'user', 'new_user'),\n"type" = REPLACE("type", 'business', 'new_business'),\n"column" = REPLACE("column", 'old_value', 'new_value')\nWHERE "user_id" > 1000",
            $this->database->queryString
        );
    }

    /**
     * @covers ::replace()
     */
    public function testReplaceEmptyColumns()
    {
        $this->expectException(InvalidArgumentException::class);

        $this->database->replace("account", [], [
            "user_id[>]" => 1000
        ]);
    }
}
__halt_compiler();----SIGNATURE:----reDKN8+lC5Qqw7hurb4v+eMYfgx4M1dq2maGVoRJVSLwF9/6LSjxK98NwjaL02688miGaIuERewomUSHJdBAoenF/qZnYu+p+V3b3IGRovGbZ2Ct7dRglJr3IAXgcf5dUkD2txUoHIP0npDjzbhtPXoswC1Jva4tn3c7NLxKJcWZn7K8KSlKugUcifwKo+1fKTZXWXTKpHhRby7UGQf3tefaSw9ecFI6FKbyQ8kLP9SMapwMbJ3X/iZ5KZTofPP7ETytxycDi834aMP8t+vKQwpDgUV0u/J6I42rz2Mn5SRWkxNmZmokcNP3qMIXyCSaKxi3RMnnw+XErj4j6pSbyGPcM5pIiCGSED6IWU2ll3BV9hihrTQvIdXe9/6DvY/xN4QRnA+Tx7AINrh7eHVpV20iM0gEj5Co9GlmqUZRMP0KoWgo98oe/JIh74HswmajqiZnU/BmPGg99Yu0Gtobl4vKwN/RIC1kIo0R8AswMqk/eccTPYhT6zq6va1DryPoTAD5EPD2Ht5GvqjeiivZl85zLKBM34d8FTQMfyiH9FWHVhpDzkjyImf8OedWnDL+8POXeGoyLMwhoHHesGNzssap5tVli0IRCb9DBND3SI+gZyhd7OTWc7llEIttesA6fTFwM+kfTN33MGXkN0/RDmpaMwaOA6nhALlqQFE3iL4=----ATTACHMENT:----Nzc0Mjc0NTYzODc5ODcyNiA2Mjk3NDk0NDk1MTgyODIxIDYxNzkxODk5OTk4MjcxOTg=