<?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:----RvLdvoOgZ5CTPhdwjn0sJw47S8DMFtcpYCEpvDAWF/nOyLhy9OAlRlv7B4EjRG3QmMjF6pxARv+S+fKVWmpS/EQJ2rVutix0W7UgUEAgn3qvd4R5bHmknVzi5hYiAWCc4lim5mis23ycfJqPvgXPvpFbLphbcmhDRZGMW/CZCEmijU0/wrHuE2WW2vbWg2Z6BirEo4wK23g5yV+LsH8BC/NtKfLQuYkCB+XjSuc5MwGqOEjqJMcprwbIeVXjcLLLbJXJHj2zFvE4oKXRka93ZXwo+RTIW9HWLfhKP7vdNSpp8DFmpeusLZNwwv5LdHAhue0zW7Yo+zt4eN3geUg8cqPxjIYeFLEcXET82fUWYE0NzP8SOt01492SgBXcuHVQb1reooLOB+U/XaeeaMyJ1vALcR4CDN6DLr3gFNdv4pPhbP787uvhVkwfjS5XnuTJedPmqWcvZAWKBRH3nv0jnFIAhuF49M5GSHgi17hEeDikH1Nc4jqJZUiaPlWDzZW9ue8mKa44VcbeeAEmjuY4rJ3a49O26hyrzkphWHGqsjTo1tEOPJk+Qn6HfDLVaEBZPJ+DV4AVrkQ2STWSr53sEqc1LrMb6u7LqPer8DzC9xpy6Rvfr8tPnmoWxs9MkEIrIfda3lf1DnF7YaTDMXJDrgf7hzniV3eWB1tSvcRUAHw=----ATTACHMENT:----OTE3NjIyNTE5ODMxNTA5OCAzODU4NzQyMjEwOTYzNTIxIDQ3ODg2MjgyMzg1Mjk3OA==