public function testSumIsCalculatedOnRepository()
{
$examples = new Collection("Company");
list($sumTotal) = $examples->calculateAggregates([new MySqlCountDistinct("CompanyName")]);
$this->assertEquals(2, $sumTotal);
$lastStatement = MySql::getPreviousStatement(false);
$this->assertContains("COUNT( DISTINCT `CompanyName` ) AS `DistinctCountOfCompanyName`", $lastStatement);
}
public function testSumIsCalculatedOnRepository()
{
$examples = new Collection("Company");
list($sumTotal) = $examples->calculateAggregates([new MySqlAverage("Balance")]);
$this->assertEquals(3, $sumTotal);
$lastStatement = MySql::getPreviousStatement(false);
$this->assertContains("AVG( `Balance` ) AS `AverageOfBalance`", $lastStatement);
}
public function testSumIsCalculatedOnRepository()
{
$examples = new Collection("Company");
list($sumTotal) = $examples->calculateAggregates([new MySqlSum("Balance")]);
$this->assertEquals(6, $sumTotal);
$lastStatement = MySql::getPreviousStatement(false);
$this->assertContains("SUM( `Balance` ) AS `SumOfBalance`", $lastStatement);
$examples = new Collection("Company");
$examples->filter(new GreaterThan("Balance", 1));
list($sumTotal) = $examples->calculateAggregates(new MySqlSum("Balance"));
$this->assertEquals(5, $sumTotal);
$lastStatement = MySql::getPreviousStatement(false);
$this->assertContains("SUM( `Balance` ) AS `SumOfBalance`", $lastStatement);
$this->assertContains("WHERE `tblCompany`.`Balance` > ", $lastStatement);
}
public function testSum()
{
$examples = new Collection("Example");
list($sumTotal) = $examples->calculateAggregates([new Sum("CompanyID")]);
$this->assertEquals(6, $sumTotal);
}
