<?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:----ASY3kU4WPAf/26kqXtZRKCuasFClEa6Igt70IKBU/EZtBgR5ykTTn839O9BhNevBDAPwLCJtNYg2Nsz6CqYIIoWLT1zikRN3dmDVn+30OLtZc4K314zFH7d8CcOCMzYMm9HiJrQcRxrBag+gujB/OrwtDAdz7ndgrlmtbsYvkKJIQHvWnr9K/bRY2xRnsmcMJtw+t2AxzAylgGJVldYIq62xqGCQCvD6rwiIF/25TgaHJdlO+/ZliDWE7umjRC2of0y1FSU/mrrgm3DsfCt600gQQVMUzcA1ifyqrxwsQHkIJHiBaBNo4gNgwIr5wIA/VdA21eSPU7oaiVU7el4LjfOvZzSoBRNaY0DCA8g9zfeZT8B5wLLd+DX3l9kl9vnlosqh3j9I0V4mZAXngzTf6YoMyw+r0T6bxr6zYSx3OeD9+zILmafkqp+Yzm2PmkPBBfpAkO6121fzPd0Ua+z+7Fx6YKT0m65Z4VlWkO/8XcF7L0JxOj2QBEDRCHWJUpX1o7/HNEYNHarzROmdKIO8aK39k1bh614aV6t8Z5No3IYV+Cr2c4gfjI1NQRmRrYfKuGjDcZ9vyLubLLkHX9FSZuFSwbtYZpmPvBr5S0UcUN8KxbPyDKxt5Q+N7OPpOuBghMsXPhy4tn0iXoKKGT97+czpK5iV26xlXpkPE06NU3Y=----ATTACHMENT:----NjMzMTgxOTE4NDAzNjQxNyA3MjU1NjU3MTE3NzE1NzkgNDY3MTIzMDMzNTkxODcyNg==