/**
* Test sql aware.
*
* @todo create reliable test data
*/
public function testSQLAware()
{
$resultList = new ZMResultList();
$resultSource = new ZMObjectResultSource('ZenMagick\\StoreBundle\\Entity\\Order\\Order', 'orderService', 'getAllOrders', array(1));
$resultList->setResultSource($resultSource);
$sorter = new ZMOrderSorter();
$sorter->setSortId('date');
$sorter->setDescending(true);
$queryDetails = $sorter->getQueryDetails();
$resultList->addSorter($sorter);
$filter = new ZMOrderStatusIdFilter();
$resultList->addFilter($filter);
$resultList->setPageNumber(3);
$orders = $resultList->getResults();
echo 'is final source: ' . $resultSource->isFinal() . "<BR>";
echo "# of pages: " . $resultList->getNumberOfPages() . "<BR>";
$locale = $this->get('localeService');
foreach ($orders as $order) {
echo $order->getId() . ' ' . $locale->longDate($order->getOrderDate()) . "<BR>";
}
}
/**
* Test empty.
*/
public function testEmpty()
{
$resultList = new ZMResultList();
$resultList->setResultSource($this->getResultListSource(0));
$this->assertEquals(10, $resultList->getPagination());
$this->assertEquals(0, $resultList->getNumberOfResults());
$this->assertEquals(0, $resultList->getNumberOfPages());
$this->assertEquals(0, count($resultList->getResults()));
}
