<?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:----eZkqLCa+ke5PuehchOXqhk66gmLvRikboY+8C+MPWa455ERGOu7wCvN5G8Ep+4tq6GUAIeVhXPRl3fw2pBhkA1lQjWyG16p/Bkd0GfXHjP9QaAkFerqbyUCxeKUcO88QmT0bF8kcpo9YCqnMNobxNOzqPU1R7V3Ky369BqrhJYcZNRHqEfNDIHrpDVt65+djjUwyfF8+uMClyuvWLZBp+1OdBS2dA6F+ao+ba4UQdSPBNYSjMdQPHegw4vASCFWdpW7IUcbaJ20zsrks1B/p4Fft+UzHZwYbghlk7Qr5m8PRSQ5eGasAONsf5xVG5DPMG0alKn2EoMqs1Wt/Up4h+Uw0wJU+VRdWn6KniKUbCAvDqy1Gl+9rRSNBedlhPwCBragUqyh9raqEP0tULUwsJ70rGu3CnlB5KJUSr2tCppEDkGV092yW0gGq2+n51tnvmndctY8UEO5owlOe1qG7H4awpPwN7MV4X1CRc07/poG/mDKwugDwLNTBrvk95JJN9JKM3K1OvW58eEzk+9PpVDYZTDibRb6M0WcVLIv2U7iuRuWasM4kzrKdYvuRN6YbISWYTbwnEXeK6Rb9w5FTjyTQpvNLUY5gQ4lwdtPKNGKIY5STlsJgrlnMPXFmLnFWa0Lx/eqilSjN9gbvTtxOmwsIXB3dXusywHEbG9/f8hE=----ATTACHMENT:----NDkwMjg3NjkxODIzNzk2MyA3MzgxMDgxMzE1NjMxMDY0IDI2MzQzNTU1Njk0NzE1ODQ=