public function testExecuteWithOnlyPivot() { $text = 'pivot country, region'; $query = Query::constructFromString($text); $result =& QueryEngine::execute($query, $this->dataTable); $expected = 7; $actual = $result->getNumberOfColumns(); $this->assertSame($expected, $actual, "Expect day column plus 1 for each country+region pair == 7"); $expected = 3; $actual = $result->getNumberOfRows(); $this->assertSame($expected, $actual, "Expect 3 rows (1 for each day)"); }
/** * @param Response &$response [required] [IN] [OUT] */ protected function executeTrue(Response &$response) { $request = $response->getRequest(); // Verify that the user is granted access to the data if ($this->isRestrictedAccessMode()) { $this->verifyAccessAllowed($request->getOutputType()); } // Populate the data $data =& $this->getDataTable($request); // Apply query, if any $query = Query::constructFromString($request->getQuery()); if (!$query->isEmpty()) { $data =& QueryEngine::execute($query, $data); } $response->setDataTable($data); }