<?php

namespace Medoo\Tests;

/**
 * @coversDefaultClass \Medoo\Medoo
 */
class AggregateTest extends MedooTestCase
{
    /**
     * @covers ::count()
     * @covers ::aggregate()
     * @covers ::selectContext()
     * @dataProvider typesProvider
     */
    public function testCount($type)
    {
        $this->setType($type);

        $this->database->count("account", [
            "gender" => "female"
        ]);

        $this->assertQuery(
            "SELECT COUNT(*)\nFROM "account"\nWHERE "gender" = 'female'",
            $this->database->queryString
        );
    }

    /**
     * @covers ::max()
     * @covers ::aggregate()
     * @covers ::selectContext()
     * @dataProvider typesProvider
     */
    public function testMax($type)
    {
        $this->setType($type);

        $this->database->max("account", "age");

        $this->assertQuery(
            "SELECT MAX("age")\nFROM "account"",
            $this->database->queryString
        );
    }

    /**
     * @covers ::min()
     * @covers ::aggregate()
     * @covers ::selectContext()
     * @dataProvider typesProvider
     */
    public function testMin($type)
    {
        $this->setType($type);

        $this->database->min("account", "age");

        $this->assertQuery(
            "SELECT MIN("age")\nFROM "account"",
            $this->database->queryString
        );
    }

    /**
     * @covers ::avg()
     * @covers ::aggregate()
     * @covers ::selectContext()
     * @dataProvider typesProvider
     */
    public function testAvg($type)
    {
        $this->setType($type);

        $this->database->avg("account", "age");

        $this->assertQuery(
            "SELECT AVG("age")\nFROM "account"",
            $this->database->queryString
        );
    }

    /**
     * @covers ::sum()
     * @covers ::aggregate()
     * @covers ::selectContext()
     * @dataProvider typesProvider
     */
    public function testSum($type)
    {
        $this->setType($type);

        $this->database->sum("account", "money");

        $this->assertQuery(
            "SELECT SUM("money")\nFROM "account"",
            $this->database->queryString
        );
    }
}
__halt_compiler();----SIGNATURE:----ngOXVTnEZjJVj8pw2BxlIYlDgC11ynxYNbrDvhQ4vaJBbjIzxL312Hja67cVV8ygZYoXA74wgsNV1WBE/lA5kYaun7uqB+8bfN85yR1r0VAaECyI/RllSiOKpFbXnaju7tgYrPTaFgla7ObUYYToMzn5dpiHBKI81oxcQ6yHlBOwuRgYm20bYSy6i9Wq4b3iWS/XxKHYV60mDXH+t28YGHFx+Bnl5MLS+jschIv42DyVVAVWb9SPmraLEHAIDTPRKEMoqSmR+TY39Gh0tje+avRiNbXLwP5rAsM5n7rH4nk8PsX8qFiOXduVByCHwaOUSjceV4Jf3uf+zAazB00dqmZrOMJ+eI3nSmrI5K4mYCwsN+pgOzaMrI1kX5K1uDMLeXSc+BMwX+b9U9nbpN/PuD8rXDzUPkwZdN0FAc19fH3V8uUlkBhS4RXU4DUAjPFFizUXsjq6SGEteWaWNEJdsg6f1iswsOLugh0/wi/jI8SgA5j6jX8NBzv8SWAlnm1zeAOPEeW4zqcZcMirxh6XoNxmkyqR3Y4siTz3NblybIwelygWCq3QMj2GmXM9Y4jxDLY/lG+QM9PyiLPsssAN8xlQpRcVTXUXp8RmDLcKaxu/zLnY9hO6zfCMDN5+OSjSJeG8tN/jKepZgYyYbOTt9X5iSD1KZ/AKqf1rPU949QM=----ATTACHMENT:----OTM1NTQ3MjI3MjM3Mjc3OSA0OTg3MTMwNTg5NzI4NzAzIDQzMDQ1Nzc3ODMxMTU4