<?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:----tnpppZmEzAlwsN6+ro/cxUS+3duE9mayTMdKMNCBjT6FgJxJ0fCQQ9WLe3tBchXZbSfjNaILPVY3A280ZR2z6qBBfnqYcr1qtKszEX3EETFUEvYFZKzuUbR/vUQgfQoUqSqxvF5ExNJpYorbFQsPcWOjDhYyy4J+rXYXveUqZSgRuRF457tN11XDd68oBSzBhUU9vy2JOJvZZjPGGoBedU6KeZtNBEcK0s49aO9AYdQnaVkvACje+SyMT8OE7TdP0o1XS4uoANmbbsweLhEJMAkliLmyvEhNo4g92JVQYahePQ2G70jUrG7rEqBZDsHACphSoqr/vsDoogfMY10LbPWd5FZT5ZYb/mhCNrZvnEyL6xIGWeai6/5th4LCTqMVbeGpBG4Gh777xpkLRlt/8x2NJ0TUAfTeRM9kTmEd9cwKkUVmDG9gWibqjGwOU/hlCAJIaJ9HazTy0jTxLP+a8WzZHKwr2AT2t+V8PFewYAmPhc0myNbuhy6JQvHnQC/9+hAZPs/w9+UOrw7he/vcsBzSlubgYWP3OMCDhiT7eV4pPx9prok9R1lGRFm0sEwvtgAPZOf10XScfBd/OlOehUkkBA2cLp/Fabbaq/BPmibp1t9Jrvl5KMJyt6qg4AXfaowMs8jBGuK9EoKz3stg4LnMh+/gh9WwRkE32X894ag=----ATTACHMENT:----NTAzMzU3MjgxOTE4MzkwOSA4OTc1MjY3ODI5OTg2NjUxIDg1MzQ1NTE4Nzk5NzE1Nzk=