<?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:----q1FOBQhptU9BRIA0xKGP1xyxd6Q13tgQTSnVGMtHzhE4j7EmgbgzHPwxrxf6BRQFsjJmT5UzcLdOh2s1Zk2JgFXQpQLzv6QolwQ+BNv4pZd/33IQWTCoLBdWOYEYCJTgrWVgskVEVNs26MB9s6rkTApyZTWN41AOvhMtcigelP2tUjMZS9rBNp68EyF1A/WhTYgIu9oVlFRDv4mMw3fTdXhCA8k9R4oLXRKbeSUrwHnMgDmEd/gHBlz2uU8ktzc4aYf0LhLdK8z6MLBwk++3q/Mol95z7qiMiABHlRUrA0WXB0m4AcXFSJb0Noz8rwOge0XgK/t1xw4eiJ556ozj383+7JfXRwC+IXG6Gl36OskPzMC7rnFUx1h+4QPjX2WhLlB968cQczVJTlhdN3+YR6/4lqumxmv633eHtWVdQVs7IHNmZ8qgemocwSO0ypJtdHpgi9DS3bl0H6I2Cp/JY+r4dYhcN33GOppVL6b1Xg+6uW8UhFbNOyJu86/EOYkq+7yta0aLje7PKewUhToh4DGKwGmj3MtjH2HLgqPqSqn4fKLfjJLuvWKUM4d3Mnq3N961iSiY1zlEHIuHzl53AwnEtAMPh5KZSCJdCe2xw3hGeHPtz6m3vlp+i6SEPf/siX4IN/MLH1uBUg9RHHphtLeW0Y5piXoehb5xwCvyLWU=----ATTACHMENT:----ODQ5MDE2Njc2ODYyMjQ4MiA5NjE2OTE4NTc3ODI4MTIgNjIxOTE2MjQ4NzU2MzA=