/** * 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 testGetIndetifier() { $this->assertEquals('agg1', $this->aggregateConfig->getIdentifier()); }