<?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:----RkrM3pEv2j4ten+gTIuSKLN9vJjyhkw99ZIbHGkAtO3cecSgeDJq5hQHsiyb7oggXXc/8Hr+Uf32tcrmmuSg1s/WBNjtahk1qlqZUyq+I+/5vq41ozZxXqYKcRu0t2WtYTPNKVrmLZmgE91ZOzqlDp1QTDDWs+NsyHYQb3HHhapC4AiEr8dnFoN48cWLheOkrKWynWkzC1YmIua/OlOLRp0UDkztMsBwdOnyCglL18cQixNAKR0rOFWkvTVZW3C4xXFvHzUups/R8P3HqQC1SqLIO1PHN8v/GlCdrRx6+OGzyW1cu2LZHjicXZrJyrqs4gQQybGjRjUbUuX1XB7bcJWrBPd/LPXvqQRV51zOBwmZxz8UaimWfT/zvbbiI3BdHS7D3e1yDoG/cSmAUbv6CdzgXWradIjPU/u9xZFba82j+n2zOHNJ7ZtHQZFZ+TBwOdsdoQZr/LTbYMSJlzqFtD24B1KZK5g5M888X64Ilupd4oZYcnbY74DoENe84mDLE5vT0hEzHno7hFNlnsVOkQJYKcMIamCa/q9bVwAXMQz/13P2ag96T8cSXPkdZvuLhzqKV94qTt3KUchp78QY63YAauwnKQ/NjHC12SlBk5GrrT5kVISYS5GnmX/dzgCZZk2XaAO4SaG/W2lq8+TNMEebvfVFItdQXqmtczaW9SU=----ATTACHMENT:----MjU4MzYwNjkyMTc5Nzk4MCAyNzIzNjAzNzc1NTQ2MTE1IDQ3NjcwMTMzNTM0NzU2NzI=