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); }