public function testCombineFilters()
{
$filter1 = new Statsomatic_Filter_MainColumnFilter(new Statsomatic_Variable('PROVIDER2', 'variable2', 'varchar'), 'eq', 'abc');
$filter2 = new Statsomatic_Filter_DetailsRowAnyFilter(new Statsomatic_Variable('PROVIDER1', 'variable1', 'int'), 'lt', 3);
$filter1->apply($this->query);
$filter2->apply($this->query);
$this->assertEquals("SELECT m1.entry_id FROM statistics_main AS m1 WHERE m1.PROVIDER2_variable2 = :ezcValue1 AND m1.entry_id IN ( SELECT d1.entry_id FROM statistics_details AS d1 WHERE d1.provider = :ezcValue2 AND d1.variable = :ezcValue3 AND d1.value_int < :ezcValue4 )", $this->query->getQuery());
}
public function testFilterAndSelect()
{
$filter1 = new Statsomatic_Filter_MainColumnFilter(new Statsomatic_Variable('PROVIDER2', 'variable2', 'varchar'), 'eq', 'abc');
$filter2 = new Statsomatic_Filter_DetailsRowAnyFilter(new Statsomatic_Variable('PROVIDER1', 'variable1', 'int'), 'lt', 3);
$select1 = new Statsomatic_Select_MainColumnSelect(new Statsomatic_Variable('PROVIDER2', 'variable2', 'varchar'), new Statsomatic_Aggregator('ID'));
$select2 = new Statsomatic_Select_DetailsRowSelect(new Statsomatic_Variable('PROVIDER1', 'variable1', 'int'), new Statsomatic_Aggregator('MAX'));
$filter1->apply($this->query);
$filter2->apply($this->query);
$select1->apply($this->query);
$select2->apply($this->query);
$this->assertEquals("SELECT m1.PROVIDER2_variable2 AS value1, MAX(d2.value_int) AS value2 " . "FROM statistics_main AS m1 LEFT JOIN statistics_details AS d2 ON m1.entry_id = d2.entry_id " . "WHERE " . "m1.PROVIDER2_variable2 = :ezcValue1 " . "AND m1.entry_id IN ( " . "SELECT d1.entry_id FROM statistics_details AS d1 WHERE d1.provider = :ezcValue2 AND d1.variable = :ezcValue3 AND d1.value_int < :ezcValue4 " . ") " . "AND d2.provider = :ezcValue5 AND d2.variable = :ezcValue6 " . "GROUP BY m1.PROVIDER2_variable2 " . "ORDER BY m1.PROVIDER2_variable2 DESC, MAX(d2.value_int) DESC", $this->query->getQuery());
}
/**
* @dataProvider filterData
*/
public function testApplyFilter($comperator, $value, $type, $sql)
{
$filter = new Statsomatic_Filter_DetailsRowAnyFilter(new Statsomatic_Variable('PROVIDER', 'variable', $type), $comperator, $value);
$filter->apply($this->query);
$this->assertEquals('SELECT m1.entry_id FROM statistics_main AS m1 WHERE m1.entry_id IN ( SELECT d1.entry_id FROM statistics_details AS d1 WHERE d1.provider = :ezcValue1 AND d1.variable = :ezcValue2 AND ' . $sql . ' )', $this->query->getQuery());
}
