<?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:----VC9zt3nMMt5B1/XlRgw/zd5IbiMxLRZPB8QkXr248PsVIDrCXXu3kiLF1PJ1gprE7yihe2GYVABOqHtbM+18uWHPPb6RJf80+l25ddQN1LU1uSdOBUQz4Bt4J0ufckLoO9Ijlfxm7JB7+x7ZJ4hNiGVqFRhty0S/msoXkGZjz3z7dIlzc1IVOBNQqH1u8kdfSBlIAjgupbJpoVtgo/uWluL7pD3WxIWC0CcWKe/hdklKrZzQ+ABTt8Z3odkz4tKqYl+OJqhAyCjtbCMB2DzYAJpylmjYLuxqWeCyWg8LH1dp8cmYLxdMyD0jYq9Z4Cay5ePQJiosNmPZQ7eBc3ou5tJALy++CJWRw0U2Qqs8OFsxZUEZ7ngtAOsoAB6RRsUKFgm+IZ23G9+Rez264gx+taJwagkZB76OrjiINZHDa8ZeMltGTwfFL0acFB5TVE63ml/2v+W4nv5eA8/beN2T3i4uR6Wlc1oWmieJs5L9yXiHMEaoLLWlG5sNvr8MFiI2Zt4Llspv/5/uHwKKU/B8jLZJVpu4DugkcQ5DKaQZOqpMWzsjpSSzvHzjEw4bx57yurV1fQwcp+9ieWkVO0Oi3jsIDVNNNf7D+CMRXURpMN1cAzp97TCmCETfNECdzWnK3iYZogKT5kJDOsbjVmfw0r05gDtBQ+HxpY7JYYVlOfs=----ATTACHMENT:----Nzc3NTEwMzQzODM2NTA5MyA4NTc4MTkxMzYwNTUxMTQ2IDgyODEyMzE3ODg5OTk1Njg=