Ejemplo n.º 1
0
 /**
  * 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());
 }