<?php

namespace Medoo\Tests;

use Medoo\Medoo;

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

        $objectData = new Foo();

        $this->database->update("account", [
            "type" => "user",
            "age[+]" => 1,
            "level[-]" => 5,
            "score[*]" => 2,
            "lang" => ["en", "fr"],
            "lang [JSON]" => ["en", "fr"],
            "is_locked" => true,
            "uuid" => Medoo::raw("UUID()"),
            "object" => $objectData
        ], [
            "user_id[<]" => 1000
        ]);

        $this->assertQuery([
            'default' => "UPDATE "account"\nSET "type" = 'user',\n"age" = "age" + 1,\n"level" = "level" - 5,\n"score" = "score" * 2,\n"lang" = 'a:2:{i:0;s:2:"en";i:1;s:2:"fr";}',\n"lang" = '["en","fr"]',\n"is_locked" = 1,\n"uuid" = UUID(),\n"object" = :MeD4_mK\nWHERE "user_id" < 1000",
            'mysql' => "UPDATE "account"\nSET "type" = 'user',\n"age" = "age" + 1,\n"level" = "level" - 5,\n"score" = "score" * 2,\n"lang" = 'a:2:{i:0;s:2:\"en\";i:1;s:2:\"fr\";}',\n"lang" = '[\"en\",\"fr\"]',\n"is_locked" = 1,\n"uuid" = UUID(),\n"object" = :MeD4_mK\nWHERE "user_id" < 1000",
        ], $this->database->queryString);
    }

    public function testOracleLOBsUpdate()
    {
        $this->setType("oracle");

        $fp = fopen('README.md', 'r');

        $this->database->update("ACCOUNT", [
            "DATA" => $fp
        ], [
            "ID" => 1
        ]);

        $this->assertQuery(
            "UPDATE "ACCOUNT"\nSET "DATA" = EMPTY_BLOB()\nWHERE "ID" = 1\nRETURNING "DATA" INTO :MeD0_mK",
            $this->database->queryString
        );
    }
}
__halt_compiler();----SIGNATURE:----RQ3KzEA0Ifn7ni/MCP/zm+4YX4qpsG6VWM85SFoaqdfyUgqb5FNCDNdYk6DtV7fcCfWhc15U+kTdk3/DhE+ZUF4aXKPGtbrQ2vFSlXnCOwBhyqRR3fUDrJ02Tyjf9RztTXmrup333ux3hj/R7WcIWek3a+6D4foFFBCPWDCGXQY/NIE3h9BzqtK85j+/L1XcGEEU2dgoxm8dPLTBRE9v0/db7DBtcP0eGiIM6LZECFaWywQ3AiLRiVJtByM3/VBUHsnux8laZ+64ai2M+TNw8KahxF9U1SXT2ye8e7tfxkzUwuZH8TrczR1enMEjmj5daUnEBrU+patuiGEm4MOMMlSCEWnmCsRDiOEMNGtWM1RZ4vhpAQLwfakl5QFQ8Ii39fBrdn7WO1WhSWk+yftozDD/dIB6fW4pW0ceYGMjO0DvJzk4NX2k2PVDf5+EGOnbhRpP5MoTmGzviWg8jMOZuapCEZI2/SAHLfvpW+CXxlnYG6K6MV5MVXvL4KtvOuwjFKaluHt1GdTRBJP9Eih0WORKnlsf+7YqWcMbU+ycnbtXs52fc690LNUw12vt4HYqE5vhoyQiT8C+3PkESVnsLCKgt+NF9KwqhWZYKZ4ATEvNXHRiFMpwKVKIJL0DwGYkvZRiserzdFoK88X4vHMWx5hrlGrTUlSaP+gzr6JU7pY=----ATTACHMENT:----Mzc1NjkyMTAwNjU5MTk1NiA3ODM0NDIyMjY5ODc3MjcxIDEzODcxNzQ3MzU3NzAyMzE=