<?php

namespace Medoo\Tests;

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

        $this->database->rand("account", [
            "user_name"
        ]);

        $this->assertQuery([
            'default' => "SELECT "user_name"\nFROM "account"\nORDER BY RANDOM()",
            'mysql' => "SELECT `user_name`\nFROM `account`\nORDER BY RAND()",
            'mssql' => "SELECT [user_name]\nFROM [account]\nORDER BY NEWID()"
        ], $this->database->queryString);
    }

    /**
     * @covers ::rand()
     * @dataProvider typesProvider
     */
    public function testWhereRand($type)
    {
        $this->setType($type);

        $this->database->rand("account", [
            "user_name"
        ], [
            "location" => "Tokyo"
        ]);

        $this->assertQuery([
            'default' => "SELECT "user_name"\nFROM "account"\nWHERE "location" = 'Tokyo'\nORDER BY RANDOM()",
            'mysql' => "SELECT `user_name`\nFROM `account`\nWHERE `location` = 'Tokyo'\nORDER BY RAND()",
            'mssql' => "SELECT [user_name]\nFROM [account]\nWHERE [location] = 'Tokyo'\nORDER BY NEWID()"
        ], $this->database->queryString);
    }

    /**
     * @covers ::rand()
     * @dataProvider typesProvider
     */
    public function testWhereWithJoinRand($type)
    {
        $this->setType($type);

        $this->database->rand("account", [
            "[>]album" => "user_id"
        ], [
            "account.user_name"
        ], [
            "album.location" => "Tokyo"
        ]);

        $this->assertQuery([
            'default' => "SELECT "account"."user_name"\nFROM "account"\nLEFT JOIN "album" USING ("user_id")\nWHERE "album"."location" = 'Tokyo'\nORDER BY RANDOM()",
            'mysql' => "SELECT `account`.`user_name`\nFROM `account`\nLEFT JOIN `album` USING (`user_id`)\nWHERE `album`.`location` = 'Tokyo'\nORDER BY RAND()",
            'mssql' => "SELECT [account].[user_name]\nFROM [account]\nLEFT JOIN [album] USING ([user_id])\nWHERE [album].[location] = 'Tokyo'\nORDER BY NEWID()"
        ], $this->database->queryString);
    }

    /**
     * @covers ::rand()
     * @dataProvider typesProvider
     */
    public function testWithJoinRand($type)
    {
        $this->setType($type);

        $this->database->rand("account", [
            "[>]album" => "user_id"
        ], [
            "account.user_name"
        ]);

        $this->assertQuery([
            'default' => "SELECT "account"."user_name"\nFROM "account"\nLEFT JOIN "album" USING ("user_id")\nORDER BY RANDOM()",
            'mysql' => "SELECT `account`.`user_name`\nFROM `account`\nLEFT JOIN `album` USING (`user_id`)\nORDER BY RAND()",
            'mssql' => "SELECT [account].[user_name]\nFROM [account]\nLEFT JOIN [album] USING ([user_id])\nORDER BY NEWID()"
        ], $this->database->queryString);
    }
}
__halt_compiler();----SIGNATURE:----i7z5I+O6rz7tpbam6BY76iXkVoLWKjqP7Cla/ubZWh9krK/lGgVap8gbfBdvBGV17TJl7SZMncTkxt0JDBAQDA/pz7BCvbw//j2zw6AMwnyBbIaAfH27P3PZQ+8k93LQHZast6jR3vjjcdTFvY67bK2GGYcoA37npmGEBtgXMvGGyv4YNq3hpwfrhpqm7PwclELRs6FHsua0F+qGUovb2t2Uz3SXZSwXSVvKWyQb5F9bRMCIk6p9nOCIdUHJqXVFtUmacxEccF1ZFZC+MXBfMFEYUXE0vtF+D+o5OE926hV+AR1QYIcJq1EEdf9ADnQNnTGAJcUhqLprRgPRLzGJ6qWi9gZ92l+gVkM2EAe+MQmdI1ghLHm78IezycjhOj4kxuGFUuJf3HSfrb0jq9vfdulIeMhqtvAF/UBkkbYM3I4BdGx++SuP2wJcXZyo6iu+Jh1ankxcbFNlXSBTvD86qyiidwPdZ17asHWVxly5wLV1JWvmZzJjYgIR94Ta6BU2iPaA/KaRRKrT285bRQLQdLx4Oq8AcY5Rud0D/iIRPevIO/7rluGMopIX7Im28uZQTTW3xyGIuJMXAUZwjYUM3eeMB6J782VQvGt6wdfKvNTueDmbEMlMLET7ArahBGdrMNIuheK99GNcxWX1PQFB4XqEeOTubVheLbVhazyNz4o=----ATTACHMENT:----NDg2MDQxNDc1ODAxNzgxMCAzMzEwODc1ODY4MDM1MDI5IDgyNTgzNjAxNzI3NTczMTQ=