/**
* Build the SQL Query for an aggregate
*
* @param Tx_PtExtlist_Domain_Configuration_Data_Aggregates_AggregateConfig $aggregateConfig
* @return string
*/
protected function buildAggregateFieldSQLByConfig(Tx_PtExtlist_Domain_Configuration_Data_Aggregates_AggregateConfig $aggregateConfig)
{
$supportedMethods = array('sum', 'avg', 'min', 'max', 'count');
if ($aggregateConfig->getSpecial()) {
$aggregateFieldSQL = $aggregateConfig->getSpecial();
} else {
Tx_PtExtbase_Assertions_Assert::isInArray($aggregateConfig->getMethod(), $supportedMethods, array('info' => 'The given aggregate method "' . $aggregateConfig->getMethod() . '" is not supported by this DataBackend'));
$aggregateFieldSQL = strtoupper($aggregateConfig->getMethod()) . '(' . $aggregateConfig->getFieldIdentifier() . ')';
}
$aggregateFieldSQL .= ' AS ' . $aggregateConfig->getIdentifier();
return $aggregateFieldSQL;
}
public function testGetSpecial()
{
$aggregateSettings = array('fieldIdentifier' => 'field1', 'method' => 'avg', 'special' => 'sql');
$aggregateConfig = new Tx_PtExtlist_Domain_Configuration_Data_Aggregates_AggregateConfig('agg2', $aggregateSettings, $this->configurationBuilderMock);
$this->assertEquals('sql', $aggregateConfig->getSpecial());
}
