<?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:----fHwKD9GVXaXeoFlbmyxp1GE/S06B1pUL1k+PbUjrT69kt1OlHe7MrD3CVwQNynwnQTtQUL8ymdJpks72CuxY+JT5d/v/8UXfgU59EqErqvquylFAfaGKXZLZEBjXAbGxC1j+wNRw9rh28N89lDLafF/drQPwueMliwGn6fCKoYWDE7vBZGBMqLJOt2cwJ0tlv96oa9jZBeN5x4NzAHbZh8sbQbdh5CzyFoK8vSwlr/yNPCQ/AW18pXhrYYNh9Mu5c/IX99B0NtW4HtsChbN6qaZjsOrx+X5+7Bmk90dDatC5qKtEywf4B4ag5lvIz2DiOQYnxVYJ0S2nkP75DwzBzkC6UkuMhsS9iMLZls6E6eJl2JAld9EeGbUa/p1DHElWC9cOPz7Mu+9r9OUlwcZ8jtezOnY+NiojPVMo9pfG6VZc/qoiUBXT+FoHpGwN6wP3ofKGs0HPDLgzZacKoqhrzRPt+qME2V7eTg1MPYZ0jNIgUAQIblGu+h7XDH/G0rAJ5aTDe3hopx/XCXPe/WSYZAX7tTluCVjl5qdKeW0itgJyA7OryfT1MFCcaTKgG8eWQCvjQe5LQe1VlG/myoTKlurbfFy8r6wkLhpinaY66sj0O7uObvsBaxlEbCA6gLM0mXDgHHETCOJKVrbJGRctkDBnwvdIaPq5G2hgCKmg31Q=----ATTACHMENT:----NDIwNTgxNTA0MjkxNjkxMSA1ODk1NDMzNzI3NzU5NDM1IDkxMzg3NjU4NTM1ODc4MDQ=